Trying to do an incremental rman backup without including the archive logs
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';
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';
0