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. Oracle version 9.0.1.4.0... Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
