This is a multi-part message in MIME format.
------_=_NextPart_001_01C3E281.2E8A4D64
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello!
=20
This problem has nothing to do with Veritas. I have tried to make the =
backup to disk instead of using Veritas NetBackup with the same restore =
results.
=20
Sorry for the inconvenience.
=20
Regards
/Jonas Bl=E5berg
=20
-----Ursprungligt meddelande-----
Fr=E5n: veritas-bu-admin AT mailman.eng.auburn DOT edu =
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]F=F6r Jonas Bl=E5berg
Skickat: den 23 januari 2004 12:21
Till: veritas-bu AT mailman.eng.auburn DOT edu
=C4mne: [Veritas-bu] problem restoring oracle RAC cluster database using =
RMAN and Veritas NetBackup
Hello!=20
We have an Oracle RAC Cluster 9.2 running on Redhat Linux ES 2.1. The =
NetBackup version is 4.5 FP3. We are doing hot backups using an RMAN =
recovery catalog.
After finishing a total restore of the database, we are no longer able =
to run a full export of the database!!!! See the exp output in the end =
of this document. It fails on the cluster definitions since they are not =
present (?), which make me think of two things: either it is not able to =
make a backup of the cluster definitions, or it is not able to restore =
the cluster definitions.
The backup has been done with the following rman script:=20
connect target $TPWD=20
connect catalog $CPWD=20
run {=20
allocate channel c1 device type 'SBT_TAPE';=20
allocate channel c2 device type 'SBT_TAPE';=20
allocate channel c3 device type 'SBT_TAPE';=20
send =
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';=20
backup incremental level=3D0 tag "Full backup" filesperset 5 format =
'bk_u%u_s%s_p%p_t%t'=20
database;=20
release channel c1;=20
release channel c2;=20
release channel c3;=20
###=20
sql 'alter system archive log current';=20
###=20
allocate channel c1 device type 'SBT_TAPE';=20
allocate channel c2 device type 'SBT_TAPE';=20
allocate channel c3 device type 'SBT_TAPE';=20
send =
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';=20
backup tag "Arkivloggar vid full backup" filesperset 20 format =
'al_u%u_s%s_p%p_t%t'=20
archivelog all delete input;=20
release channel c1;=20
release channel c2;=20
release channel c3;=20
}=20
quit=20
The restore is done using the following scheme:=20
- startup using saved pfile=20
- restore the spfile=20
- startup using the spfile=20
- restore the control file=20
- restore and recover the database=20
- alter database open resetlogs=20
Does anyone have some experience in this?=20
And yes - on the original database we are able to run the exp command =
(we are currently doing disaster recovery tests so the original database =
is still present).
/jonas bl=E5berg=20
[oracle@seprol01 oracle]$ exp system/manager full=3Dy =
file=3D/tmp/jifodsjisfd log=3D/tmp/gjidfo=20
Export: Release 9.2.0.4.0 - Production on Fri Jan 23 13:22:12 2004=20
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.=20
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production =
With the Partitioning, Real Application Clusters, OLAP and Oracle Data =
Mining options=20
JServer Release 9.2.0.4.0 - Production=20
Export done in US7ASCII character set and AL16UTF16 NCHAR character set=20
server uses AL32UTF8 character set (possible charset conversion)=20
About to export the entire database ...=20
. exporting tablespace definitions=20
. exporting profiles=20
. exporting user definitions=20
. exporting roles=20
. exporting resource costs=20
. exporting rollback segment definitions=20
. exporting database links=20
. exporting sequence numbers=20
. exporting directory aliases=20
. exporting context namespaces=20
. exporting foreign function library names=20
. exporting PUBLIC type synonyms=20
. exporting private type synonyms=20
. exporting object type definitions=20
. exporting system procedural objects and actions=20
. exporting pre-schema procedural objects and actions=20
. exporting cluster definitions=20
EXP-00056: ORACLE error 1403 encountered=20
ORA-01403: no data found=20
EXP-00056: ORACLE error 1403 encountered=20
ORA-01403: no data found=20
EXP-00000: Export terminated unsuccessfully=20
[oracle@seprol01 oracle]$=20
Jonas Bl=E5berg=20
Mandator Infrastructure=20
Kruthusgatan 17,6=20
S-411 04 G=F6teborg=20
jonas.blaberg AT mandator DOT com=20
office: +46-(0)31-739 84 54=20
mobile: +46-(0)709-95 00 68=20
------_=_NextPart_001_01C3E281.2E8A4D64
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>problem restoring oracle RAC cluster database using RMAN and =
Veritas NetBackup</TITLE>
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D449494913-24012004>Hello!</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D449494913-24012004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D449494913-24012004>This=20
problem has nothing to do with Veritas. I have tried to make the backup =
to disk=20
instead of using Veritas NetBackup with the same restore=20
results.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D449494913-24012004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D449494913-24012004>Sorry=20
for the inconvenience.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D449494913-24012004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D449494913-24012004>Regards</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D449494913-24012004>/Jonas=20
Bl=E5berg</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D449494913-24012004></SPAN></FONT> </DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Ursprungligt meddelande-----<BR><B>Fr=E5n:</B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]<B>F=F6r </B>Jonas=20
Bl=E5berg<BR><B>Skickat:</B> den 23 januari 2004 12:21<BR><B>Till:</B> =
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>=C4mne:</B> [Veritas-bu] =
problem=20
restoring oracle RAC cluster database using RMAN and Veritas=20
NetBackup<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=3DArial size=3D2>Hello!</FONT> </P>
<P><FONT face=3DArial size=3D2>We have an Oracle RAC Cluster 9.2 =
running on Redhat=20
Linux ES 2.1. The NetBackup version is 4.5 FP3. We are doing hot =
backups using=20
an RMAN recovery catalog.</FONT></P>
<P><FONT face=3DArial size=3D2>After finishing a total restore of the =
database, we=20
are no longer able to run a full export of the database!!!! See the =
exp output=20
in the end of this document. It fails on the cluster definitions since =
they=20
are not present (?), which make me think of two things: either it is =
not able=20
to make a backup of the cluster definitions, or it is not able to =
restore the=20
cluster definitions.</FONT></P>
<P><FONT face=3DArial size=3D2>The backup has been done with the =
following rman=20
script:</FONT> </P><BR>
<P><FONT face=3DArial size=3D2>connect target $TPWD </FONT><BR><FONT =
face=3DArial=20
size=3D2>connect catalog $CPWD</FONT> <BR><FONT face=3DArial =
size=3D2>run {</FONT>=20
<BR><FONT face=3DArial size=3D2> allocate channel c1 device type =
'SBT_TAPE';</FONT> <BR><FONT face=3DArial size=3D2> allocate =
channel c2=20
device type 'SBT_TAPE';</FONT> <BR><FONT face=3DArial size=3D2> =
allocate=20
channel c3 device type 'SBT_TAPE';</FONT> <BR><FONT face=3DArial =
size=3D2> =20
send=20
=
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';</FONT>=20
<BR><FONT face=3DArial size=3D2> backup incremental level=3D0 =
tag "Full=20
backup" filesperset 5 format 'bk_u%u_s%s_p%p_t%t' </FONT><BR><FONT =
face=3DArial=20
size=3D2> database;</FONT> <BR><FONT face=3DArial =
size=3D2> =20
release channel c1;</FONT> <BR><FONT face=3DArial size=3D2> =
release channel=20
c2;</FONT> <BR><FONT face=3DArial size=3D2> release channel =
c3;</FONT>=20
<BR><FONT face=3DArial size=3D2>###</FONT> <BR><FONT face=3DArial =
size=3D2> sql=20
'alter system archive log current';</FONT> <BR><FONT face=3DArial=20
size=3D2>###</FONT> <BR><FONT face=3DArial size=3D2> allocate =
channel c1=20
device type 'SBT_TAPE';</FONT> <BR><FONT face=3DArial size=3D2> =
allocate=20
channel c2 device type 'SBT_TAPE';</FONT> <BR><FONT face=3DArial =
size=3D2> =20
allocate channel c3 device type 'SBT_TAPE';</FONT> <BR><FONT =
face=3DArial=20
size=3D2> send=20
=
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';</FONT>=20
<BR><FONT face=3DArial size=3D2> backup tag "Arkivloggar vid =
full backup"=20
filesperset 20 format 'al_u%u_s%s_p%p_t%t' </FONT><BR><FONT =
face=3DArial=20
size=3D2> archivelog all delete input;</FONT> =
<BR><FONT=20
face=3DArial size=3D2> release channel c1;</FONT> <BR><FONT =
face=3DArial=20
size=3D2> release channel c2;</FONT> <BR><FONT face=3DArial =
size=3D2> =20
release channel c3;</FONT> <BR><FONT face=3DArial size=3D2> =
}</FONT>=20
<BR><FONT face=3DArial size=3D2>quit</FONT> </P><BR>
<P><FONT face=3DArial size=3D2>The restore is done using the following =
scheme:</FONT> <BR><FONT face=3DArial size=3D2>- startup using saved =
pfile</FONT>=20
<BR><FONT face=3DArial size=3D2>- restore the spfile</FONT> <BR><FONT =
face=3DArial=20
size=3D2>- startup using the spfile</FONT> <BR><FONT face=3DArial =
size=3D2>- restore=20
the control file</FONT> <BR><FONT face=3DArial size=3D2>- restore and =
recover the=20
database</FONT> <BR><FONT face=3DArial size=3D2>- alter database open=20
resetlogs</FONT> </P><BR><BR>
<P><FONT face=3DArial size=3D2>Does anyone have some experience in =
this?</FONT>=20
</P>
<P><FONT face=3DArial size=3D2>And yes - on the original database we =
are able to=20
run the exp command (we are currently doing disaster recovery tests so =
the=20
original database is still present).</FONT></P>
<P><FONT face=3DArial size=3D2>/jonas bl=E5berg</FONT> </P><BR><BR>
<P><FONT face=3DArial size=3D2>[oracle@seprol01 oracle]$ exp =
system/manager full=3Dy=20
file=3D/tmp/jifodsjisfd log=3D/tmp/gjidfo</FONT> </P>
<P><FONT face=3DArial size=3D2>Export: Release 9.2.0.4.0 - Production =
on Fri Jan=20
23 13:22:12 2004</FONT> </P>
<P><FONT face=3DArial size=3D2>Copyright (c) 1982, 2002, Oracle =
Corporation. =20
All rights reserved.</FONT> </P><BR>
<P><FONT face=3DArial size=3D2>Connected to: Oracle9i Enterprise =
Edition Release=20
9.2.0.4.0 - Production</FONT> <BR><FONT face=3DArial size=3D2>With the =
Partitioning, Real Application Clusters, OLAP and Oracle Data Mining=20
options</FONT> <BR><FONT face=3DArial size=3D2>JServer Release =
9.2.0.4.0 -=20
Production</FONT> <BR><FONT face=3DArial size=3D2>Export done in =
US7ASCII=20
character set and AL16UTF16 NCHAR character set</FONT> <BR><FONT =
face=3DArial=20
size=3D2>server uses AL32UTF8 character set (possible charset =
conversion)</FONT>=20
</P>
<P><FONT face=3DArial size=3D2>About to export the entire database =
...</FONT>=20
<BR><FONT face=3DArial size=3D2>. exporting tablespace =
definitions</FONT>=20
<BR><FONT face=3DArial size=3D2>. exporting profiles</FONT> <BR><FONT =
face=3DArial=20
size=3D2>. exporting user definitions</FONT> <BR><FONT face=3DArial =
size=3D2>.=20
exporting roles</FONT> <BR><FONT face=3DArial size=3D2>. exporting =
resource=20
costs</FONT> <BR><FONT face=3DArial size=3D2>. exporting rollback =
segment=20
definitions</FONT> <BR><FONT face=3DArial size=3D2>. exporting =
database=20
links</FONT> <BR><FONT face=3DArial size=3D2>. exporting sequence =
numbers</FONT>=20
<BR><FONT face=3DArial size=3D2>. exporting directory aliases</FONT> =
<BR><FONT=20
face=3DArial size=3D2>. exporting context namespaces</FONT> <BR><FONT =
face=3DArial=20
size=3D2>. exporting foreign function library names</FONT> <BR><FONT =
face=3DArial=20
size=3D2>. exporting PUBLIC type synonyms</FONT> <BR><FONT =
face=3DArial size=3D2>.=20
exporting private type synonyms</FONT> <BR><FONT face=3DArial =
size=3D2>. exporting=20
object type definitions</FONT> <BR><FONT face=3DArial size=3D2>. =
exporting system=20
procedural objects and actions</FONT> <BR><FONT face=3DArial =
size=3D2>. exporting=20
pre-schema procedural objects and actions</FONT> <BR><FONT =
face=3DArial size=3D2>.=20
exporting cluster definitions</FONT> <BR><FONT face=3DArial =
size=3D2>EXP-00056:=20
ORACLE error 1403 encountered</FONT> <BR><FONT face=3DArial =
size=3D2>ORA-01403: no=20
data found</FONT> <BR><FONT face=3DArial size=3D2>EXP-00056: ORACLE =
error 1403=20
encountered</FONT> <BR><FONT face=3DArial size=3D2>ORA-01403: no data =
found</FONT>=20
<BR><FONT face=3DArial size=3D2>EXP-00000: Export terminated =
unsuccessfully</FONT>=20
<BR><FONT face=3DArial size=3D2>[oracle@seprol01 oracle]$=20
</FONT></P><BR><BR><BR><BR>
<P><FONT face=3DArial size=3D2>Jonas Bl=E5berg</FONT> <BR><FONT =
face=3DArial=20
size=3D2> Mandator Infrastructure</FONT> <BR><FONT face=3DArial=20
size=3D2> Kruthusgatan 17,6</FONT> <BR><FONT face=3DArial =
size=3D2> =20
S-411 04 G=F6teborg</FONT> <BR><FONT face=3DArial=20
size=3D2>jonas.blaberg AT mandator DOT com</FONT> <BR><FONT face=3DArial =
size=3D2>office:=20
+46-(0)31-739 84 54</FONT> <BR><FONT face=3DArial size=3D2>mobile: =
+46-(0)709-95=20
00 68</FONT> </P><BR></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C3E281.2E8A4D64--
|
