Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Restore multiple non-sequential archivelogs

Hello community,
I am standing up a Data Guard copy of a database and found that there are a few dozen missing archivelogs, spread across a range of sequence numbers. I am looking for an efficient way to restore those, like a comma-delimited list or something similar. Right now I am performing individual restore commands on each log. Is there a way to restore many non-sequential logs in one command?
Thanks,
John
Best Answer
-
You need to check the syntax according to your version, but I believe that you will need to do something like this:
run {
restore archivelog sequence 1;
restore archivelog sequence 5;
restore archivelog sequence 10;
restore archivelog sequence 15;
restore archivelog sequence between 20 and 25;
...
}
Answers
-
You need to check the syntax according to your version, but I believe that you will need to do something like this:
run {
restore archivelog sequence 1;
restore archivelog sequence 5;
restore archivelog sequence 10;
restore archivelog sequence 15;
restore archivelog sequence between 20 and 25;
...
}
-
Thanks Luis, that's not as efficient as I hoped but it looks like the only way. I tested this in RAC and it worked as well.
run {
restore archivelog sequence 28466 thread 1;
restore archivelog sequence 29112 thread 2;
restore archivelog sequence 28990 thread 3;
restore archivelog sequence 28992 thread 3;
}
John