RE: RMAN used?

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Tue, 22 Jul 2003 12:14:10 -0500
Message-Id: <25988.338922@fatcity.com>

RMAN writes to the control file(s) when it runs. Try this:

SQL> select view_name from dba_views where view_name like '%BACK%';

VIEW_NAME

---

DBA_ROLLBACK_SEGS

GV_$BACKUP
GV_$BACKUP_ASYNC_IO
GV_$BACKUP_CORRUPTION
GV_$BACKUP_DATAFILE
GV_$BACKUP_DEVICE
GV_$BACKUP_PIECE
GV_$BACKUP_REDOLOG
GV_$BACKUP_SET
GV_$BACKUP_SYNC_IO
V_$BACKUP
V_$BACKUP_ASYNC_IO
V_$BACKUP_CORRUPTION
V_$BACKUP_DATAFILE
V_$BACKUP_DEVICE
V_$BACKUP_PIECE
V_$BACKUP_REDOLOG

V_$BACKUP_SET
V_$BACKUP_SYNC_IO Try looking at V$BACKUP_PIECE.

-----Original Message-----

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. Received on Tue Jul 22 2003 - 12:14:10 CDT