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

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.
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
Previous Topic: rman del archivelogs
Next Topic: unable to create the datafile which was deleted
Goto Forum:
  


Current Time: Sun Dec 04 08:35:37 CST 2016

Total time taken to generate the page: 0.04331 seconds