+ -
当前位置:首页 → 问答吧 → 请教缺少归档文件情况下的恢复~!

请教缺少归档文件情况下的恢复~!

时间: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

作者: 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

作者: wanenjie   发布时间: 2010-09-14

啊,RMAN的,没注意到
sql "recover database until cancel"

作者: 拿钱发帖死全家   发布时间: 2010-09-14

相关阅读 更多