Troubleshooting › Using RMAN command to Backup, Restore, and Recover Archived Logs

Using RMAN command to Backup, Restore, and Recover Archived Logs

You can perform the backup, restore and recovery operations for the archived logs using the advanced RMAN command, if you do not want to change the database settings in the RAC environment or unable to map to a computer the network.

However, ensure that you put the archived logs on a shared disk or use multiple archived logs destination or map each computer to the network so that they can access the archived logs on all other computers.

Assuming that there are three computers ORA-RAC1, ORA-RAC2 and ORA-RAC3 in the RAC environment, perform the backup and recovery operations using the advanced RMAN scripts.

To perform backup, restore and recovery processes in RAC environment

1. Open command prompt on ORA-RAC1.
2. Execute the command

   RMAN target sys/oracle@RAC1 catalog <catalog owner name>/<password of owner>@<catalog database>
   

3. Run RMAN scripts to perform the backup and restore processes.
   • Run the following RMAN script to backup the archived logs.

     RUN
     {
     ALLOCATE CHANNEL C1 DEVICE TYPE SBT;
     ALLOCATE CHANNEL C2 DEVICE TYPE SBT CONNECT sys/oracle@RAC2;
     ALLOCATE CHANNEL C3 DEV1 DEVICE TYPE SBT CONNECT sys/oracle@RAC3;
     SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
     BACKUP ARCHIVELOG ALL;
     }
     

   • Run the following RMAN script to restore the archived logs.

     RUN
     {
     ALLOCATE CHANNEL C1 DEVICE TYPE SBT;
     ALLOCATE CHANNEL C2 DEVICE TYPE SBT CONNECT sys/oracle@RAC2;
     ALLOCATE CHANNEL C3 DEVICE TYPE SBT CONNECT sys/oracle@RAC3;
     RESTORE ARCHIVELOG ALL;
     }
     

     OR

     RUN
     {
     ALLOCATE CHANNEL C1 DEVICE TYPE SBT;
     ALLOCATE CHANNEL C2 DEVICE TYPE SBT CONNECT sys/oracle@RAC2;
     ALLOCATE CHANNEL C3 DEVICE TYPE SBT CONNECT sys/oracle@RAC3;
     RESTORE ARCHIVELOG FROM LOGSEQ 1 UNTIL LOGSEQ 10 THREAD 1;
     RESTORE ARCHIVELOG FROM LOGSEQ 1 UNTIL LOGSEQ 15 THREAD 2;
     RESTORE ARCHIVELOG FROM LOGSEQ 1 UNTIL LOGSEQ 20 THREAD 3;
     }
     

   Important! Before running the RMAN command for recovery, you must copy all the Archive Logs from ORA-RAC2 and ORA-RAC3 to the Archive Logs destination of RAC1 on ORA-RAC1.