Posts

Showing posts from June 19, 2013

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

Image
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; }