Friday, April 6, 2018

Rebuild standby from full rman backup

------ Rebuild standby from full rman backup

1. take backup of primary with archivelog
2. copy to DR
3. start database in nomount mode
3.1 Set cluster parameter off
4. restore control file
5. mount database
6. catalog backup
7. run restore command

run {
set newname for datafile 1 to '+DATA_P/datafile1';
set newname for datafile 2 to '+DATA_P/datafile2';
restore database;
switch datafile all;
recover database until canel;
}

8. once restore is done shut down database
9. mount database and create temp and redo logs files
10. convert into physical standby
11. set cluster parameter true and bounce db in to mount
12. start recovery 

No comments:

Post a Comment