Search This Blog

Monday, 17 April 2023

RMAN backup NOHUP

1. vi rman.rcv


2. Copy this scipt (you can add channels according with cpu number in so, also if you have enough space you can execute without compress):


CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dbbkup01-oracle/oracle_12c_rman_backup/control%F.rman';                    

backup current controlfile format '/dbbkup01-oracle/oracle_12c_rman_backup/control_2.rman';                                                                       

run

{

ALLOCATE CHANNEL c1 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c2 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c3 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c4 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c5 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c6 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c7 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c8 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c9 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c10 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c11 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c12 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c13 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

ALLOCATE CHANNEL c14 TYPE DISK FORMAT '/dbbkup01-oracle/oracle_12c_rman_backup/oracle%t_%s_%p' maxpiecesize 10G;

BACKUP AS COMPRESSED BACKUPSET TAG 'BCK_${ORACLE_SID}_DB_${FECHA}' DATABASE;

RELEASE CHANNEL c1;

RELEASE CHANNEL c2;

RELEASE CHANNEL c3;

RELEASE CHANNEL c4;

RELEASE CHANNEL c5;

RELEASE CHANNEL c6;

RELEASE CHANNEL c7;

RELEASE CHANNEL c8;

RELEASE CHANNEL c9;

RELEASE CHANNEL c10;

RELEASE CHANNEL c11;

RELEASE CHANNEL c12;

RELEASE CHANNEL c13;

RELEASE CHANNEL c14;

}

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

exit;


3. Execute: nohup rman target / @rman.rcv > rman.log &


No comments:

Post a Comment