ORACLE_DATAGUARD_Step byStep Guide on Creating Physical Standby Using RMAN DUPLICATE(Just rebuild the standby database.)
--- Filename: Rebuild the standby database using rman duplicate
Rebuild the standby database: 1. On the standby database: make the instance nomount, and start the listener # su - oracle $ env |grep ORACLE $ lsnrctl start <LISTENER_NAME> $ ps -ef|grep tns $ sqlplus / as sysdba SQL> startup nomount;
2. On the primary database: Duplicate the standby database # su - oracle $ rman target sys/password@primary auxiliary sys/password@standby RMAN> run { allocate channel prmy1 type disk; allocate channel prmy2 type disk; allocate channel prmy3 type disk; allocate channel prmy4 type disk; allocate auxiliary channel stby type disk; duplicate target database for standby from active database nofilenamecheck; }
3. On the standby database: Check the status of the standby database, and open the recover managed mode $sqlplus / as sysdba SQL> set linesize 400 SQL> select status from v$instance; SQL> alter database open; <======= If the database have mounted,please open. SQL> alter database recover managed standby database disconnect; SQL> select process,status,thread#,sequence#,block#,blocks from v$managed_standby; <==== Check the MRP and RFS processes
|