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.

Report message to a moderator

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)

Report message to a moderator

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: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Oracle database backup using data pump
Next Topic: manually backup of datafile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 03 14:49:05 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.