Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with rman incremental backup level 1,2,... (ver. 8.1.7.4.0)

Re: Problem with rman incremental backup level 1,2,... (ver. 8.1.7.4.0)

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 24 Sep 2004 19:31:13 +0200
Message-ID: <ocm8l017d4cfb5qnombmckgh2mqn89qkbs@4ax.com>


On Fri, 24 Sep 2004 15:36:24 +0200, "Piotr Gradzki" <piotr.gradzki_removeit_at_removeit.cetelem.pl> wrote:

>Hi,
>When I'm trying to make an incremental level 1 backup I get the following
>error:
>RMAN-06009: using target database controlfile instead of recovery catalog
>
>RMAN> run {
>2> allocate channel c1 type disk
>3> format='/backup_test/backup_inc1.bak' ;
>4> backup incremental level = 1 (database);
>5> release channel c1;}
>6>
>RMAN-03022: compiling command: allocate
>RMAN-03023: executing command: allocate
>RMAN-08030: allocated channel: c1
>RMAN-08500: channel c1: sid=46 devtype=DISK
>
>RMAN-03022: compiling command: backup
>RMAN-03026: error recovery releasing channel resources
>RMAN-08031: released channel: c1
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-03002: failure during compilation of command
>RMAN-03013: command type: backup
>RMAN-06003: ORACLE error from target database: ORA-06550: line 1, column
>120:
>PLS-00306: wrong number or types of arguments in call to 'GETINCREMENTALSCN'
>ORA-06550: line 1, column 120:
>PL/SQL: Statement ignored
>RMAN-06097: text of failing SQL statement: declare first boolean := FALSE ;
>rcvRec dbms_rcvman . rcvRec_t ; begin if ( :first > 0 ) THEN first := TRUE ;
>end if ; dbms_rcvman . getIncrementalScn ( first => first , file# =>
>to_number ( NULL ) , create_scn => to_number ( NULL ) , reset_scn =>
>to_number ( NULL ) , reset_time => to_date ( NULL ) , incr_level =>
>:incr_lvl , cumulative => :cumulat , rcvRec => rcvRec ) ; :fno := rcvRec .
>dfNumber_obj ; :ckpscn := rcvRec . toSCN_act ; :crescn := rcvRec .
>dfCreationSCN_obj ; :rlgscn := rcvRec . rlgSCN_act ; :r
>RMAN-06099: error occurred in source file: krmk.pc, line: 5500
>
>The incremental backup level 0 is fine. I'm using the control file for
>catalog.
>
>Has anyone any idea what to do with this?
>
>Best regards
>Piotr Gradzki
>
>
>

Not really, as the exact command is not echoed, so your post is incomplete.
However, I use the incremental clause of the backup command and I don't have any problem.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Sep 24 2004 - 12:31:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US