Oracle Database Discussions

Hello,

I did a few tests in Virtualbox, running OEL 5.5 and Oracle 11g R2. The Oracle database and FRA are managed by ASM.

I'm wondering about the performance and use of BCT in the 2nd incremental level 1 backup in the last test.

According to Oracle documentation, the use of BCT relies on an initial level 0 backup. In the last test however, BCT was obviously used also after the first incremental level 1 backup without a preceding level 0 backup. Could someone explain this please?

The 1st incremental level 1 backup in the last test did not show that it was doing a level 0 backup.

RMAN> delete backup
SQL> alter database disable block change tracking
RMAN> backup incremental level 0 database - 00:01:46
RMAN> backup incremental level 1 database - 00:00:55
RMAN> backup incremental level 1 database - 00:00:55

RMAN> delete backup
SQL> alter database enable block change tracking
RMAN> backup incremental level 0 database - 00:01:46
RMAN> backup incremental level 1 database - 00:00:04
RMAN> backup incremental level 1 database - 00:00:01

RMAN> delete backup
SQL> alter database disable block change tracking
RMAN> backup incremental level 0 database - 00:01:46
SQL> alter database enable block change tracking
RMAN> backup incremental level 1 database - 00:01:05
RMAN> backup incremental level 1 database - 00:00:04 <- where is the BCT level 0 this is based on?

Thanks,
Markus