Home » RDBMS Server » Server Administration » resetlogs
resetlogs [message #58092] Wed, 30 July 2003 04:09 Go to next message
Raj Mathur
Messages: 11
Registered: April 2002
Junior Member
hi what's the use of setting resetlogs.why it should
reseting to sequence to 1.What will happen internally.

Report message to a moderator

Re: resetlogs [message #58102 is a reply to message #58092] Wed, 30 July 2003 22:03 Go to previous messageGo to next message
Dhiren
Messages: 43
Registered: July 2002
Member
Hi

Resetting Logs Exactly Means Syncronizing Of All Datafile's and Redolog files.It is must required when u perform incomplete recovery,becoz at the time of incomplete recovery datafiles headers are out of seqeunce with compare to controfile information,so while you the database after perfoming incomplete recovery u must u ALTER DATABASE OPEN RESETLOGS
command to syncronize the Database Files

Report message to a moderator

Re: resetlogs [message #58129 is a reply to message #58102] Mon, 04 August 2003 06:43 Go to previous messageGo to next message
Deepa
Messages: 269
Registered: November 2000
Senior Member
Actually u have to open resetlogs only when u are going to recover from a backup controlfile and in all cases of incomplete recovery.

Report message to a moderator

Re: resetlogs [message #58130 is a reply to message #58129] Mon, 04 August 2003 06:44 Go to previous message
Deepa
Messages: 269
Registered: November 2000
Senior Member
I am sorry

" not in all cases of incomplete recovery."

Report message to a moderator

Previous Topic: Recovering a datafile
Next Topic: invalid username/password
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:57:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.