Hi All,

My test case for RMAN B&R with noarchivelog database is:

Unix environment:
export NLS_LANG=american
export NLS_DATE_FORMAT='YYYY-MM-DD:HH24:MI:SS'

RMAN environment:
CONFIGURE RETENTION POLICY TO REDUNDANCY 5;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
(leave the rest default)

Using Recovery Catalog, perform RMAN backup and data load

1) Level 0 incremental cumulative backup
2) load 10000 records, alter system switch logfile; x 3
3) Level 1 incremental cumulative backup
4) load 10000 records, alter system switch logfile; x 3
5) Level 2 incremental cumulative backup


Test Recovey:
shutdown immediate;
startup nomount;
list incarnation;
reset database to incarnation #
(# is the Incarnation No. prior to rman backup)
run {
set until time '2004-05-12:15:03:00';
restore controlfile;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}


I managed to recover to both Level1 and Level2 backups sucessfully.

Appreciate any feedbackup.

Cheers
Oracbase