RMAN-00571: ============================================
RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===========================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 3 scn 423065 found to restore
RMAN-06025: no backup of log thread 1 seq 2 scn 402902 found to restore
[/COLOR]
具体步骤:
1。用rman备份数据库(backup database format 'e:\dbbackup\full%u_%p_%c ';)
2。关闭数据库,手工删除所有文件
3。用rman恢复控制文件成功(restore controlfile;)
4。用rman恢复归档日志文件时
(set archivelog destination to 'E:\oracle\ora81\RDBMS';
allocate channel c1 type disk;
restore archivelog all;
release channel c1;
)出现上述错误(
RMAN-06025: no backup of log thread 1 seq 3 scn 423065 found to restore
RMAN-06025: no backup of log thread 1 seq 2 scn 402902 found to restore)[/COLOR]
请问我现在应该怎么恢复我的log?可以删除重建么?[/COLOR] 谢谢
具体步骤:
1。用rman备份数据库(backup database format 'e:\dbbackup\full%u_%p_%c ';)
2。关闭数据库,手工删除所有文件
3。用rman恢复控制文件成功(restore controlfile;)
4。用rman恢复归档日志文件时
set archivelog destination to 'E:\oracle\ora81\RDBMS';
allocate channel c1 type disk;
restore archivelog all;
release channel c1;
)
出现上述错误(
RMAN-06025: no backup of log thread 1 seq 3 scn 423065 found to restore
RMAN-06025: no backup of log thread 1 seq 2 scn 402902 found to restore)
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
17 1 554295671 0 554295642 3 30-MAR-05
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
18 1 1 AVAILABLE 30-MAR-05 E:\DBBACKUP\FULL03GGJOAQ_1_
1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 E:\ORACLE\ORADATA\FISH\SYSTEM01.DBF 0 Full 443235 30-MAR-05
2 E:\ORACLE\ORADATA\FISH\RBS01.DBF 0 Full 443235 30-MAR-05
3 E:\ORACLE\ORADATA\FISH\USERS01.DBF 0 Full 443235 30-MAR-05
4 E:\ORACLE\ORADATA\FISH\TEMP01.DBF 0 Full 443235 30-MAR-05
5 E:\ORACLE\ORADATA\FISH\TOOLS01.DBF 0 Full 443235 30-MAR-05
6 E:\ORACLE\ORADATA\FISH\INDX01.DBF 0 Full 443235 30-MAR-05
7 E:\ORACLE\ORADATA\FISH\DR01.DBF 0 Full 443235 30-MAR-05
8 E:\ORACLE\ORADATA\FISH\YYTS.ORA 0 Full 443235 30-MAR-05