This discussion is archived
3 Replies Latest reply: Jan 7, 2013 3:26 AM by 615576 RSS

Copy controlfiles to standby

user521219 Newbie
Currently Being Moderated
Hello,
I will create a standby database 11g. For that, I need to copy all files from source server to new standby destination server.
sql> ALTER DATABASE BEGIN BACKUP;
-- copy all datafiles, redologs, tempfiles, controlfiles, etc. by o/s from source database server to standby server.
sql> ALTER DATABASE END BACKUP;
In source database, I have these controlfiles:
sql> select status, name, is_recovery_dest_file from v$controlfile;

STATUS  NAME                                                         IS_RECOVERY_DEST_FILE    
------- ------------------------------------------------------------ -------------------------
        D:\ORADATA\PROD\OPEXT\CONTROL1_1.CTL                         NO                       
        D:\ORADATA\PROD\OPEXT\CONTROL2_1.CTL                         NO                       
        C:\APP\ORACLE\PRODUCT\11.2.0\FLASH_RECOVERY_AREA\OPEXT\CONTR YES                      
        OLFILE\O1_MF_8F71JQLV_.CTL                                          
Do I need to also copy controlfile which is in flash_recovery_area?
Do I need to replace it in same path in standby server?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points