RMAN Command Scripts

 
RMAN commands

— Connect to database via RMAN (make sure you set .oraenv to the correct database)
rman target /

— RMAN command to fix failed archivelog backups with archive logs that are missing or skipped
crosscheck archivelog all

— Execute a FULL RMAN backup (DB and archive logs) to disk
— Format indicates filename (full path)
RUN {
ALLOCATE CHANNEL C1 TYPE DISK;
ALLOCATE CHANNEL C2 TYPE DISK;
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE FORMAT='/local/oracledata/IMDB/rman_dsk/ora_IMDB_DB_%u_%s_%p';
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
ALLOCATE CHANNEL C1 TYPE DISK;
ALLOCATE CHANNEL C2 TYPE DISK;
BACKUP ARCHIVELOG ALL FORMAT='/local/oracledata/IMDB/rman_dsk/ora_IMDB_ARC_%u_%s_%p' DELETE INPUT;
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
}

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

About Jimbart