 | | | database duplication | database duplication 2005-06-24 - By Ruth Gramolini
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@(protected) [mailto:oracle-l-bounce@(protected)]On
Behalf Of Paula_Stankus@(protected)
Sent: Friday, June 24, 2005 8:44 AM
To: tjambu_freelists@(protected); Oracle-L@(protected)
Subject: RE: database duplication
T rying to duplicate a database fails with the following errors:
RMAN-06136: ORACLE error from auxiliary database: ORA-06550 (See ORA-06550.ora-code.com): line 1, column
166:
PLS-00553: character set name is not recognized
ORA-06550 (See ORA-06550.ora-code.com): 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 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01194 (See ORA-01194.ora-code.com): file 1 needs more recovery to be consistent
ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/u01/oradata/gispr2/system01.dbf'
Help.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1505" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=848541614-24062005><FONT face=Arial size=2>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;</FONT></SPAN></DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial size=2>recover database
using backup control file until cancel (or until time... or until
scn ...);</FONT></SPAN></DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial size=2>Did you do a point
in time restore? If not, you will definitely need to do the recovery
outside of rman.</FONT></SPAN></DIV>
<DIV><SPAN class=848541614-24062005></SPAN><SPAN class=848541614-24062005><FONT
face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial size=2>Do this as / as
sysdba or sys/password to avoid any problems with
permissions. </FONT></SPAN></DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial size=2>Call me if you
want! (reply to me only and I will send my phone#);</FONT></SPAN></DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial
size=2>Ruth</FONT> </SPAN></DIV>
<DIV><SPAN class=848541614-24062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-- --Original Message-- --<BR><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]<B>On Behalf Of</B>
Paula_Stankus@(protected)<BR><B>Sent:</B> Friday, June 24, 2005 8:44
AM<BR><B>To:</B> tjambu_freelists@(protected);
Oracle-L@(protected)<BR><B>Subject:</B> RE: database
duplication<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black;
FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=247484212-24062005></SPAN>T<SPAN class=247484212-24062005><FONT face
=Arial
color=#0000ff size=2> rying to duplicate a database fails with the
following errors:</FONT></SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black;
FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=247484212-24062005></SPAN></SPAN> </DIV><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black;
FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=247484212-24062005><FONT size=2>
<P dir=ltr align=left>RMAN-06136: ORACLE error from auxiliary database:
ORA-06550 (See ORA-06550.ora-code.com): line 1, column 166:</P>
<P dir=ltr align=left>PLS-00553: character set name is not recognized</P>
<P dir=ltr align=left>ORA-06550 (See ORA-06550.ora-code.com): line 0, column 0:</P>
<P dir=ltr align=left>PL/SQL: Compilation unit analysis terminated</P>
<P dir=ltr align=left>RMAN-06031: could not translate database keyword</P>
<P dir=ltr align=left>RMAN></P>
<DIV dir=ltr align=left></FONT> </DIV>
<DIV dir=ltr align=left> </DIV>
<DIV dir=ltr align=left><SPAN class=247484212-24062005><FONT size=2>Then when I
try alter database open reselogs I get:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=247484212-24062005></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=247484212-24062005>
<P><FONT size=2>ORA-01547 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would
get error below</FONT></P>
<P><FONT size=2>ORA-01194 (See ORA-01194.ora-code.com): file 1 needs more recovery to be
consistent</FONT></P>
<P><FONT size=2>ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/u01/oradata/gispr2/system01.dbf'<SPAN
class=247484212-24062005><FONT face=Arial
color=#0000ff> </FONT></SPAN></FONT></P>
<P><FONT size=2><SPAN class=247484212-24062005></SPAN></FONT> </P>
<P><FONT size=2><SPAN class=247484212-24062005><FONT face=Arial
color=#0000ff>Help.</FONT> </SPAN></FONT></P></SPAN> </SPAN><BR></DIV
></SPAN><!-- END-ANTISPAM-VOTING-LINKS --></BODY></HTML>
|
|
|