10/24/2012

Oracle Standby database start tips

Starting standby database  w\o activation

# sqlplus '/as sysdba'
SQL> startup nomount
SQL> alter database mount standby database;

Cheking ps -ef|grep ora       -- that oracle processes has been started
 On source db run :
SQL>alter system switch logfile;    

Cheking Alert log file for successfully starting Oeracle.

Starting standby database  with activation
SQL> startup nomount   
SQL> alter database mount standby database;   
SQL> alter database activate standby database;   
SQL> shutdown immediate   
SQL> startup mount   
SQL> shutdown immediate   
SQL> startup    































No comments:

Post a Comment

Popular Posts