This is a multi-part message in MIME format.
------_=_NextPart_001_01C3E1A3.0B8C702A
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello!
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:
connect target $TPWD=20
connect catalog $CPWD
run {
allocate channel c1 device type 'SBT_TAPE';
allocate channel c2 device type 'SBT_TAPE';
allocate channel c3 device type 'SBT_TAPE';
send =
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';
backup incremental level=3D0 tag "Full backup" filesperset 5 format =
'bk_u%u_s%s_p%p_t%t'=20
database;
release channel c1;
release channel c2;
release channel c3;
###
sql 'alter system archive log current';
###
allocate channel c1 device type 'SBT_TAPE';
allocate channel c2 device type 'SBT_TAPE';
allocate channel c3 device type 'SBT_TAPE';
send =
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';
backup tag "Arkivloggar vid full backup" filesperset 20 format =
'al_u%u_s%s_p%p_t%t'=20
archivelog all delete input;
release channel c1;
release channel c2;
release channel c3;
}
quit
The restore is done using the following scheme:
- startup using saved pfile
- restore the spfile
- startup using the spfile
- restore the control file
- restore and recover the database
- alter database open resetlogs
Does anyone have some experience in this?
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
[oracle@seprol01 oracle]$ exp system/manager full=3Dy =
file=3D/tmp/jifodsjisfd log=3D/tmp/gjidfo
Export: Release 9.2.0.4.0 - Production on Fri Jan 23 13:22:12 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data =
Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data found
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data found
EXP-00000: Export terminated unsuccessfully
[oracle@seprol01 oracle]$=20
Jonas Bl=E5berg
Mandator Infrastructure
Kruthusgatan 17,6
S-411 04 G=F6teborg
jonas.blaberg AT mandator DOT com
office: +46-(0)31-739 84 54
mobile: +46-(0)709-95 00 68
------_=_NextPart_001_01C3E1A3.0B8C702A
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.6944.0">
<TITLE>problem restoring oracle RAC cluster database using RMAN and =
Veritas NetBackup</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Hello!</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">The backup has been done with the =
following rman script:</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">connect target $TPWD </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">connect catalog $CPWD</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">run {</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> allocate channel c1 device type =
'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> allocate channel c2 device type =
'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> allocate channel c3 device type =
'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> send =
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> backup incremental level=3D0 =
tag "Full backup" filesperset 5 format 'bk_u%u_s%s_p%p_t%t' =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> database;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> release channel c1;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> release channel c2;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> release channel c3;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">###</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> sql 'alter system archive log =
current';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">###</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> allocate channel c1 device type =
'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> allocate channel c2 device type =
'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> allocate channel c3 device type =
'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> send =
'NB_ORA_POLICY=3D$POLICY,NB_ORA_SERV=3D$SERVER,NB_ORA_CLIENT=3D$CLIENT,NB=
_ORA_SCHED=3D$SCHEDULE1';</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> backup tag "Arkivloggar =
vid full backup" filesperset 20 format 'al_u%u_s%s_p%p_t%t' </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> archivelog all =
delete input;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> release channel c1;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> release channel c2;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> release channel c3;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> }</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">quit</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">The restore is done using the following =
scheme:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">- startup using saved pfile</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">- restore the spfile</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">- startup using the spfile</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">- restore the control file</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">- restore and recover the =
database</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">- alter database open resetlogs</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">Does anyone have some experience in =
this?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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).</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">/jonas bl=E5berg</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">[oracle@seprol01 oracle]$ exp =
system/manager full=3Dy file=3D/tmp/jifodsjisfd =
log=3D/tmp/gjidfo</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Export: Release 9.2.0.4.0 - Production =
on Fri Jan 23 13:22:12 2004</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Copyright (c) 1982, 2002, Oracle =
Corporation. All rights reserved.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">Connected to: Oracle9i Enterprise =
Edition Release 9.2.0.4.0 - Production</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">With the Partitioning, Real =
Application Clusters, OLAP and Oracle Data Mining options</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">JServer Release 9.2.0.4.0 - =
Production</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Export done in US7ASCII character set =
and AL16UTF16 NCHAR character set</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">server uses AL32UTF8 character set =
(possible charset conversion)</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">About to export the entire database =
...</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting tablespace =
definitions</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting profiles</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting user definitions</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting roles</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting resource costs</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting rollback segment =
definitions</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting database links</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting sequence numbers</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting directory aliases</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting context namespaces</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting foreign function library =
names</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting PUBLIC type =
synonyms</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting private type =
synonyms</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting object type =
definitions</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting system procedural objects =
and actions</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting pre-schema procedural =
objects and actions</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. exporting cluster definitions</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">EXP-00056: ORACLE error 1403 =
encountered</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">ORA-01403: no data found</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">EXP-00056: ORACLE error 1403 =
encountered</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">ORA-01403: no data found</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">EXP-00000: Export terminated =
unsuccessfully</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">[oracle@seprol01 oracle]$ </FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">Jonas Bl=E5berg</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> Mandator Infrastructure</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> Kruthusgatan 17,6</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> S-411 04 G=F6teborg</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">jonas.blaberg AT mandator DOT com</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">office: +46-(0)31-739 84 54</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">mobile: +46-(0)709-95 00 68</FONT>
</P>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C3E1A3.0B8C702A--
|
