| db to open in RESETLOGS or NORESETLOGS ? [message #177084] |
Tue, 13 June 2006 00:09  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
whats the difference between RESETLOGS and NORESETLOGS
i presume it will reset the log sequence number.
when i was trying to open the database
alter database open
it threw error stating that the database must be opened using either RESETLOGS or NORESETLOGS
i opened with NORESETLOGS
and it worked.
but i dont seem to understand the difference.
i mean
what scenario would require a NORESETLOGS
and
what scenario would require a RESETLOGS
|
|
|
|
| Re: db to open in RESETLOGS or NORESETLOGS ? [message #177090 is a reply to message #177084] |
Tue, 13 June 2006 00:40  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Oracle is forcing you to make a choice:
Use RESETLOGS after incomplete recovery (when the entire redo stream wasn't applied). RESETLOGS will initialize the logs, reset your log sequence number, and start a new "incarnation" of the database.
Use NORESETLOGS when doing complete recovery (when the entire redo stream was applied). Oracle will continue using the existing (valid) log files.
|
|
|
|
| Re: db to open in RESETLOGS or NORESETLOGS ? [message #177412 is a reply to message #177090] |
Wed, 14 June 2006 08:22 |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
actualy my case was that of loossing my redo log files.
i restored from my old backup.
I dont have any archives since its not running in archivelog.
all i did was restored my datafiles and controlfiles.
i did a recover and
then
alter database open noresetlogs.
worked fine..
so now the log number carries from where it was last ended.
my concern is what implications it could have ??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
