Search This Blog

Wednesday, January 17, 2007

Hot_full_rman_bkp_scirpt

Database Version : 10.1.0.2.0
OS platform : Window XP sp2
--------------------------------
Archive log >>> Enabled
Hot Backup
--------------------------------
My backup procedure.
Fri Sat Sun Mon Tue Wed Thur Fri

Incremental Level 0 - - - - - - 0
Incremental Level - 1 1 - 1 1 1 1
Inc_level_cumulative - - - 1 - - - -
---------------------------------------------------------------------
Incremental Level 0 Script

Backup.rcv file content
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CHANNEL DEVICE TYPE disk RATE 2M;

RUN
{
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
ALLOCATE CHANNEL C1 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C2 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C3 DEVICE TYPE DISK MAXPIECESIZE 100M;
BACKUP INCREMENTAL LEVEL 0 DATABASE TAG Weekly_Friday_0_Hotdb02_bkp;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP DATABASE ARCHIVELOG ALL DELETE ALL INPUT TAG Weekly_Friday_0_Hotdb02_bkp;
BACKUP VALIDATE DATABASE;
BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
}




-------------------------------------------------
Incremental Level 1 Script
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CHANNEL DEVICE TYPE disk RATE 2M;

RUN
{
ALLOCATE CHANNEL C1 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C2 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C3 DEVICE TYPE DISK MAXPIECESIZE 100M;
BACKUP INCREMENTAL LEVEL 1 DATABASE TAG Increment_Lvl_1_Hotdb02_bkp;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP DATABASE ARCHIVELOG ALL TAG Increment_Lvl_1_Hotdb02_bkp;
}




-----------------------------------------------------------------
Incremental_cumulative_level_1 script


CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CHANNEL DEVICE TYPE disk RATE 2M;

RUN
{
ALLOCATE CHANNEL C1 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C2 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C3 DEVICE TYPE DISK MAXPIECESIZE 100M;
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE TAG Increment_Lvl_1_CUM_Hotdb02_bkp;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP DATABASE ARCHIVELOG ALL TAG Increment_Lvl_1_CUM_Hotdb02_bkp;
}


---------------------------------------------------------

Above backup procedure i scheduled every day 11.00 pm according backup procedure.
for that create one windows NT COMMAND script.
My command script file is.
backup.cmdbelow is contents.
c:\oracle\product\10.1.0\db_1\bin\RMAN TARGET /@db02 CATALOG rman/cat@catdb CMDFILE=d:\bkp_scripts\db02\backup.rcv LOG=d:\bkp_scripts\db02\backup.log

3 comments:

Anonymous said...

pls post some information on how to schedule the apps database backup on tape using Rman

parvinder said...

pls post some information on how to schedule the apps database backup on tape using Rman

parvinder said...

pls post some information on how to schedule the apps database backup on tape using Rman