RE: database duplication

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Friday, June 24, 2005 8:44 AM
To: tjambu_freelists_at_yahoo.com.au; Oracle-L_at_freelists.org 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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 24 2005 - 10:28:59 CDT