备份控制文件到指定目录,利用备份控制文件进行恢复
1.备份当前控制文件到指定目录
SYS@PROD1>alter database backup controlfile to '/home/oracle/files/control_bak.ctl';
Database altered.
查看文件
SYS@PROD1>! ls /home/oracle/files/control_bak.ctl
/home/oracle/files/control_bak.ctl
删除所有控制文件
[oracle@host01 PROD1]$ ls control0*
control01.ctl control03.ctl control03.ctl.bak
[oracle@host01 PROD1]$ rm control01.ctl control03.ctl
[oracle@host01 PROD1]$ pwd
/u01/app/oracle/fast_recovery_area/PROD1
[oracle@host01 PROD1]$ rm control02.ctl
3.此时控制文件已丢失,采用abort方式关闭数据库
SYS@PROD1>shutdown immediate;
Database closed.
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/PROD1/control01.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SYS@PROD1>shutdown abort;
ORACLE instance shut down.
4.将备份的控制文件复制到控制文件原目录
[oracle@host01 files]$ cp control_bak.ctl /u01/app/oracle/oradata/PROD1/control01.ctl
[oracle@host01 files]$ cp control_bak.ctl /u01/app/oracle/oradata/PROD1/control03.ctl
[oracle@host01 files]$ cp control_bak.ctl /u01/app/oracle/fast_recovery_area/PROD1/control02.ctl
5.启动到mount
SYS@PROD1>startup mount;
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 520096848 bytes
Database Buffers 310378496 bytes
Redo Buffers 2371584 bytes
Database mounted.
6.尝试打开数据库,提示需要open resetlogs
SYS@PROD1>alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
7.使用resetlogs选项再次尝试打开数据库,提示需要恢复1号数据文件
SYS@PROD1>alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/PROD1/system01.dbf'
执行介质恢复
RMAN> recover database;
Starting recover at 16-DEC-16
Starting implicit crosscheck backup at 16-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
Crosschecked 5 objects
Finished implicit crosscheck backup at 16-DEC-16
Starting implicit crosscheck copy at 16-DEC-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-DEC-16
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_11_18/o1_mf_s_928252815_d2xf8zpf_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_12_16/o1_mf_s_930743672_d56scr5w_.bkp
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 1 is already on disk as file /u01/app/oracle/oradata/PROD1/redo01.log
archived log file name=/u01/app/oracle/oradata/PROD1/redo01.log thread=1 sequence=1
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-DEC-16
打开数据库
SYS@PROD1>alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SYS@PROD1>alter database open resetlogs;
Database altered.
1.备份当前控制文件到指定目录
SYS@PROD1>alter database backup controlfile to '/home/oracle/files/control_bak.ctl';
Database altered.
查看文件
SYS@PROD1>! ls /home/oracle/files/control_bak.ctl
/home/oracle/files/control_bak.ctl
删除所有控制文件
[oracle@host01 PROD1]$ ls control0*
control01.ctl control03.ctl control03.ctl.bak
[oracle@host01 PROD1]$ rm control01.ctl control03.ctl
[oracle@host01 PROD1]$ pwd
/u01/app/oracle/fast_recovery_area/PROD1
[oracle@host01 PROD1]$ rm control02.ctl
3.此时控制文件已丢失,采用abort方式关闭数据库
SYS@PROD1>shutdown immediate;
Database closed.
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/PROD1/control01.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SYS@PROD1>shutdown abort;
ORACLE instance shut down.
4.将备份的控制文件复制到控制文件原目录
[oracle@host01 files]$ cp control_bak.ctl /u01/app/oracle/oradata/PROD1/control01.ctl
[oracle@host01 files]$ cp control_bak.ctl /u01/app/oracle/oradata/PROD1/control03.ctl
[oracle@host01 files]$ cp control_bak.ctl /u01/app/oracle/fast_recovery_area/PROD1/control02.ctl
5.启动到mount
SYS@PROD1>startup mount;
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 520096848 bytes
Database Buffers 310378496 bytes
Redo Buffers 2371584 bytes
Database mounted.
6.尝试打开数据库,提示需要open resetlogs
SYS@PROD1>alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
7.使用resetlogs选项再次尝试打开数据库,提示需要恢复1号数据文件
SYS@PROD1>alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/PROD1/system01.dbf'
执行介质恢复
RMAN> recover database;
Starting recover at 16-DEC-16
Starting implicit crosscheck backup at 16-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
Crosschecked 5 objects
Finished implicit crosscheck backup at 16-DEC-16
Starting implicit crosscheck copy at 16-DEC-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-DEC-16
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_11_18/o1_mf_s_928252815_d2xf8zpf_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_12_16/o1_mf_s_930743672_d56scr5w_.bkp
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 1 is already on disk as file /u01/app/oracle/oradata/PROD1/redo01.log
archived log file name=/u01/app/oracle/oradata/PROD1/redo01.log thread=1 sequence=1
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-DEC-16
打开数据库
SYS@PROD1>alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SYS@PROD1>alter database open resetlogs;
Database altered.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31400681/viewspace-2130797/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31400681/viewspace-2130797/