Now I see you wanted incremental... so try something like
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.
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.