环境:
LINUX ORACLE 10G RAC 进行备份(控制文件、数据文件、归档日志)
恢复到LINUX ORACLE 10G单机 路径一致1、导入RAC,PFILE到单机上
2、恢复控制文件
3、恢复归档日志
4、恢复数据文件
以上都恢复了。recover database
后报RMAN-06054错
alter database open resetlogs
报 ORA-01110错。
请问如何解决
谢谢RMAN> recover database;Starting recover at 29-MAY-10
using channel ORA_DISK_1starting media recoveryunable to find archive log
archive log thread=1 sequence=63
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:39:00
RMAN-06054: media recovery requesting unknown log: thread 1 seq 63 lowscn 462904RMAN> recover database until sequence 62;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:44:35
RMAN-06556: datafile 1 must be restored from backup older than scn 462863RMAN> recover database until scn 462872;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:45:44
RMAN-06556: datafile 1 must be restored from backup older than scn 462872RMAN> recover database until scn 462875;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:46:57
RMAN-06556: datafile 1 must be restored from backup older than scn 462875RMAN> recover database until scn 462874;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:47:15
RMAN-06556: datafile 1 must be restored from backup older than scn 462874RMAN> recover datafile 1 until scn 462904;Starting recover at 29-MAY-10
using channel ORA_DISK_1RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:48:49
RMAN-06067: RECOVER DATABASE required with a backup or created control fileRMAN> recover data file 1 until scn 462904;RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "copy, clone, database, datafile, datafilecopy, device, standby, tablespace"
RMAN-01008: the bad identifier was: data
RMAN-01007: at line 1 column 9 file: standard inputRMAN> recover database until scn 463071;Starting recover at 29-MAY-10
using channel ORA_DISK_1starting media recoveryunable to find archive log
archive log thread=1 sequence=63
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:51:13
RMAN-06054: media recovery requesting unknown log: thread 1 seq 63 lowscn 462904RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 RACDB 717328999 CURRENT 1 23-MAY-10
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 462904 generated at 05/29/2010 22:25:20 needed for thread 1
ORA-00289: suggestion : /cbs/1_63_719712231.dbf
ORA-00280: change 462904 for thread 1 is in sequence #63
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
+RAC_DISK/racdb/onlinelog/group_3.270.720295581
ORA-00309: log belongs to wrong database
ORA-00334: archived log: '+RAC_DISK/racdb/onlinelog/group_3.270.720295581'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'
LINUX ORACLE 10G RAC 进行备份(控制文件、数据文件、归档日志)
恢复到LINUX ORACLE 10G单机 路径一致1、导入RAC,PFILE到单机上
2、恢复控制文件
3、恢复归档日志
4、恢复数据文件
以上都恢复了。recover database
后报RMAN-06054错
alter database open resetlogs
报 ORA-01110错。
请问如何解决
谢谢RMAN> recover database;Starting recover at 29-MAY-10
using channel ORA_DISK_1starting media recoveryunable to find archive log
archive log thread=1 sequence=63
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:39:00
RMAN-06054: media recovery requesting unknown log: thread 1 seq 63 lowscn 462904RMAN> recover database until sequence 62;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:44:35
RMAN-06556: datafile 1 must be restored from backup older than scn 462863RMAN> recover database until scn 462872;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:45:44
RMAN-06556: datafile 1 must be restored from backup older than scn 462872RMAN> recover database until scn 462875;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:46:57
RMAN-06556: datafile 1 must be restored from backup older than scn 462875RMAN> recover database until scn 462874;Starting recover at 29-MAY-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:47:15
RMAN-06556: datafile 1 must be restored from backup older than scn 462874RMAN> recover datafile 1 until scn 462904;Starting recover at 29-MAY-10
using channel ORA_DISK_1RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:48:49
RMAN-06067: RECOVER DATABASE required with a backup or created control fileRMAN> recover data file 1 until scn 462904;RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "copy, clone, database, datafile, datafilecopy, device, standby, tablespace"
RMAN-01008: the bad identifier was: data
RMAN-01007: at line 1 column 9 file: standard inputRMAN> recover database until scn 463071;Starting recover at 29-MAY-10
using channel ORA_DISK_1starting media recoveryunable to find archive log
archive log thread=1 sequence=63
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2010 23:51:13
RMAN-06054: media recovery requesting unknown log: thread 1 seq 63 lowscn 462904RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 RACDB 717328999 CURRENT 1 23-MAY-10
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 462904 generated at 05/29/2010 22:25:20 needed for thread 1
ORA-00289: suggestion : /cbs/1_63_719712231.dbf
ORA-00280: change 462904 for thread 1 is in sequence #63
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
+RAC_DISK/racdb/onlinelog/group_3.270.720295581
ORA-00309: log belongs to wrong database
ORA-00334: archived log: '+RAC_DISK/racdb/onlinelog/group_3.270.720295581'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '+RAC_DISK/racdb/datafile/undotbs1.264.720314411'
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> connect sys/oracle@RACDB as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select * from test; A
----------
4
5
1
2
3SQL>
run{
set until scn xxxxxx;
restore database;
recover database;
}
这样应该可以吧