请教缺少归档文件情况下的恢复~!
时间:2010-09-14
来源:互联网
最近做恢复测试,过程是全备数据库(backup database),然后关库把控制和数据文件都物理删除叼,然后连接rman,现在能把控制和数据文件都回来了,不过在RECOVER DATABASE的时候提示我要找77-83直接的归档,但是我看归档路径确实只有77小了其他,我想问为什么我没有删除过归档他自己会丢失呢??现在应该怎样恢复呢?我能接受数据丢失~!谢谢~!
RMAN> recover database ;
Starting recover at 14-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=17 devtype=DISK
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/sandata/cs_test/testg1/datafile/system01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/14/2010 09:36:29
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 91 scn 8210018411695
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 90 scn 8210018410227
RMAN-06025: no backup of log thread 1 seq 89 scn 8210018406763 found to restore
RMAN-06025: no backup of log thread 1 seq 88 scn 8210018371739 found to restore
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 87 scn 8210018371735
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 86 scn 8210018371089
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 85 scn 8209763356274
RMAN-06025: no backup of log thread 1 seq 84 scn 8209763354974 found to restore
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 83 scn 8209763354970
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 82 scn 8209763353170
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 81 scn 8209763353166
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 80 scn 8209763352423
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 79 scn 8209763352419
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 78 scn 8209762993996
RMAN-06025: no backup of log thread 1 seq 77 scn 8209762987196 found to restore
SQL> select checkpoint_change#,resetlogs_change#,controlfile_change# from v$database;
CHECKPOINT_CHANGE# RESETLOGS_CHANGE# CONTROLFILE_CHANGE#
------------------ ----------------- -------------------
8.2100E+12 8.2098E+12 8.2100E+12
SQL> select file#, recover, fuzzy, checkpoint_change# from v$datafile_header;
FILE# RECOVE FUZZY CHECKPOINT_CHANGE#
---------- ------ ------ ------------------
1 NO 8.2098E+12
2 NO 8.2098E+12
3 NO 8.2098E+12
4 NO 8.2098E+12
5 0
6 NO 8.2098E+12
6 rows selected.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data1/oracle/dbs/arch
Oldest online log sequence 91
Next log sequence to archive 93
Current log sequence 93
[crmserver]oracle$ ls
0000000001_0001.log 0000000004_0001.log 0000000076_0001.log 0000000411_0001.log
0000000002_0001.log 0000000005_0001.log 0000000077_0001.log 0000000412_0001.log
0000000003_0001.log 0000000075_0001.log 0000000410_0001.log 0000000413_0001.log
RMAN> recover database ;
Starting recover at 14-SEP-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=17 devtype=DISK
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/sandata/cs_test/testg1/datafile/system01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/14/2010 09:36:29
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 91 scn 8210018411695
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 90 scn 8210018410227
RMAN-06025: no backup of log thread 1 seq 89 scn 8210018406763 found to restore
RMAN-06025: no backup of log thread 1 seq 88 scn 8210018371739 found to restore
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 87 scn 8210018371735
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 86 scn 8210018371089
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 85 scn 8209763356274
RMAN-06025: no backup of log thread 1 seq 84 scn 8209763354974 found to restore
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 83 scn 8209763354970
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 82 scn 8209763353170
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 81 scn 8209763353166
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 80 scn 8209763352423
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 79 scn 8209763352419
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 78 scn 8209762993996
RMAN-06025: no backup of log thread 1 seq 77 scn 8209762987196 found to restore
SQL> select checkpoint_change#,resetlogs_change#,controlfile_change# from v$database;
CHECKPOINT_CHANGE# RESETLOGS_CHANGE# CONTROLFILE_CHANGE#
------------------ ----------------- -------------------
8.2100E+12 8.2098E+12 8.2100E+12
SQL> select file#, recover, fuzzy, checkpoint_change# from v$datafile_header;
FILE# RECOVE FUZZY CHECKPOINT_CHANGE#
---------- ------ ------ ------------------
1 NO 8.2098E+12
2 NO 8.2098E+12
3 NO 8.2098E+12
4 NO 8.2098E+12
5 0
6 NO 8.2098E+12
6 rows selected.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data1/oracle/dbs/arch
Oldest online log sequence 91
Next log sequence to archive 93
Current log sequence 93
[crmserver]oracle$ ls
0000000001_0001.log 0000000004_0001.log 0000000076_0001.log 0000000411_0001.log
0000000002_0001.log 0000000005_0001.log 0000000077_0001.log 0000000412_0001.log
0000000003_0001.log 0000000075_0001.log 0000000410_0001.log 0000000413_0001.log
作者: wanenjie 发布时间: 2010-09-14
recover database until cancel;
作者: 拿钱发帖死全家 发布时间: 2010-09-14
最近不搞ORACLE了。
作者: renxiao2003 发布时间: 2010-09-14
RMAN> recover database until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "cancel": expecting one of: "logseq, scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01007: at line 1 column 30 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "cancel": expecting one of: "logseq, scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01007: at line 1 column 30 file: standard input
作者: wanenjie 发布时间: 2010-09-14
啊,RMAN的,没注意到
sql "recover database until cancel"
sql "recover database until cancel"
作者: 拿钱发帖死全家 发布时间: 2010-09-14
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28