This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C35072.A10C95DA
Content-Type: text/plain;
charset="iso-8859-1"
Mike,
One other external source to look into is the udump directory. See if an
sbtio.log file exists. Sometimes, Rman will write logs into this file. If
the file doesn't exist, then it is another hint that rman has not been used.
I would say that if you can't find any Rman save sets anyplace, then it has
not been run. That would be the final clue for me, anyway. The rest
doesn't matter.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Michael Kline [mailto:mkline1_at_comcast.net]
Sent: Tuesday, July 22, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RMAN used?
Can RMAN backup a database and leave any traces?
I have a client site that was maintained with no
documentation and now evaluating for how bad things
may be.
We found an export taking place, but no evidence
of anything else. The alert.log shows NOTHING
as far as shutdown, start up, though there was a
recover database clear back in Feb by someone.
There is one other database on the server, with
RMAN in it, but the tables are not populated, so
I'd say "nope"...
V$backup has nothing in it. V$backup_set has
nothing in it...
I'm thinking the export is all they have.
anything else I can check?
Platform is Windows 2000, Oracle FAILSAFE.
Oracle version 9.0.1.4.0...
Thanks.
Michael Alan Kline, Sr.
Principal Consultant
Business to Business Solutions, LLC
Phone: 804-744-1545 Cell: 804-314-6262
ICQ: 1009605, 975313
Email: <mailto:mkline_at_b2bsol.com> mkline_at_b2bsol.com Web:
<http://www.b2bsol.com/> www.b2bsol.com
------_=_NextPart_001_01C35072.A10C95DA
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4912.300" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=292564916-22072003><FONT face=Arial color=#0000ff
size=2>Mike,</FONT></SPAN></DIV>
<DIV><SPAN class=292564916-22072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=292564916-22072003><FONT face=Arial color=#0000ff size=2>One
other external source to look into is the udump directory. See if an
sbtio.log file exists. Sometimes, Rman will write logs into this
file. If the file doesn't exist, then it is another hint that rman has not
been used.</FONT></SPAN></DIV>
<DIV><SPAN class=292564916-22072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=292564916-22072003><FONT face=Arial color=#0000ff size=2>I
would say that if you can't find any Rman save sets anyplace, then it has not
been run. That would be the final clue for me, anyway. The rest
doesn't matter.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT face=Arial size=2>Tom Mercadante</FONT> <BR><FONT face=Arial
size=2>Oracle Certified Professional</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Michael Kline
[mailto:mkline1_at_comcast.net]<BR><B>Sent:</B> Tuesday, July 22, 2003 12:24
PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RMAN
used?<BR><BR></FONT></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">Can RMAN backup a
database and leave any traces?</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">I have a client
site that was maintained with no</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">documentation and
now evaluating for how bad things</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">may
be.</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">We found an
export taking place, but no evidence</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">of anything else.
The alert.log shows NOTHING </FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">as far as
shutdown, start up, though there was a</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">recover database
clear back in Feb by someone.</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">There is one
other database on the server, with</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">RMAN in it, but
the tables are not populated, so</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">I'd say
"nope"...</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">V$backup has
nothing in it. V$backup_set has</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">nothing in
it...</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">I'm thinking the
export is all they have.</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">anything else I
can check?</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">Platform is
Windows 2000, Oracle FAILSAFE.</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT face="Courier New">Oracle version
9.0.1.4.0...</FONT></SPAN></DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=208252115-22072003><FONT
face="Courier New">Thanks.</FONT></SPAN></DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New">Michael Alan Kline, Sr.<BR></FONT><FONT
face="Courier New" size=2>Principal Consultant<BR>Business to Business
Solutions, LLC<BR>Phone: 804-744-1545 Cell: 804-314-6262<BR>ICQ:
1009605, 975313<BR>Email: </FONT><A href="mailto:mkline_at_b2bsol.com"><FONT
face="Courier New" size=2>mkline_at_b2bsol.com</FONT></A><FONT face="Courier New"
size=2> Web: </FONT><A href="http://www.b2bsol.com/"><FONT face="Courier New"
size=2>www.b2bsol.com</FONT></A><BR></DIV>
Received on Tue Jul 22 2003 - 11:59:36 CDT