Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Generate archive logs are not in sequence number?

626474Jun 7 2009 — edited Jun 8 2009
On last friday... the latest archive log number was ARC00024.ARC. Tomorrow when I come backup, the archive logs ARC00001.ARC and ARC00002.ARC were being generated by oracle itself. I wondering the archive log sequence should be in sequence. What is happening?


SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\oracle\ora92\RDBMS
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3
SQL>

FAN

Edited by: user623471 on Jun 7, 2009 7:35 PM

Comments

26741
That would happen if an "OPEN RESETLOGS" has been performed on the database.
For example , such an action would have been undertaken if an Incomplete Recovery had been performed.
baskar.l
Hi and all,

Mee to facing the same sort of issue...Archives are generated not in an order...Sequence numbers are differing ?
Is opening the database in resetlogs is the issue??

thanks,
baskar.l
orawarebyte
yes resetlogs reinitilize the sequence of new redo logs which in turn start the redologs to be archived with from sequence 1.

Khurram
baskar.l
khurram,

Its our production instance and havent issued resetlogs option but when listing the arvchives it shows in different sequence number...

and also while copying the archives by RMAN it doesnt copy in sequence

-rw-r----- 1 xxx dba 69363859 May 28 19:16 2_10373.arc.gz
-rw-r----- 1 xxx dba 43446622 May 28 19:16 1_10553.arc.gz
-rw-r----- 1 xxx dba 52587365 May 28 19:16 1_10578.arc.gz
-rw-r----- 1 xxx dba 45251820 May 28 19:16 1_10543.arc.gz
-rw-r----- 1 xxx dba 60890256 May 28 19:17 1_10579.arc.gz
-rw-r----- 1 xxx dba 46659008 May 28 19:17 1_10548.arc.gz
-rw-r----- 1 xxx dba 116899466 May 28 19:17 2_10353.arc.gz
-rw-r----- 1 xxx dba 77769517 May 28 19:17 1_10531.arc.gz
-rw-r----- 1 xxx dba 66401923 May 28 19:18 1_10530.arc.gz
-rw-r----- 1 xxx dba 45972697 May 28 19:18 1_10605.arc.gz
-rw-r----- 1 xxx dba 55082543 May 28 19:18 1_10600.arc.gz
-rw-r----- 1 xxxq dba 42682207 May 28 19:19 1_10547.arc.gz


thanks,
baskar.l
orawarebyte
does yours archivelog generating at FRA?

show us 
SQL>archive log list
Khurram
baskar.l
Khurram,

Yes archives are generating in the FRA.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA/arch/
Oldest online log sequence 11196
Next log sequence to archive 11200
Current log sequence 11200

thanks,
baskar.l
26741
You are running RAC and have two threads, each with a different sequence.

However, within each thread you have varying timestamps. You seem to have a background script that does a "gzip" of archivelogs. It is likely that the timestamps are as of the time when the files got 'gzipped'. If your script is picking up archivelogs to gzip not in sequence but merely by listing files, it may well get them in the order that the unix directory returns them -- not necessarily in SEQUENCE# order.

Do an "ls -l" and an "ls -lt" for the actual ArchiveLogs, not the gzipped files and compare the two lists.
baskar.l
Thanks Hemant will check the same...

regards,
baskar.l
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 6 2009
Added on Jun 7 2009
#performance-availability, #recovery-manager-rman
8 comments
1,107 views