Home » RDBMS Server » Backup & Recovery » open resetlogs (Linux 9207)
open resetlogs [message #309988] Sun, 30 March 2008 22:24 Go to next message
praveenparachuri
Messages: 7
Registered: March 2008
Junior Member
Hi

What exactly happens when we open the database with resetlogs.

(The redo sequence will be set to 0 or Incarination is set to 0)

what happens when the when sequence is set to 0)

Thank you

Report message to a moderator

Re: open resetlogs [message #309999 is a reply to message #309988] Sun, 30 March 2008 23:09 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
RESETLOGS will clear the contents of the redo logs if they exist or create new ones if needed and sets the header of all datafiles with the SCN for the time the resetlog occurred. The log sequence will be reset and start again from 1.

Report message to a moderator

Re: open resetlogs [message #310039 is a reply to message #309999] Mon, 31 March 2008 00:54 Go to previous message
praveenparachuri
Messages: 7
Registered: March 2008
Junior Member

Hi Ebrian,

Thank s for your Inputs

Thank you

Report message to a moderator

Previous Topic: rman del archivelogs
Next Topic: unable to create the datafile which was deleted
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 17:54:04 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.