Pbm 8i -> 9i migration with rman

From: Hieraklion <hieraklion_at_noos.fr>
Date: Fri, 05 Apr 2002 12:37:07 +0200
Message-ID: <3CAD7E53.8090709@noos.fr>

"Bonjour" from Paris,

I migrate a target and a catalog database from 816.0.0 64b to a 9i 64b on Sun Sparc Solaris 2.8.
I migrate the rman catalog too.

Everything works fine.

The pbm now :

When I launch a configure retention policy in rman .... the command hangs several minutes and finally the target database crashes.

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS; <several minutes (10min) and the following msg >

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-00579: the following error occurred at 03/21/2002 15:45:57 RMAN-10039: error encountered while polling for RPC completion on channel default
RMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1
and serial=:2

RMAN-10002: ORACLE error: ORA-03113: end-of-file on communication channel
RMAN-03002: failure during compilation of command
RMAN-03013: command type: configure
RMAN-06003: ORACLE error from target database: ORA-03113: end-of-file on

communication channel
RMAN-06097: text of failing SQL statement: begin :confno := dbms_backup_restore
. setConfig ( :name , :value ) ;
RMAN-06099: error occurred in source file: krmk.pc, line: 26194

In a trace file identify in the alert.log of the target database :

• 2002-03-21 15:45:45.504
• SESSION ID:(4.1) 2002-03-21 15:45:45.342 TIMEOUT ON CONTROL FILE ENQUEUE mode=S, type=0, wait=1, eqt=900

  ---

  SYSTEM STATE

  ---

  System global information: processes: base 382cbb ... KSTDUMP: End of in-memory trace dump error 600 detected in background process ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []

Before the crash and this error, il see in the alert.log of the target database
a lot of message like (during the wait of the configure command) : Thu Mar 21 15:36:41 2002
kccrsz: expanded controlfile section 8 from 215 to 236 records

The catalog database does not crash.

I said strange ...

Any idea ??

Thanks
Hieraklion Received on Fri Apr 05 2002 - 04:37:07 CST