RE: database duplication

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <tjambu_freelists@xxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 24 Jun 2005 10:21:41 -0400

I am assuming some flavor of 9i or 8.1.7. Having said this; Did you try to
do a recover in sqlplus?  The command would be;
recover database using backup control file until cancel (or until time... or
until scn ...);

Did you do a point in time restore?  If not, you will definitely need to do
the recovery outside of rman.

Do this as / as sysdba or sys/password to avoid any problems with
permissions.

Call me if you want!  (reply to me only and I will send my phone#);
Ruth

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Friday, June 24, 2005 8:44 AM
To: tjambu_freelists@xxxxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: RE: database duplication


T rying to duplicate a database fails with the following errors:

RMAN-06136: ORACLE error from auxiliary database: ORA-06550: line 1, column
166:

PLS-00553: character set name is not recognized

ORA-06550: line 0, column 0:

PL/SQL: Compilation unit analysis terminated

RMAN-06031: could not translate database keyword

RMAN>



Then when I try alter database open reselogs I get:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u01/oradata/gispr2/system01.dbf'



Help.


Other related posts: