How to rebuild the Reserve Library by ORACLE DATAGUARD

What this article shares with you is about how ORACLE DATAGUARD rebuilds the library. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article. Without saying much, follow the editor to have a look.

Database version: 11.2.0.4

Operating system version Linux 5.5

Reconstruction step

1. Delete all data files, log files and control files in the repository.

Cd / opt/oracle/oradata/standby

Rm-rf *

Enter the flashback area and delete control02.ctl

2. Back up the parameter files and password files of the backup library.

Cd $ORACLE_HOME

Cp spfilestandby.ora spfilestandby.ora0713

Cp orapwstandby orapwstandby0713

3. Enter the main library and connect with the secondary library.

Rman target / auxiliary sys/oracle@standby

4. Copy data files, log files, control files, password files and parameter files of the main library to the standby library.

Duplicate target database for standby from active database

5. Open the library.

Alter database open

6. Application log

Alter database recover managed standby database using current logfile disconnect

7. Check the log application status

Select sequence#,applied from v$archived_log

8. Check whether gap exists

Select * from v$archive_gap

The above is how ORACLE DATAGUARD rebuilds the library, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.