Home » RDBMS Server » Backup & Recovery » Flashback database And Resetlogs
Flashback database And Resetlogs [message #537235] Tue, 27 December 2011 06:12 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
Hi,all. after i flashback database to the previous time ,why should i open the database using "Resetlogs"?(--> alter database open resetlogs) if i issue "alter database open",it will appears a error.
Re: Flashback database And Resetlogs [message #537237 is a reply to message #537235] Tue, 27 December 2011 06:15 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Because you revert the database back while redologs were containing some data. They should be resetted in order not to be used (the same happens when you make an incomplete recovery)
Re: Flashback database And Resetlogs [message #537252 is a reply to message #537235] Tue, 27 December 2011 06:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In other words, what's inside the redo logs is irrelevant to the time where your database is and so they must be emptied and this is what "reset logs" does.

Regards
Michel
Re: Flashback database And Resetlogs [message #537271 is a reply to message #537252] Tue, 27 December 2011 08:12 Go to previous message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
thank u ,i think i had understand it clearly.
Previous Topic: Oracle database backup using data pump
Next Topic: manually backup of datafile
Goto Forum:
  


Current Time: Mon Oct 22 11:38:01 CDT 2018