| How can I reset Archivelogs? [message #101296] |
Tue, 27 July 2004 04:11  |
kjl
Messages: 48
Registered: June 2003
|
Member |
|
|
Hi,
I'd like to reset archivelogs so that files are named from SID000000000.ARC. Database is running unden Win2000.
How can I do it?
Thanks for any advice, Karri
|
|
|
|
| Re: How can I reset Archivelogs? [message #101326 is a reply to message #101296] |
Mon, 09 August 2004 02:59  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
The log sequence number will start from 0 after doing an incomplete database recovery with an ALTER DATABASE OPEN RESETLOGS;
Nevertheless, I suggest you just leave it alone. There is absolutely no valid reason for resetting it!
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
