Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN question -- with BMCs SQL-Backtrack

RMAN question -- with BMCs SQL-Backtrack

From: EdStevens <quetico_man_at_yahoo.com>
Date: 3 Apr 2006 12:47:14 -0700
Message-ID: <1144093634.524165.297780@i39g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US