RMAN Full_BACKUP Script

[oravis@dbvis 12.1.0]$ . VIS_dbvis.env
[oravis@dbvis 12.1.0]$ rman target/

Recovery Manager: Release 12.1.0.2.0 – Production on Wed Jul 6 15:13:36 2022

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: VIS (DBID=502546441)

RMAN>

run {
set command id to ‘VISION_OnlineBackupFull’;
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
ALLOCATE CHANNEL c5 DEVICE TYPE disk;
backup AS COMPRESSED BACKUPSET full database tag VISION_FULL format ‘/dbvis/RMAN/rmanbkp/%d_%T_%s_%p_FULL’;
backup format ‘/visprod/RMAN/rmanbkp/RMAN_ARCH_%d_%T_%s_%p_%u.bkp’ archivelog all;
backup tag VISION_CONTROL current controlfile format ‘/dbvis/RMAN/rmanbkp/%d_%T_%s_%p_CONTROL’;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}
exit
EOF

or

we can schdule the crontab

we save the file name rman_backup.sh

00 23 * * * sh /home/oravis/scripts/rmanbackup.sh ===> schduling the daily 11 pm taking rman backup .

1 thought on “RMAN Full_BACKUP Script”

Leave a Comment

Your email address will not be published. Required fields are marked *