使用RMAN恢复一个表空间
来源:互联网 发布:辨析题 存在就是被告知 编辑:程序博客网 时间:2024/05/16 08:34
1.RMAN> list backup ofdatafile 8;
BS 关键字
------- ---- -- ---------- ----------- ----------------------
26
段名:D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\BACKUPSET\2009_07_16\
O1_MF_NNNDF_TAG20090716T163028_55XS96PC_.BKP
5.recover tablespace test01;
存档日志线程 1 序列 554 已作为文件D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\
MYORACLE\ARCHIVELOG\2009_08_06\O1_MF_1_554_57MST2KL_.ARC存在于磁盘上
存档日志线程 1 序列 555 已作为文件D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\
MYORACLE\ARCHIVELOG\2009_08_06\O1_MF_1_555_57MXO3FR_.ARC存在于磁盘上
存档日志线程 1 序列 556 已作为文件D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\
MYORACLE\ARCHIVELOG\2009_08_06\O1_MF_1_556_57N15KBT_.ARC存在于磁盘上
存档日志线程 1 序列 557 已作为文件D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\
MYORACLE\ARCHIVELOG\2009_08_06\O1_MF_1_557_57N4VOJ7_.ARC存在于磁盘上
存档日志线程 1 序列 558 已作为文件D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\
MYORACLE\ARCHIVELOG\2009_08_06\O1_MF_1_558_57N8H231_.ARC存在于磁盘上
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS===============
RMAN-00571:===========================================================
RMAN-03002: failure of recover command at 08/06/2009 09:50:19
RMAN-06053: unable to perform media recovery because of missinglog
RMAN-06025: no backup of log thread 1 seq 389 lowscn 18537953 foundto restore
RMAN-06025: no backup of log thread 1 seq 388 lowscn 18536702 foundto restore
RMAN-06025: no backup of log thread 1 seq 387 lowscn 18532978 foundto restore
RMAN-06025: no backup of log thread 1 seq 386 lowscn 18529396 foundto restore
RMAN-06025: no backup of log thread 1 seq 385 lowscn 18525943 foundto restore
RMAN-06025: no backup of log thread 1 seq 384 lowscn 18522007 foundto restore
RMAN-06025: no backup of log thread 1 seq 383 lowscn 18518260 foundto restore
RMAN-06025: no backup of log thread 1 seq 382 lowscn 18514773 foundto restore
RMAN-06025: no backup of log thread 1 seq 381 lowscn 18511313 foundto restore
RMAN-06025: no backup of log thread 1 seq 380 lowscn 18507653 foundto restore
RMAN-06025: no backup of log thread 1 seq 379 lowscn 18503863 foundto restore
RMAN-06025: no backup of log thread 1 seq 378 lowscn 18501352 foundto restore
RMAN-06025: no backup of log thread 1 seq 377 lowscn 18499081 foundto restore
RMAN-06025: no backup of log thread 1 seq 376 lowscn 18497286 foundto restore
RMAN-06025: no backup of log thread 1 seq 375 lowscn 18493315 foundto restore
RMAN-06025: no backup of log thread 1 seq 374 lowscn 18489532 foundto restore
6.alter database open
error:
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS===============
RMAN-00571:===========================================================
RMAN-03002: failure of alter db command at 08/06/200914:45:01
ORA-01190: 控制文件或数据文件 8 来自于最后一个 RESETLOGS 之前
ORA-01110: 数据文件 8: 'D:\TEST\TEST01.DBF'
7.SQL> alter database openresetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01139: RESETLOGS 选项仅在不完全数据库恢复后有效
RMAN> list backup by file;
数据文件备份列表
========================
文件关键字
---- ------- -
1
6T163028
2
6T163028
3
6T163028
4
6T163028
5
6T163028
6
6T163028
7
6T163028
8