| Flashback Database [message #471287] |
Fri, 13 August 2010 03:22  |
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 #471306 is a reply to message #471290] |
Fri, 13 August 2010 04:59  |
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???
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
