oracle11g rman恢复：ORA-01180「建议收藏」

欢迎大家来到IT世界,在知识的湖畔探索吧!

记一次rman 数据恢复问题处理案例：

为了省去创建参数文件等和目录文件的麻烦，直接通过创建实例法恢复。

执行恢复时 报错rman恢复 ORA-01180: can not create datafile 1

闪回区有归档，影响了restore，所以删除闪存区的归档日志
搜索归档目录，发现处于闪回区的目录下面：
[root@yueworldoracle_crm soft]# find /data -name archivelog
/data/oracle/app/oracle/flash_recovery_area/POWERDES/archivelog
[root@yueworldoracle_crm soft]# su – oracle
[oracle@yueworldoracle_crm ~]$ cd /data/oracle/app/oracle/flash_recovery_area/POWERDES/archivelog
[oracle@yueworldoracle_crm archivelog]$ ll
total 20
drwxrwxrwx. 2 oracle oinstall 4096 Mar 17 22:05 2016_03_17
drwxrwxrwx. 2 oracle oinstall 4096 Mar 18 22:17 2016_03_18
drwxrwxrwx. 2 oracle oinstall 4096 Mar 19 17:02 2016_03_19
drwxrwxrwx. 2 oracle oinstall 4096 Mar 20 06:00 2016_03_20
drwxrwxrwx. 2 oracle oinstall 4096 Mar 21 00:29 2016_03_21
[oracle@yueworldoracle_crm archivelog]$ du -sh *
40M 2016_03_17
237M 2016_03_18
210M 2016_03_19
177M 2016_03_20
182M 2016_03_21
将这些归档日志移除到临时目录：
[oracle@yueworldoracle_crm archivelog]$ mkdir /data/backup2/
[oracle@yueworldoracle_crm archivelog]$ mv * /data/backup2/
[oracle@yueworldoracle_crm archivelog]$ ll
[oracle@yueworldoracle_crm archivelog]$ ll
total 0
[oracle@yueworldoracle_crm archivelog]$ pwd
/data/oracle/app/oracle/flash_recovery_area/POWERDES/archivelog
开始再做rman恢复操作，先启动到nomount状态：
[oracle@yueworldoracle_crm archivelog]$ rlwrap sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 21 23:43:37 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile=’/oracle/backup/pfile_20160321.ora’;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 1023412336 bytes
Database Buffers 570425344 bytes
Redo Buffers 7360512 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
开始rman恢复控制文件：
[oracle@yueworldoracle_crm archivelog]$ rlwrap rman target /
Recovery Manager: Release 11.2.0.1.0 – Production on Mon Mar 21 23:44:08 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: POWERDES (not mounted)
RMAN> restore controlfile to ‘/data/oracle/powerdes/control01.ctl’ from ‘/oracle/backup/2016-03-21_2/full_POWERDES_20160321_25.bak’;
Starting restore at 21-MAR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 21-MAR-16
加载到mount状态：
RMAN> alter database mount
2> ;
database mounted
released channel: ORA_DISK_1
RMAN>
注册备份集：
RMAN> catalog start with ‘/oracle/backup/2016-03-21_2’;
Starting implicit crosscheck backup at 21-MAR-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
Crosschecked 6 objects
Finished implicit crosscheck backup at 21-MAR-16
Starting implicit crosscheck copy at 21-MAR-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 21-MAR-16
searching for all files in the recovery area
cataloging files…
no files cataloged
searching for all files that match the pattern /oracle/backup/2016-03-21_2
List of Files Unknown to the Database
=====================================
File Name: /oracle/backup/2016-03-21_2/rman_backup.log
File Name: /oracle/backup/2016-03-21_2/full_POWERDES_20160321_25.bak
File Name: /oracle/backup/2016-03-21_2/arch_POWERDES_20160321_26.bak
File Name: /oracle/backup/2016-03-21_2/full_POWERDES_20160321_24.bak
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files…
cataloging done
List of Cataloged Files
=======================
File Name: /oracle/backup/2016-03-21_2/full_POWERDES_20160321_25.bak
File Name: /oracle/backup/2016-03-21_2/arch_POWERDES_20160321_26.bak
File Name: /oracle/backup/2016-03-21_2/full_POWERDES_20160321_24.bak
List of Files Which Where Not Cataloged
=======================================
File Name: /oracle/backup/2016-03-21_2/rman_backup.log
RMAN-07517: Reason: The file header is corrupted
进行restore操作，将备份集恢复到数据文件，看到恢复正常不报错了：
RMAN> restore database;
Starting restore at 21-MAR-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /data/oracle/powerdes/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /data/oracle/powerdes/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /data/oracle/powerdes/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /data/oracle/powerdes/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /data/oracle/powerdes/powerdesk01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /data/oracle/powerdes/plas01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /data/oracle/powerdes/plcrm01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /data/oracle/powerdes/pl01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /data/oracle/powerdes/help01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/backup/2016-03-21_2/full_POWERDES_20160321_24.bak