Home » RDBMS Server » Backup & Recovery » Flashback Database (Windows,10.2.0.3)
Flashback Database [message #471287] Fri, 13 August 2010 03:22 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
HI I used flashback database to recover my database to a previous time and then I tried to open it using noresetlogs option but it was not opening.I have two doubts regarding it

1.Can I open database in noresetlogs after performing a flashback?

2.Suppose I perform a flashback then I want to cancel the flashback and bring back the database to original state then what should I do?In that case can I open the database using noresetlogs option?


Re: Flashback Database [message #471290 is a reply to message #471287] Fri, 13 August 2010 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but it was not opening

Which means what exactly?
Copy and paste your SQL*Plus session. Don't forget to format it.

Regards
Michel

[Updated on: Fri, 13 August 2010 03:24]

Report message to a moderator

Re: Flashback Database [message #471306 is a reply to message #471290] Fri, 13 August 2010 04:59 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
After performing flashback when I try to open the database with "alter database open" an error says "open the database in either resetlogs or noresetlogs mode".But I am able to open the database only in resetlogs mode.

After performing a flashback on a database can I open the database in noresetlogs mode???
Re: Flashback Database [message #471356 is a reply to message #471306] Fri, 13 August 2010 10:38 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Copy and paste your SQL*Plus session. Don't forget to format it.

Regards
Michel
Previous Topic: ORA-01033: Recovering database
Next Topic: Ctrl+x of the database files. Can I restore it?
Goto Forum:
  


Current Time: Fri Mar 29 05:28:10 CDT 2024