Wednesday, June 19, 2013

Oracle 10g/11g:How to restore archive logs from RMAN Backup ?.


Hi,

It is possible when sometimes we removed archives from archive destination and it requires for synchronize standby database.

For this need to restore from one of the available backup like RMAN,hot backup etc.

We here use RMAN backup script to get the deleted or removed archive logs.

--For All Archive logs from RMAN backup.

RUN 
ALLOCATE CHANNEL C1 DEVICE TYPE DISK; 
RESTORE ARCHIVELOG ALL; 
RELEASE CHANNEL C1;
}


--For only single archive by sequence number.


RUN 
ALLOCATE CHANNEL C1 DEVICE TYPE DISK; 
RESTORE ARCHIVELOG LOGSEQ 12345
RELEASE CHANNEL C1;
}

--For range of sequence number of archives.


RUN 
ALLOCATE CHANNEL C1 DEVICE TYPE DISK; 
RESTORE ARCHIVELOG FROM LOGSEQ 1 UNTIL 12345;
RELEASE CHANNEL C1;
}

No comments:

Post a Comment

Dear User,

Thank you very much for your kind response