Hi All,
i have a question about how to deal with the tablespace that had
turned off flashback after flashback a database.
for example:
i turned off the flashback of MYTS and made it offline.then make a
database flashback
flashback database to scn 21248000;
flashback database to scn 21248000
ERROR at line 1:
ORA-38795: warning: FLASHBACK succeeded but OPEN RESETLOGS would get
error below
ORA-01245: offline file 6 will be lost if RESETLOGS is done
ORA-01110: data file 6: '/u01/oradata/noasm/myts01.dbf'

i don't want to drop MYTS. so i try to make a restore and recover.
run {
2> set until scn=21248000;
3> restore datafile 6;
4> recover datafile 6;
5> }

executing command: SET until clause

Starting restore at 2011-09-15 10:30:47
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /u01/oradata/noasm/myts01.dbf
channel ORA_DISK_1: reading from backup piece
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 2011-09-15 10:30:55

Starting recover at 2011-09-15 10:30:55
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/15/2011 10:30:56
RMAN-06067: RECOVER DATABASE required with a backup or created control file

the question: how to make the MYTS recover to the same scn of flashback
and open the database?


Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouporacle-l @
postedSep 16, '11 at 3:03a
activeSep 16, '11 at 5:09a



site design / logo © 2022 Grokbase