RMAN used?

From: Michael Kline <mkline1_at_comcast.net>
Date: Tue, 22 Jul 2003 11:26:21 -0400
Message-Id: <25988.338904@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0023_01C35044.136A5600 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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: mkline_at_b2bsol.com Web: www.b2bsol.com

------=_NextPart_000_0023_01C35044.136A5600 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 6.00.2800.1170" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">Can =
RMAN backup a=20
database and leave any traces?</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">I have =
a client=20
site that was maintained with no</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier =
New">documentation and=20
now evaluating for how bad things</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">may=20
be.</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">We =
found an export=20
taking place, but no evidence</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">of =
anything else.=20
The alert.log shows NOTHING </FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">as far =
as shutdown,=20
start up, though there was a</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">recover =
database=20
clear back in Feb by someone.</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">There =
is one other=20
database on the server, with</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">RMAN in =
it, but the=20
tables are not populated, so</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">I'd say =

"nope"...</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier =
New">V$backup has=20
nothing in it. V$backup_set has</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">nothing =
in=20
it...</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">I'm =
thinking the=20
export is all they have.</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier =
New">anything else I can=20
check?</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier =
New">Platform is Windows=20
2000, Oracle FAILSAFE.</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT face=3D"Courier New">Oracle =
version=20
9.0.1.4.0...</FONT></SPAN></DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=3D208252115-22072003><FONT=20
face=3D"Courier New">Thanks.</FONT></SPAN></DIV>
<DIV><FONT face=3D"Courier New"></FONT> </DIV>
<DIV><FONT face=3D"Courier New"></FONT> </DIV>
<DIV><FONT face=3D"Courier New">Michael Alan Kline, Sr.<BR></FONT><FONT=20
face=3D"Courier New" size=3D2>Principal Consultant<BR>Business to = Business=20
Solutions, LLC<BR>Phone: 804-744-1545  Cell: 804-314-6262<BR>ICQ: = 1009605,=20
975313<BR>Email: </FONT><A href=3D"mailto:mkline_at_b2bsol.com"><FONT=20

face=3D"Courier New" size=3D2>mkline_at_b2bsol.com</FONT></A><FONT =
face=3D"Courier New"=20
size=3D2> Web: </FONT><A href=3D"http://www.b2bsol.com/"><FONT =
face=3D"Courier New"=20
size=3D2>www.b2bsol.com</FONT></A><BR></DIV>

Received on Tue Jul 22 2003 - 10:26:21 CDT