Re: RMAN-06180: incremental backups require Oracle8 Enterprise Edition

There's a clue in your last error message: RMAN regards incremental level 0 backups as functionaly equivalent to a full database backup (that is, all used or once-used data blocks are included in the backup) in both cases. The only difference, in fact, between the two is that a full backup is not referenced by future incrementals for the purposes of determining what should be freshly backed up, whereas a Level 0 is.

Incremental level 1, however, requires you to backup only those blocks which have changed since the Level 0 backup -and that requires some infrastructure to permit comparison of block SCNs which simply doesn't exist unless you have the Enterprise Edition.

Regards
HJR "Ricardo Ferrao" <gilliam_at_dei.uc.pt> wrote in message news:4f35b131.0201281035.786403d0_at_posting.google.com...
> Hi!
>
> I'm working on one automation backup using RMAN and Oracle 8.05 on a
> NT platform.
> I'm trying to do 4 kind of backups: yearly (incremental backup
> level=0), monthly (incremental cumulative backup level=1), weekly
> (incremental backup level=2) and diary (incremental cumulative backup
> level=3).
> After create the database I've put in ARCHIVE LOG ON mode, create the
> repository (RMAN), registred the target database in the repository,
> done the first full backup (level 0) and then when I tried to do a
> backup of a higher level (1, 2 or 3) I've got the following error:
> "RMAN-06180: incremental backups require Oracle8 Enterprise Edition".
>
> These are the steps I do to do a incremental backup level=0 followed
> by one incremental backup level=1:
>
> --------------------------
> Incremental Backup level=0
> --------------------------
> C:\orant\SYSMAN\SCRIPTS\DBA>ECHO. | DATE | FIND.EXE /V "): "
> The current date is: Seg 07-01-2002
>
> C:\orant\SYSMAN\SCRIPTS\DBA>ECHO. | TIME | FIND.EXE /V "): "
> The current time is: 17:50:35,75
>
> C:\orant\SYSMAN\SCRIPTS\DBA>cd c:\orant\bin
>
> C:\orant\BIN>rman80 cmdfile 'C:\orant\SYSMAN\SCRIPTS\DBA\BKA.cmd'
>
> Recovery Manager: Release 8.0.5.0.0 - Production
> RMAN> connect rcvcat rman/<Password_Rman>@<BackupDB>
> 2> connect target internal/<Password_Internal>@<DB>
> 3> run {
> 4> execute script "Backup Anual";}
> 5> exit
>
> RMAN-06008: connected to recovery catalog database
> RMAN-06005: connected to target database: <DB>
> RMAN-03021: executing script: Backup Anual
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: c1
> RMAN-08500: channel c1: sid=8 devtype=DISK
> RMAN-03022: compiling command: backup
> RMAN-03023: executing command: backup
> RMAN-08008: channel c1: starting datafile backupset
> RMAN-08502: set_count=10 set_stamp=450553845
> RMAN-08010: channel c1: including datafile 3 in backupset
> RMAN-08010: channel c1: including datafile 1 in backupset
> RMAN-08011: channel c1: including current controlfile in backupset
> RMAN-08010: channel c1: including datafile 2 in backupset
> RMAN-08010: channel c1: including datafile 4 in backupset
> RMAN-08010: channel c1: including datafile 5 in backupset
> RMAN-08013: channel c1: piece 1 created
> RMAN-08503: piece

handle=C:\ORANT\DATABASE\ARCHIVE\BK_ANUAL_SIC2000_450553845.10
> comment=NONE
> RMAN-03023: executing command: partial resync
> RMAN-08003: starting partial resync of recovery catalog
> RMAN-08005: partial resync complete
> RMAN-03022: compiling command: release
> RMAN-03023: executing command: release
> RMAN-08031: released channel: c1
> Recovery Manager complete.
>
> --------------------------
> Incremental Backup level 1
> --------------------------
> C:\orant\SYSMAN\SCRIPTS\DBA>ECHO. | DATE | FIND.EXE /V "): "
> The current date is: Seg 07-01-2002
>
> C:\orant\SYSMAN\SCRIPTS\DBA>ECHO. | TIME | FIND.EXE /V "): "
> The current time is: 18:01:23,28
>
> C:\orant\SYSMAN\SCRIPTS\DBA>cd c:\orant\bin
>
> C:\orant\BIN>rman80 cmdfile C:\orant\SYSMAN\SCRIPTS\DBA\BKM.cmd
>
> Recovery Manager: Release 8.0.5.0.0 - Production
> RMAN> connect rcvcat rman/<Password_Rman>@<BackupDB>
> 2> connect target internal/<Password_Internal>@<DB>
> 3> run {
> 4> execute script "Backup Mensal";}
> 5> exit
>
> RMAN-06008: connected to recovery catalog database
> RMAN-06005: connected to target database: <DB>
> RMAN-03021: executing script: Backup Mensal
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: c1
> RMAN-08500: channel c1: sid=14 devtype=DISK
> RMAN-03022: compiling command: backup
> RMAN-00569: ================error message stack
> follows================
> RMAN-03015: error occurred in stored script Backup Mensal
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: backup
> RMAN-06180: incremental backups require Oracle8 Enterprise Edition
> Recovery Manager complete.
>
>
>
> These are the scripts I use:
>
> ----------------------
> 'Backup Anual' Script
> ----------------------
> {
> allocate channel c1 type disk
> format "c:\orant\database\archive\BK_anual_%d_%t.%s";
> backup incremental level=0
> database;
> release channel c1;
> }
>
> ----------------------
> 'Backup Mensal' Script
> ----------------------
> {
> allocate channel c1 type disk
> format "c:\orant\database\archive\BK_mensal_%d_%t.%s";
> backup incremental level=1
> database;
> release channel c1;
> }
>
>
> And here is the description of the error:
>
> -----------------
> Error description
> -----------------
> RMAN-06180 incremental backups require Oracle8 Enterprise Edition
> Cause: A BACKUP command with INCREMENTAL LEVEL > 0 was specified.
> Action: Use FULL or INCREMENTAL LEVEL=0.
>
>
> Question: How can it give me this error when I did an incremental
> backup level=0 just some minutes before I did the incremental backup
> level=1? Can anyone help me on this?
>
> Thanks in advance,
>
> Ricardo Ferrão
Received on Mon Jan 28 2002 - 20:22:41 CST