4 Operator

 • 

14.3K Posts

March 1st, 2006 13:00

Try following:

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).

2 Posts

March 1st, 2006 14:00

Thanks very much for the help. Those passwords are dummy passwords.

4 Operator

 • 

14.3K Posts

March 1st, 2006 14:00

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.
No Events found!

Top