Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Problems with backup

Problems with backup

From: Josef Huber <oracle-db_at_bretterbauer.at>
Date: Mon, 13 Nov 2000 10:55:46 +0100
Message-Id: <10679.121855@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_000D_01C04D60.46CE53A0
Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



hello i'm running oracle 8i (8.1.6) under windows nt
i backup the database from rman


since last week i become the following error


RMAN-03022: Befehl wird kompiliert: allocate
RMAN-03023: Befehl wird ausgef=FChrt: allocate
RMAN-08030: Zugewiesener Kanal: CHANNEL_SICHERUNGz
RMAN-08500: Kanal CHANNEL_SICHERUNGz: SID=3D35 Ger=E4tetyp=3DDISK

RMAN-03022: Befehl wird kompiliert: backup


RMAN-03023: Befehl wird ausgef=FChrt: backup
RMAN-08008: Kanal CHANNEL_SICHERUNGz: Backup-Satz f=FCr Datendatei wird =
begonnen full


RMAN-08502: Einstellen_Z=E4hlung=3D439 Einstellen_Stempel=3D413517609 =
Erstellungs_Zeitpunkt=3D13.11.00


RMAN-08010: Kanal CHANNEL_SICHERUNGz: Datendatei wird in Backup-Satz =
einbezogen


RMAN-08522: Eingabe-Datendatei fno=3D00003 =
Name=3DG:\ORACLEDATEN\USERS01.DBF


RMAN-08522: Eingabe-Datendatei fno=3D00007 =
Name=3DH:\ORACLEDATEN\INDX01.DBF


RMAN-08522: Eingabe-Datendatei fno=3D00002 =
Name=3DF:\ORACLEDATEN\RBS01.DBF


RMAN-08522: Eingabe-Datendatei fno=3D00005 =
Name=3DF:\ORACLEDATEN\TEMP01.DBF


RMAN-08522: Eingabe-Datendatei fno=3D00001 =
Name=3DE:\ORACLEDATEN\SYSTEM01.DBF


RMAN-08011: Aktuelle Steuerdatei wird in Backup-Gruppe einbezogen
RMAN-08522: Eingabe-Datendatei fno=3D00009 =
Name=3DE:\ORACLEDATEN\DR01.DBF


RMAN-08522: Eingabe-Datendatei fno=3D00006 =
Name=3DE:\ORACLEDATEN\SYSMAN01.DBF


RMAN-08522: Eingabe-Datendatei fno=3D00004 =
Name=3DG:\ORACLEDATEN\USERSWM01.DBF


RMAN-08522: Eingabe-Datendatei fno=3D00008 =
Name=3DH:\ORACLEDATEN\INDXWM01.DBF


RMAN-08013: Kanal CHANNEL_SICHERUNGz: St=FCck 1 wurde erstellt
RMAN-08503: St=FCck-Handle=3DZ:\SICHERUNGDB\B_DNCABHP9_439_1 =
Kommentar=3DNONE


RMAN-08525: Backup-Satz abgeschlossen, verstrichene Zeit: 00:17:57

RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE =


STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00601: fatal error in recovery manager


RMAN-03004: fatal error during execution of command
RMAN-10006: error running sql statement: select sofar, context from =
v$session_longops where sid =3D (select distinct sid from v$mystat) and =
opname like 'RMAN:%' order by start_time desc, context desc
RMAN-10002: ORACLE error: ORA-03113: Unerwartetes =DCbertragungsende in =
Kommunikation



for three days i've shutdown the database and the backup works =
successfully and today i become above error again




any ideas i can't shutdown my database all days



thanx joe



------=_NextPart_000_000D_01C04D60.46CE53A0
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=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">


<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>

<STYLE></STYLE>

</HEAD>

<BODY bgColor=3D#ffffff>

<DIV><FONT face=3DArial size=3D2>hello i'm running oracle 8i (8.1.6) =

under windows=20


nt</FONT></DIV>


<DIV><FONT face=3DArial size=3D2>i backup the database from =

rman</FONT></DIV>


<DIV><FONT face=3DArial size=3D2>since last week i become the following=20


error</FONT></DIV>




<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>RMAN-03022: Befehl wird kompiliert:=20

allocate<BR>RMAN-03023: Befehl wird ausgef=FChrt: =
allocate<BR>RMAN-08030:=20


Zugewiesener Kanal: CHANNEL_SICHERUNGz<BR>RMAN-08500: Kanal =
CHANNEL_SICHERUNGz:=20


SID=3D35 Ger=E4tetyp=3DDISK</FONT></DIV>


<DIV>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>RMAN-03022: Befehl wird kompiliert:=20

backup<BR>RMAN-03023: Befehl wird ausgef=FChrt: backup<BR>RMAN-08008: =
Kanal=20


CHANNEL_SICHERUNGz: Backup-Satz f=FCr Datendatei wird begonnen =
full<BR>RMAN-08502:=20


Einstellen_Z=E4hlung=3D439 Einstellen_Stempel=3D413517609=20
Erstellungs_Zeitpunkt=3D13.11.00<BR>RMAN-08010: Kanal =
CHANNEL_SICHERUNGz:=20


Datendatei wird in Backup-Satz einbezogen<BR>RMAN-08522: =
Eingabe-Datendatei=20


fno=3D00003 Name=3DG:\ORACLEDATEN\USERS01.DBF<BR>RMAN-08522: =
Eingabe-Datendatei=20


fno=3D00007 Name=3DH:\ORACLEDATEN\INDX01.DBF<BR>RMAN-08522: =
Eingabe-Datendatei=20


fno=3D00002 Name=3DF:\ORACLEDATEN\RBS01.DBF<BR>RMAN-08522: =
Eingabe-Datendatei=20


fno=3D00005 Name=3DF:\ORACLEDATEN\TEMP01.DBF<BR>RMAN-08522: =
Eingabe-Datendatei=20


fno=3D00001 Name=3DE:\ORACLEDATEN\SYSTEM01.DBF<BR>RMAN-08011: Aktuelle =
Steuerdatei=20


wird in Backup-Gruppe einbezogen<BR>RMAN-08522: Eingabe-Datendatei =
fno=3D00009=20


Name=3DE:\ORACLEDATEN\DR01.DBF<BR>RMAN-08522: Eingabe-Datendatei =
fno=3D00006=20


Name=3DE:\ORACLEDATEN\SYSMAN01.DBF<BR>RMAN-08522: Eingabe-Datendatei =
fno=3D00004=20


Name=3DG:\ORACLEDATEN\USERSWM01.DBF<BR>RMAN-08522: Eingabe-Datendatei =
fno=3D00008=20


Name=3DH:\ORACLEDATEN\INDXWM01.DBF<BR>RMAN-08013: Kanal =
CHANNEL_SICHERUNGz: St=FCck=20


1 wurde erstellt<BR>RMAN-08503: =


St=FCck-Handle=3DZ:\SICHERUNGDB\B_DNCABHP9_439_1=20
Kommentar=3DNONE<BR>RMAN-08525: Backup-Satz abgeschlossen, verstrichene =
Zeit:=20


00:17:57<BR>RMAN-00571:=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>RMAN-00569:=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE STACK =


FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>RMAN-00571:=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>RMAN-00601: fatal=20


error in recovery manager<BR>RMAN-03004: fatal error during execution of =



command<BR>RMAN-10006: error running sql statement: select sofar, =
context from=20


v$session_longops where sid =3D (select distinct sid from v$mystat) and =
opname=20


like 'RMAN:%' order by start_time desc, context desc<BR>RMAN-10002: =
ORACLE=20



error: ORA-03113: Unerwartetes =DCbertragungsende in =
Kommunikation</FONT></DIV>


<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>for three days i've shutdown the =

database and the=20


backup works successfully and today i become above error =

again</FONT></DIV>


<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>



<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>any ideas&nbsp;i can't shutdown my =

database all=20


days</FONT></DIV>


<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

Received on Mon Nov 13 2000 - 03:55:46 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US