RE: [Q] Rman backup with and witout catalog question?

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 17 Aug 2005 14:24:04 -0400
Message-ID: <008301c5a358$d8f854d0$6759000a@vttaxnet.tax.state.vt.us>

Did you do the backups twice, one with and one without the catalog? Did you try resyncing the catalog? We need more info.

Regards,
Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of dba1 mcc Sent: Tuesday, August 16, 2005 3:33 PM
To: oracle-l_at_freelists.org
Subject: [Q] Rman backup with and witout catalog question?

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

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

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 17 2005 - 13:26:33 CDT