This content has been marked as final. Show 3 replies
As you may know, manual says Archives the current online redo logs (if they are accessible) and then erases the contents of the online redo logs and resets the log sequence number to 1 .
But you say not so, Could you put your v$log ?
Which Windows 7 you have ? Please note that Oracle is not certified with any Home editions
Please post database instance alert log messages for ALTER DATABASE OPEN RESETLOGS statement and output of:
select group#, thread#, sequence# from v$log;