Unsolved
This post is more than 5 years old
2 Posts
0
1102
March 1st, 2006 13:00
Oracle Archive log backup
Hello All,
I have RMAN scripts which I use for the incremental and full backups of my Oracle 10G DB. An Example is listed below;
-----------------------------------
connect target sys/db10super@rcatdb10;
connect rcvcat rman/rman@DB10;
run {
set command id to '123';
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=xyz.abc.com)';
backup full filesperset 4
format '/FULL_%d_%U/'
(database);
release channel t1;
release channel t2;
}
-----------------------------------
I am looking for a correct syntax to be added in the above script to be able to backup Archive logs and be able delete the logs after the backup.
I have used the following line in the past, but legato did not like it;
------------------------------------
BACKUP INCREMENTAL LEVEL 1 DATABASE PLUS ARCHIVELOG DELETE ALL INPUT tag="Full_L1";
------------------------------------
Any pointers will be appreciated.
Thanks
I have RMAN scripts which I use for the incremental and full backups of my Oracle 10G DB. An Example is listed below;
-----------------------------------
connect target sys/db10super@rcatdb10;
connect rcvcat rman/rman@DB10;
run {
set command id to '123';
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=xyz.abc.com)';
backup full filesperset 4
format '/FULL_%d_%U/'
(database);
release channel t1;
release channel t2;
}
-----------------------------------
I am looking for a correct syntax to be added in the above script to be able to backup Archive logs and be able delete the logs after the backup.
I have used the following line in the past, but legato did not like it;
------------------------------------
BACKUP INCREMENTAL LEVEL 1 DATABASE PLUS ARCHIVELOG DELETE ALL INPUT tag="Full_L1";
------------------------------------
Any pointers will be appreciated.
Thanks
No Events found!
ble1
4 Operator
•
14.3K Posts
0
March 1st, 2006 13:00
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup full filesperset 4 archivelog all delete input skip inaccessible format 'ORCL:/FULL_ARC_%d_%u/';
Also, it's not wise to list in public place password of your target - you never know... (even this forum is public only for LGTO customers).
anaser
2 Posts
0
March 1st, 2006 14:00
ble1
4 Operator
•
14.3K Posts
0
March 1st, 2006 14:00
backup incremental level 1 database include current controlfile;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
change archivelog all validate;
backup archivelog all delete input skip inaccessible format 'ORCL:/INC_ARC_%d_%u/';
Not sure about 10g, but with 9i backing up controlfile was something you had to specify. Validate line is there for sync purpose (to avoid RMAN-06089). Some more details can be found at http://www.orafaq.com/faqdbabr.htm which is very nice resource for RMAN.