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

In article <4f35b131.0201281034.5ad0565e_at_posting.google.com>, gilliam_at_dei.uc.pt says...
>
>Hi!
>

sort of silly question based on the error message - but - do you have EE?

You can not take an incremental backup in RMAN with the Standard Edition of Oracle. You must either take a FULL backup or specify an incremental level of 0 (which is the equivalent of a full backup).

>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>_at_<BackupDB>
>2> connect target internal/<Password_Internal>_at_<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>_at_<BackupDB>
>2> connect target internal/<Password_Internal>_at_<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

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp