OraFAQ Forum: Backup & Recovery » error in flashing back database,

Home » RDBMS Server » Backup & Recovery » error in flashing back database,

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error in flashing back database, [message #249252]

Tue, 03 July 2007 15:41

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
/forum/fa/2694/0/

any one has any idea?

Attachment: flashback.JPG
(Size: 34.22KB, Downloaded 1502 times)

Report message to a moderator

Re: error in flashing back database, [message #249253 is a reply to message #249252]

Tue, 03 July 2007 15:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

YOUR FILE# 4 IS OFFLINE???

Code: [Select all] [Show/ hide]

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

prince973
Messages: 37
Registered: November 2006

Member

you have to take the tablespace you want to exclude from flashbacking offline

Report message to a moderator

Previous Topic:	excluding tablespace from flashback database
Next Topic:	Problem with RMAN via the EM console

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 01:29:14 CDT 2025