|
本帖最后由 sorry休止符 于 2014-7-26 14:21 编辑
请问老师,12d的实验做完一遍会产生新化身,如果在此基础上再做一遍,还是用before的trace脚本的话,步骤一样,但是就会报错:
[oracle@station67 ~]$ sqlplus / as sysdba
SQL> @12d.sql
Control file created.
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1006207 generated at 07/25/2014 16:16:07 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2014_07_25/thread_1_seq_5.297.853863371
ORA-00280: change 1006207 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
回车
ORA-00279: change 1006212 generated at 07/25/2014 16:16:10 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2014_07_25/thread_1_seq_6.298.853863371
ORA-00280: change 1006212 for thread 1 is in sequence #6
ORA-00278: log file
'+FRA/orcl/archivelog/2014_07_25/thread_1_seq_5.297.853863371' no longer needed
for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
回车
ORA-00279: change 1006217 generated at 07/25/2014 16:16:10 needed for thread 1
ORA-00289: suggestion : +FRA
ORA-00280: change 1006217 for thread 1 is in sequence #7
ORA-00278: log file
'+FRA/orcl/archivelog/2014_07_25/thread_1_seq_6.298.853863371' no longer needed
for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
回车
ORA-00308: cannot open archived log '+FRA'
ORA-17503: ksfdopn:2 Failed to open file +FRA
ORA-15045: ASM file name '+FRA' is not in reference form
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: '+DATA/orcl/datafile/system.256.832197063'
SQL> exit
[oracle@station67 ~]$ rman target / catalog u67/oracle_4U@rcat
RMAN> run {
2> set until sequence 7 thread 1;
3> restore database;
4> recover database;
5> }
executing command: SET until clause
Starting restore at 25-JUL-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 device type=DISK
.
.过程省略
.
archived log file name=+FRA/orcl/archivelog/2014_07_25/thread_1_seq_1.294.853863353 thread=1 sequence=1
archived log file name=+FRA/orcl/archivelog/2014_07_25/thread_1_seq_2.292.853863355 thread=1 sequence=2
archived log file name=+FRA/orcl/archivelog/2014_07_25/thread_1_seq_3.295.853863365 thread=1 sequence=3
archived log file name=+FRA/orcl/archivelog/2014_07_25/thread_1_seq_4.296.853863367 thread=1 sequence=4
archived log file name=+FRA/orcl/archivelog/2014_07_25/thread_1_seq_5.297.853863371 thread=1 sequence=5
archived log file name=+FRA/orcl/archivelog/2014_07_25/thread_1_seq_6.298.853863371 thread=1 sequence=6
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 3 needs more recovery to be consistent
ORA-01110: data file 3: '+DATA/orcl/datafile/undotbs1.258.832197065'
media recovery complete, elapsed time: 00:04:06
Finished recover at 25-JUL-14
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/25/2014 16:39:21
ORA-01194: file 3 needs more recovery to be consistent
ORA-01110: data file 3: '+DATA/orcl/datafile/undotbs1.258.832197065'
RMAN> exit
[oracle@station67 ~]$ rman target / catalog u67/oracle_4U@rcat
这个datafile是随机error的,我做了2次,一次是datafile5,一次是datafile3.
单独进行这个datafile文件restore、recover也无济于事。
RMAN>run{
2> set until sequence 7 thread 1;
3> restore datafile 3;
4> recover datafile 3;
5> }
.
.中间省略
.
datafile 3 is already restored to file +DATA/orcl/datafile/undotbs1.258.832197065
restore not done; all files read only, offline, or already restored
Finished restore at 25-JUL-14
Starting recover at 25-JUL-14
.
.中间省略
.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/25/2014 16:49:21
RMAN-06067: RECOVER DATABASE required with a backup or created control file
RMAN>
实验还能修复么?求解
|
|