OraFAQ Forum: Backup & Recovery » Need your assitance to CREATE an 10g RMAN level 1 backup script

Home » RDBMS Server » Backup & Recovery » Need your assitance to CREATE an 10g RMAN level 1 backup script (Oracle 10gR2, HP UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need your assitance to CREATE an 10g RMAN level 1 backup script [message #403497]

Fri, 15 May 2009 21:31

brusko_zaragoza
Messages: 2
Registered: May 2009
Location: Philippines

Junior Member

Hi Experts,

I want to create an RMAN level 1 backup script. Can you please provide me the level 1 script ? Thanks in advance.

To see what the channel allocations for D02 are, you need to look at the current persistent config settings.

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 45 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/D02/rman/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO BACKUPSET PARALLELISM 4;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 1 PARMS 'BLKSIZE=1048576,ENV=(NSR_CLIENT=dbsd02,NSR_SERVER=aesnsr,NSR_MMDB_RETRY_TIME=30,NSR_DATA_VOLUME_POOL=aesdevrman)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/D02/102_64/dbs/snapcf_D02.f'; # default

RMAN>

Report message to a moderator