cancel
Showing results for 
Search instead for 
Did you mean: 

Archive backup restore problem

Former Member
0 Kudos

When am restore the Archive logs in br tools it asking .

? First sequence number (first_seq) ........ []

? Second sequence number (second_seq) ........ []

What is sequence number?

Pls give any suggestions

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The sequence number is a kind of serial number the database creates for every logfile. It is part of the archive filename which did normaly contain also other information and is controled by the oracle parameter log_archive_format.

As far as i can remember the %s part in log_archive_format represents the sequence number.

regards

Peter

PS: during the recovery process of the database, you will typically asked to provide the archived redo logfile with the sequence number xyz....