archive log list output
I just manually created an Oracle 10g database.
I placed the database in archive mode and ran archive log list and got the
following output (see below). I have a few questions.
1) Why is the oldest online log set to 154, I would expect 0 or 1 since
this is a brand new database and I just enabled archiving
2) why is there a difference of 2 and not 1 between oldest online log sequence and next log sequence (154 vs 156, instead of 154 vs 155).
3) I there anyway to reset these numbers back to zero since I don't have
any archive logs created.
SQL> alter database archivelog;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ctron/oracle/pbh10.2.0/arch
Oldest online log sequence 154
Next log sequence to archive 156
Current log sequence 156
I think you are under the impression log sequence number is somehow related to having the database set to archivelog mode; this is incorrect.
No matter if your database is set to archivelog or noarchivelog mode sequence number is increased by "1" each time a log switch happens.
You can certainly reset sequence log back to "1" by opening the database with "reset logs" option even when I see no practical reason to do that.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Thank you for the clarification, now it makes sense
Click Here to Expand Forum to Full Width