RE: RMAN used?

[Mercadante, Thomas F]

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:[EMAIL PROTECTED]
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: [EMAIL PROTECTED] Web: www.b2bsol.com