Home » RDBMS Server » Backup & Recovery » error in flashing back database,
error in flashing back database, [message #249252] Tue, 03 July 2007 15:41 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
dear all,
i want to flashback database and exclude users tablespace from flashing back .
but i am getting this error
./fa/2694/0/

any one has any idea?
  • Attachment: flashback.JPG
    (Size: 34.22KB, Downloaded 228 times)
Re: error in flashing back database, [message #249253 is a reply to message #249252] Tue, 03 July 2007 15:47 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
YOUR FILE# 4 IS OFFLINE???

SQL> ;
  1  SELECT FILE#,STATUS
  2* FROM V$DATAFILE
     FILE# STATUS
---------- -------
       210 ONLINE
       211 ONLINE
       212 RECOVER
       213 ONLINE
       214 ONLINE
       215 ONLINE
       216 ONLINE
       217 ONLINE
       218 ONLINE
       219 ONLINE
       220 ONLINE

220 rows selected.



VERIFY YOUR DATAFILES..

[Updated on: Tue, 03 July 2007 15:51]

Report message to a moderator

Re: error in flashing back database, [message #249327 is a reply to message #249252] Wed, 04 July 2007 01:56 Go to previous message
prince973
Messages: 37
Registered: November 2006
Member
you have to take the tablespace you want to exclude from flashbacking offline
Previous Topic: excluding tablespace from flashback database
Next Topic: Problem with RMAN via the EM console
Goto Forum:
  


Current Time: Tue Dec 06 08:37:58 CST 2016

Total time taken to generate the page: 0.04972 seconds