Skip to content
July 3, 2010 / doganay

HOW TO RESTORE ARCHIVELOG

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Hi,

You can restore your old archivelogs to any destination:

rman target / rcvcat USER/PASSWORD@YOUR_CATALOG_DB

I assume that you use tape:

run
{
ALLOCATE CHANNEL ch00 TYPE ‘SBT_TAPE’;
SEND ‘NB_ORA_CLIENT=YOUR_CLIENT_DEFINITION’;
set archivelog destination to ‘ANY_DIRECTORY_YOU_WANT_TO_RESTORE’;
restore archivelog  from logseq=11200 until logseq=11205 thread 1;
release channel ch00;
}
I restored archives 11200,11201,11202,11203,11204,11025
from thread 1. IN a RAC environment, if you want to restore 2nd node archives for example, use “thread 2”.
add more channels (ch01,ch02,…) to get faster, but remember:
parallelism does not always make you faster..
try and pray 🙂
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: