RMAN-06571:datafile 1 does not have recoverable copy

--到nomount状态下，重新做一次冷备

RMAN> run{

2> allocate channel c1 device type disk;

3> allocate channel c2 device type disk;

4> backup as copy database format '+DATA';

5> }

RMAN> mount database;

RMAN> switch database to copy; --再次执行，依旧报错

releasedchannel: ORA_DISK_1

RMAN-00571:===========================================================

RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571:===========================================================

RMAN-03002:failure of switch to copy command at 05/29/2014 18:58:14

RMAN-06571:datafile 1 does not have recoverable copy

--尝试单独备份datafile1，报错依旧

--尝试重新转储控制文件，重新备份，报错依旧

--尝试重新创建磁盘阵列，重新创建卷组、逻辑卷、磁盘组，重新转储参数文件、控制文件、重新备份，报错依旧

--尝试重新创建磁盘阵列，重新规划容错策略，重新转储参数文件、控制文件、重新备份，报错依旧

--尝试使用手工操作将数据文件指向对应ASM，如下操作

SQL> alter database rename file'+DATA/metro/datafile/system.257.848858337' to '+DATA/METRO/DATAFILE/SYSTEM.264.848860609'; --指向system表空间文件

SQL> alter database rename file'/u01/app/oracle/oradata/metro/undotbs01.dbf' to'+DATA/METRO/DATAFILE/UNDOTBS1.266.848860809'; --指向undo表空间文件

SQL> alter database rename file '/u01/app/oracle/oradata/metro/sysaux01.dbf'to '+DATA/METRO/DATAFILE/SYSAUX.263.848860607'; --指向sysaux表空间文件

SQL> alter database rename file'/u01/app/oracle/oradata/metro/users01.dbf' to'+DATA/METRO/DATAFILE/USERS.267.848860815'; --指向users表空间文件

SQL> alter database rename file'/u01/app/oracle/oradata/metro/example01.dbf' to'+DATA/METRO/DATAFILE/EXAMPLE.265.848860723'; --指向example表空间文件

SQL> alter database open;

--启库，因所转储的数据文件为统一的SCN，但与此时日志SCN不符，需做不完全恢复

alter databaseopen

*

ERROR at line 1:

ORA-01190:control file or data file 1 is from before the last RESETLOGS

ORA-01110: data file 1: '+DATA/metro/datafile/system.264.848860609'

SQL> alter database open resetlogs; --提示要做一个不完全恢复

alter databaseopen resetlogs

*

ERROR at line 1:

ORA-01139:RESETLOGS option only valid after an incomplete database recovery

SQL> recover database until cancel; --做一个不完全恢复

ORA-00279:change 862849 generated at 05/29/2014 18:22:44 needed for thread 1

ORA-00289:suggestion : /u01/app/oracle/arch1/1_15_848741495.dbf

ORA-00280:change 862849 for thread 1 is in sequence #15

?

Specify log:{=suggested | filename | AUTO | CANCEL}

auto --自动查找所需日志sequence，未果

ORA-00279:change 863386 generated at 05/29/2014 19:40:54 needed for thread 1

ORA-00289:suggestion : /u01/app/oracle/arch1/1_1_848864454.dbf

ORA-00280:change 863386 for thread 1 is in sequence #1

ORA-00278: logfile '/u01/app/oracle/arch1/1_15_848741495.dbf' no longer needed

for thisrecovery

?

ORA-00308:cannot open archived log '/u01/app/oracle/arch1/1_1_848864454.dbf'

ORA-27037:unable to obtain file status

IBM AIX RISCSystem/6000 Error: 2: No such file or directory

Additionalinformation: 3

SQL> recover database until cancel;

--再次执行不完全恢复，查看到提示需要日志sequence #为1

ORA-00279: change 863386 generated at 05/29/2014 19:06:03 needed forthread 1

ORA-00289: suggestion : /u01/app/oracle/arch1/1_1_848864454.dbf

ORA-00280: change 863386 for thread 1 is in sequence #1

Specify log: {=suggested | filename | AUTO | CANCEL}

SQL> set linesize 300

SQL> select * from v$log； --查询sequence #为1的日志组为第2日志组