Shulou(Shulou.com)06/01 Report--

Oracle Dataguard Reserve Library Reconstruction

1. Add an oracle directory

Mkdir / ora_data_1

Mkdir / ora_data_2

Mkdir / ora_data_3

2. Modify directory permissions

Chown oracle:dba / ora_data_1

Chown oracle:dba / ora_data_2

Chown oracle:dba / ora_data_3

3. Add a data file under the created directory

Alter tablespace users add datafile'/ ora_data_1/users02.dbf' size 1m autoextend off

Alter tablespace test add datafile'/ ora_data_2/test02.dbf' size 1m autoextend off

Alter tablespace test add datafile'/ ora_data_3/test03.dbf' size 1m autoextend off

4. Backup the master database to generate backup control files.

Backup current controlfile for standby format'/ tmp/control.ctl'

5. The main database prepares the database.

Backup database format'/ tmp/full_backup_%T_%t.bak'

6. Modify the parameter file of the preparation library and add the mapping relationship of the data file.

* .db_file_name_convert='/opt/oracle/oradata/orcl','/opt/oracle/oradata/standby','/ora_data_1','/opt/oracle/oradata/standby','/ora_data_2','/opt/oracle/oradata/standby','/ora_data_3','/opt/oracle/oradata/standby'

7. Configure NFS in the main database and provide it to the standby database for restoration.

Vi / etc/exports

/ tmp 192.168.56.* (rw)

Service nfs restart

8. Mount the NFS directory in the slave library and check whether it is mounted normally.

Mount-o rw,noac,hard,rsize=32768,wsize=32768,nolock 192.168.56.103:/tmp / dbbak

9. Enter the RMAN recovery control file

Rman target /

Startup nomount

Restore controlfile from'/ dbbak/control.ctl

10. Mount database and register the recovery directory

Alter database mount

Catalog start with'/ dbbak/full_backup_20170720_949796538.bak'

11. Restore database

Restore database

12. Open the database (if there is no standby logfile before the main library, you also need to create a standby logfile)

Alter database open

13. Application log

Alter database recover managed standby database using current logfile disconnect

14. Create a table in the main database to insert data, and switch logs for testing.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.