| raj |
Posted: Dec 25, 2007 12:38:49 AM |
Total Post: 15
Joined: Aug, 2007
|
how to make in open database into nomount stage without shutdown |
|
|
 Vinod |
| Posted: Dec 25, 2007 04:18:22 AM |  |
|
Total Post: 54
Joined: Oct, 2007
|
Hi Raj,
During switchover to physical standby database the former primary database can change to nomount state without a graceful shutdown.
But still the former primary database should be shutdown and mounted as a standby database for managed recovery to happen.
Thanks & Rgards,
Vinod
|
|
|
|
|
| Soumya |
| Posted: Dec 25, 2007 05:00:13 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
Hi,
You may use following to dismount your database without shutting down.
SQL> ALTER DATABASE CLOSE ;
Database altered.
SQL> ALTER DATABASE DISMOUNT ;
Database altered.
SQL> SELECT OPEN_MODE FROM V$DATABASE ;
SELECT OPEN_MODE FROM V$DATABASE
*
ERROR at line 1:
ORA-01507: database not mounted
But to bring up the database you need to shut down and startup again.
" [
mounted and dismounted the database which is only allowed once in its lifetime. ]"
Thanx
|
|
|
|
|
| Vinod |
| Posted: Dec 25, 2007 06:11:57 AM | |
|
Total Post: 54
Joined: Oct, 2007
|
Hi
This should also be fine but it till requires a manunal shutdown startup
after that , so ultimately in high availability environment there is no gain out of this .
QL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00750: database has been previously mounted and dismounted
Alert log:-
Tue Dec 25 18:44:29 2007
ALTER DATABASE CLOSE
Tue Dec 25 18:44:29 2007
SMON: disabling tx recovery
Tue Dec 25 18:44:29 2007
Stopping background process CJQ0
Tue Dec 25 18:44:29 2007
Stopping background process QMNC
Tue Dec 25 18:44:30 2007
Stopping Job queue slave processes
Tue Dec 25 18:44:50 2007
Job queue slave processes stopped
Tue Dec 25 18:44:50 2007
SMON: disabling cache recovery
Tue Dec 25 18:44:50 2007
Shutting down archive processes
Archiving is disabled
Tue Dec 25 18:44:55 2007
ARCH shutting down
ARC2: Archival stopped
Tue Dec 25 18:45:00 2007
ARCH shutting down
ARC1: Archival stopped
Tue Dec 25 18:45:05 2007
ARCH shutting down
ARC0: Archival stopped
Tue Dec 25 18:45:06 2007
Thread 1 closed at log sequence 37
Successful close of redo thread 1
Tue Dec 25 18:45:06 2007
Completed: ALTER DATABASE CLOSE
Tue Dec 25 18:45:23 2007
ALTER DATABASE DISMOUNT
Tue Dec 25 18:45:23 2007
Completed: ALTER DATABASE DISMOUNT
==============
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00750: database has been previously mounted and dismounted
Thanks & Regads
Vinod
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 25, 2007 08:10:21 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Once your database is nomount stage you can't open your database without mount.
means you have to first mount your database then after you can open it.
and NO need to shutdown database for open your database from nomount stage.
|
|
|
|
|
| Vinod |
| Posted: Dec 25, 2007 11:26:59 AM | |
|
Total Post: 54
Joined: Oct, 2007
|
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Dec 25 17:21:01 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options
SQL> alter database close;
Database altered.
SQL> alter database dismount;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00750: database has been previously mounted and dismounted
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 331350016 bytes
Fixed Size 2029912 bytes
Variable Size 163579560 bytes
Database Buffers 163577856 bytes
Redo Buffers 2162688 bytes
Database mounted.
Database opened.
|
|
|
|
|
| Vinod |
| Posted: Dec 25, 2007 01:27:44 PM | |
|
Total Post: 54
Joined: Oct, 2007
|
SQL> alter database close;
Database altered.
SQL> alter database dismount;
Database altered.
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00750: database has been previously mounted and dismounted
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> shutdown abort;
ORACLE instance shut down.
rm -rf *.*
How to proceed now ?
|
|
|
|
|
| Murtuja |
| Posted: Dec 25, 2007 11:27:34 PM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
Have you tried "Startup force;"
|
|
|
|
|
| Vinod |
| Posted: Dec 26, 2007 02:23:04 AM | |
|
Total Post: 54
Joined: Oct, 2007
|
Alert Log :-
alter database close <==== A alter database close form SQL prompt
Wed Dec 26 15:05:46 2007
Stopping background process CJQ0
Wed Dec 26 15:05:46 2007
SMON: disabling tx recovery
Wed Dec 26 15:05:46 2007
Stopping background process QMNC
Wed Dec 26 15:05:48 2007
Stopping Job queue slave processes
Wed Dec 26 15:05:56 2007
Waiting for Job queue slaves to complete
Wed Dec 26 15:06:26 2007
Job queue slave processes stopped
Wed Dec 26 15:06:26 2007
SMON: disabling cache recovery
Wed Dec 26 15:06:26 2007
Shutting down archive processes
Archiving is disabled
Wed Dec 26 15:06:31 2007
ARCH shutting down
ARC1: Archival stopped
Wed Dec 26 15:06:36 2007
ARC0: Becoming the heartbeat ARCH
ARC0: Archiving disabled
ARCH shutting down
ARC0: Archival stopped
Wed Dec 26 15:06:37 2007
Thread 1 closed at log sequence 37
Successful close of redo thread 1
Wed Dec 26 15:06:37 2007
Completed: alter database close
Wed Dec 26 15:06:50 2007
alter database dismount <=== Alter database dismount issues from SQL
Wed Dec 26 15:06:50 2007 prompt
Completed: alter database dismount
Wed Dec 26 15:07:08 2007
Shutting down instance (abort) <====== There will be a shutdown abort when
License high water mark = 2 when a startup force is issued
Instance terminated by USER, pid = 4535 from SQL prompt
Wed Dec 26 15:07:08 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
sga_max_size = 209715200
__shared_pool_size = 71303168
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = /u01/app/admin/oracle/dbs/spfileORCL.ora
sga_target = 209715200
control_files = /u02/oradata/ORCL/control01.ctl, /u02/oradata/ORCL/control02.ctl, /u02/oradata/ORCL/control03.ctl
db_block_size = 8192
__db_cache_size = 121634816
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/u02/oradata/arch
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/admin/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/admin/oracle/admin/ORCL/bdump
user_dump_dest = /u01/app/admin/oracle/admin/ORCL/udump
core_dump_dest = /u01/app/admin/oracle/admin/ORCL/cdump
audit_file_dest = /u01/app/admin/oracle/admin/ORCL/adump
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 135266304
PMON started with pid=2, OS id=4586
PSP0 started with pid=3, OS id=4588
MMAN started with pid=4, OS id=4590
DBW0 started with pid=5, OS id=4592
LGWR started with pid=6, OS id=4594
CKPT started with pid=7, OS id=4596
SMON started with pid=8, OS id=4598
RECO started with pid=9, OS id=4600
CJQ0 started with pid=10, OS id=4602
MMON started with pid=11, OS id=4604
Wed Dec 26 15:07:09 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4606
Wed Dec 26 15:07:10 2007
starting up 1 shared server(s) ...
Wed Dec 26 15:07:10 2007
ALTER DATABASE MOUNT
Wed Dec 26 15:07:14 2007
Setting recovery target incarnation to 1
Wed Dec 26 15:07:14 2007
Successful mount of redo thread 1, with mount id 1170158366
Wed Dec 26 15:07:14 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Dec 26 15:07:14 2007
ALTER DATABASE OPEN
Wed Dec 26 15:07:14 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=4615
Wed Dec 26 15:07:14 2007
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=17, OS id=4617
Wed Dec 26 15:07:14 2007
Thread 1 opened at log sequence 37
Current log# 1 seq# 37 mem# 0: /u02/oradata/ORCL/redo01.log
Successful open of redo thread 1
Wed Dec 26 15:07:14 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Dec 26 15:07:14 2007
ARC0: STARTING ARCH PROCESSES
Wed Dec 26 15:07:14 2007
SMON: enabling cache recovery
Wed Dec 26 15:07:14 2007
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Wed Dec 26 15:07:14 2007
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=18, OS id=4619
Wed Dec 26 15:07:14 2007
Successfully onlined Undo Tablespace 1.
Wed Dec 26 15:07:14 2007
SMON: enabling tx recovery
Wed Dec 26 15:07:14 2007
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=4621
Wed Dec 26 15:07:15 2007
Completed: ALTER DATABASE OPEN
Wed Dec 26 15:07:15 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Dec 26 15:13:14 2007
Shutting down archive processes
Wed Dec 26 15:13:19 2007
ARCH shutting down
ARC2: Archival stopped
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
