备份控制文件到指定目录，利用备份控制文件进行恢复
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博客

控制文件恢复（四）备份控制文件到指定目录

最新文章

ITPub博客

控制文件恢复（四） 备份控制文件到指定目录

最新文章

控制文件恢复（四）备份控制文件到指定目录