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

逍遥浪子 · 发表于 2010-10-26 01:53:01

最近做恢复测试，过程是全备数据库（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

拿钱发帖死全家 · 发表于 2010-10-26 03:44:09

recover database until cancel;

renxiao2003 · 发表于 2010-10-26 04:33:57

最近不搞ORACLE了。

wanenjie · 发表于 2010-10-26 06:13:11

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

拿钱发帖死全家 · 发表于 2010-10-26 07:34:26

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

wanenjie · 发表于 2010-10-26 10:28:37

SQL> recover database until cancel
ORA-00279: change 8210018416529 generated at 09/14/2010 16:34:50 needed for
thread 1
ORA-00289: suggestion : /data1/oracle/dbs/arch/0000000001_0001.log
ORA-00280: change 8210018416529 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/sandata/cs_test/testg1/datafile/system01.dbf'
ORA-01112: media recovery not started

duolanshizhe · 发表于 2010-10-26 11:33:18

恩这个命令sh只有在sqlplus中才有用的啊