-
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;
Database altered.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|