Standby database start tips for Oracle database

No comments
# 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