Reconstruction after physical DG slave database corruption

Reconstruction after physical DG slave database corruption

Because the data is rebuilt, the data files, log files, and dump files in the physical slave database that were rebuilt in the original DG Environment can be deleted. Remember that the original parameter files and corresponding directories must be saved.

Full backup of standby control files and databases in the master database

[Oracle @ localhost rman_recover] $ rman target/

Backup Control File

RMAN> backup current controlfile for standby format'/u01/rman_recover/ctlfile. bak ';

Back up the entire database

RMAN> backup database format'/u01/rman_recover/% full_backup _ % T _ % t. bak ';

Find the control file path on the slave database:

SQL> select name from v $ controlfile;

NAME

---------------------------------------------

/U01/app/oracle/oradata/orcl_s/control01.ctl

/U01/app/oracle/oradata/orcl_s/control02.ctl

/U01/app/oracle/oradata/orcl_s/control03.ctl

 

SQL> shutdown abort

ORACLE instance shut down.

Copy the backup of the master database to the slave Database

[Oracle @ localhost ~] $ Scp 10.37.11.11:/u01/rman_recover/*. bak/u01/rman_recover/
 
Oracle@10.37.11.11's password:

0ull_backup_20140522_848228743. B 100% 7072KB 6.9 MB/s

7ull_backup_20140522_848228595. B 100% 1002 11.9 MB MB/s

Ctlfile. bak 100% 7040KB 6.9 MB/s

Verify different conditions of using ARCH/LGWR and standby log in the maximum DG Performance Mode

Copy the control file to the original configuration:

[Oracle @ localhost rman_recover] $ cp ctlfile. bak/u01/app/oracle/oradata/orcl_s/control01.ctl
 
[Oracle @ localhost rman_recover] $ cp ctlfile. bak/u01/app/oracle/ora

Data/orcl_s/control02.ctl

[Oracle @ localhost rman_recover] $ cp ctlfile. bak/u01/app/oracle/ora

Data/orcl_s/control03.ctl

 

Start the slave database instance:

SQL> startup nomount

ORACLE instance started.

 

Total System Global Area 167772160 bytes

Fixed Size 1218316 bytes

Variable Size 75499764 bytes

Database Buffers 88080384 bytes

Redo Buffers 2973696 bytes

For more details, please continue to read the highlights on the next page:

1 2 Next Page