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

Home -> Community -> Mailing Lists -> Oracle-L -> [Q] Rman backup with and witout catalog question?

[Q] Rman backup with and witout catalog question?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Tue, 16 Aug 2005 12:32:37 -0700 (PDT)
Message-ID: <20050816193237.17010.qmail@web60819.mail.yahoo.com>


I am doing RMAN backup testing under ORACLE 9ir2
(9.2.0.6). I found Rman backup set number are
different, when I connect use catalog.

%rman target / catalog rman/rman

Recovery Manager: Release 9.2.0.6.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: CUPFLNX
(DBID=4026107299)

connected to recovery catalog database

RMAN> list backup summary;

List of Backups



Key TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---
139     B  F  A DISK        15-AUG-05       1       1 
     TAG20050815T063001
141     B  A  A DISK        15-AUG-05       1       1 
     TAG20050815T064519
143     B  F  A DISK        16-AUG-05       1       1 
     TAG20050816T063001
145     B  A  A DISK        16-AUG-05       1       1 
     TAG20050816T065522
199     B  F  A DISK        16-AUG-05       1       1 
     TAG20050816T145807
212     B  F  A DISK        16-AUG-05       1       1 
     
219     B  A  A DISK        16-AUG-05       1       1 
     TAG20050816T150632
262     B  F  A DISK        16-AUG-05       1       1 
     

RMAN> exit

%rman target /

Recovery Manager: Release 9.2.0.6.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: CUPFLNX
(DBID=4026107299)
RMAN> list backup summary;

using target database controlfile instead of recovery catalog

List of Backups



Key TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---
144     B  F  A DISK        15-AUG-05       1       1 
     TAG20050815T063001
146     B  A  A DISK        15-AUG-05       1       1 
     TAG20050815T064519
148     B  F  A DISK        16-AUG-05       1       1 
     TAG20050816T063001
150     B  A  A DISK        16-AUG-05       1       1 
     TAG20050816T065522
153     B  F  A DISK        16-AUG-05       1       1 
     TAG20050816T145807
154     B  F  A DISK        16-AUG-05       1       1 
     
155     B  A  A DISK        16-AUG-05       1       1 
     TAG20050816T150632
156     B  F  A DISK        16-AUG-05       1       1 
     

RMAN> exit

anyone know why backupset number different???



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 16 2005 - 14:34:41 CDT

Original text of this message

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