Friday, August 29, 2008

Backup Archive Log with RMAN NOCATALOG

Hi All,

Below is the script that will help you to take a backup of Archive log files when you had not created a catalog.

RMAN> RUN {
2> SET COMMAND ID TO 'RMAN-LOG';
3> ALLOCATE CHANNEL T1 TYPE DISK;
4> allocate channel T2 TYPE DISK;
5> BACKUP ARCHIVELOG ALL
6> TAG = 'OFTT_ARCHIVE'
7> FORMAT = '/db/u11/arch_bkp/%d_log%U_%t' filesperset = 8 delete input;
8> release channel T1;
9> RELEASE CHANNEL T2;
10> }

executing command: SET COMMAND ID
allocated channel: T1

channel T1: sid=253 devtype=DISK
allocated channel: T2

channel T2: sid=18 devtype=DISK
Starting backup at 29-AUG-08

current log archived
channel T1: starting archive log backupset
channel T1: specifying archive log(s) in backup set
input archive log thread=1 sequence=295798 recid=139 stamp=663952391
....................
....................
...................
...................
Finished backup at 29-AUG-08
released channel: T1
released channel: T2
RMAN>


No comments:

Post a Comment