Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RMAN question -- with BMCs SQL-Backtrack
Oracle 9.2.0.1.0 on Solaris 5.9
>From day one we have been using BMC's SQL_Backtrack product to manage
our database backups. We've never used rman, but today I started
playing around with it, and got quite a shock. Connected to a target
db and issued a couple of list commnds, expecting to see nothing.
After, we've never taken a backup with rman, so how would have any
knowledge of any backups? However, this is what I got:
RMAN> list backup;
RMAN> list copy;
List of Controlfile Copies
Key S Completion Time Ckp SCN Ckp Time Name
------- - --------------- ---------- --------------- ----
451 A 03-APR-06 486635943 02-APR-06
/u01/vendors/dtools/obacktrack-5.0.00-64-o8lib/tmp/dtodump_controlfile9988.ctl
450 A 02-APR-06 485653352 01-APR-06
/u01/vendors/dtools/obacktrack-5.0.00-64-o8lib/tmp/dtodump_controlfile1223.ctl
<snip>
242 A 05-SEP-05 228582567 04-SEP-05 /u01/vendors/dtools/obacktrack-5.0.00-64-o8lib/tmp/dtodump_controlfile28719.ctl
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
5398 1 5402 A 21-FEB-06
/u08/oradata/VITXP01/archive/1_5402.dbf
<snip>
6026 1 6030 A 03-APR-06
/u08/oradata/VITXP01/archive/1_6030.dbf
RMAN> exit
Recovery Manager complete.
Note especially the list of control file copies .... and their locations!
Looks like BMC is using rman under the covers. Or is there something else going on that I never would have guessed? Received on Mon Apr 03 2006 - 14:47:14 CDT