Bo's Oracle Station

查看: 1403|回复: 0

请问老师,12d的实验做完一遍会产生新化身,如果在此基础上再做一遍的问题#

[复制链接]

11

主题

27

帖子

377

积分

版主

Rank: 7Rank: 7Rank: 7

积分
377
发表于 2014-7-25 16:42:10 | 显示全部楼层 |阅读模式
本帖最后由 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>

实验还能修复么?求解




回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-22 08:50 , Processed in 0.034469 second(s), 24 queries .

快速回复 返回顶部 返回列表