Output file name=+FRA/DEMO/CONTROLFILE/CONTROLFILE03. Output file name=+DATA/DEMO/CONTROLFILE/CONTROLFILE02.CTL file isn't the same thing as creating or restoring a control file. Output file name=+DATA/DEMO/CONTROLFILE/CONTROLFILE01.CTL Viewing Control File Names and Locations If your database is in a nomount state. Using target database control file instead of recovery catalogĬhannel ORA_DISK_1: SID=129 device type=DISKĬhannel ORA_DISK_1: copied control file copy RMAN> restore controlfile from '+DATA/DEMO/CONTROLFILE/CONTROLFILE01.CTL' Note: If you do not use ASM, the alternative method is that you skip below RMAN part and just do os copy of the control file to the new location, then mount and open your database.Ĭonnected to target database: DEMO (not mounted) SQL> alter system set control_files='+DATA/DEMO/CONTROLFILE/CONTROLFILE01.CTL','+DATA/DEMO/CONTROLFILE/CONTROLFILE02.CTL','+FRA/DEMO/CONTROLFILE/CONTROLFILE03.CTL' scope=spfile sid='*' Ĥ) use RMAN to connect to target database and copy the control file An Oracle database should have at least two control files, each stored on a different disk.ġ) check the location and name of control filesĢ) change system parameter to point to new control file
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |