Oracle

#Restore Standby#
____________________________________________________________________________________________________________
- Run the backup controlfile for standby.

RMAN> backup current controlfile for standby format '/u02/nbs/rman/ctrl_standby.bkp';
____________________________________________________________________________________________________________
- Copy parts backup, including backup controlfile.

[oracle@srvoraprod fisico]$ scp -p * oracle@129.1.7.250:/u02/oracle/backup/nbs/fisico
____________________________________________________________________________________________________________
- Close the base standby.

SQL> shut immediate;
____________________________________________________________________________________________________________
- Delete the files in the oradata, or in case of ASM delete the folder of database.
____________________________________________________________________________________________________________
- Change the init.ora, just put the name of diskgroup for not giving error that can not find the controlfile.

#*.control_files='+DISK1/nbs/controlfile/current.275.777998305'
*.control_files='+DISK1'
____________________________________________________________________________________________________________
- Open the base in order not mounted

SQL> startup nomount; pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initnbs.ora'
____________________________________________________________________________________________________________
- Restore the backup of controlfile for standby

RMAN> restore standby controlfile from '/u02/nbs/rman/ctrl_standby.bkp';
____________________________________________________________________________________________________________
- Close the base standby.

SQL> shut immediate;
____________________________________________________________________________________________________________

- Change the initi.ora, path with the name of the controlfile.