Database Backup and Recovery (MOSC)

MOSC Banner

Trying to do an incremental rman backup without including the archive logs

edited Oct 29, 2012 6:10AM in Database Backup and Recovery (MOSC) 10 commentsAnswered
Number 1, I'm not sure this can be done.  I'm being asked to create backups in this manner:Level 0
Level 1
ARCHIVELOGS

I've go just the archive logs to work fine, but am having problems with the level 0 and level 1, here's the ctl file:

connect target /@ORCL
RUN
{
sql 'alter session set nls_date_format="DD-MON-YYYY HH24:MI:SS"';
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
sql 'alter system archive log current';
shutdown immediate;
startup mount;
allocate channel c1 device type disk format 'UNCPATH\ORCL\FULL\%U';
backup AS COMPRESSED BACKUPSET incremental level 0 cumulative database;
backup current controlfile;
sql 'alter database open';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center