Does the Rman Catalog hold tape volume names?

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Feb 2009 15:02:09 -0500

All,

 

I'm sure I saw this answer on the list before but just can't remember
it.

 

Does the Rman catalog store the tape volume name that it is writing a
backup to?

 

Oracle 10.2 and Tivoli Storage Manager.


I am trying to restore from a prior backup.  The Rman catalog has the
backup cataloged.  But the Rman run fails and says:

 

RMAN-06023: no backup or copy of datafile 22 found to restore

RMAN-06023: no backup or copy of datafile 2 found to restore

RMAN-06023: no backup or copy of datafile 1 found to restore

 

I was able to restore from 2 days sooner (1/29 worked; 1/27 does not).
I'm thinking that the tape may be offline or off site.


Does this make sense?


Thanks

Tom

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Joel.Patterson@xxxxxxxxxxx
Sent: Tuesday, February 10, 2009 2:49 PM
To: niall.litchfield@xxxxxxxxx
Cc: JSweetser@xxxxxxxx; oracledba.williams@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: SQL*Plus Question

 

Well, I hope I can do everything I now can via SQL Developer.

 

Sqlplusw.exe is what I am referring two, and I seem to have gotten used
to it.   Like a linesize of 2000.   Having scripts call scripts and
spool and do os commands etc.

 

Joel Patterson 
Database Administrator 
904 727-2546 

________________________________

From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx] 
Sent: Monday, February 09, 2009 4:13 PM
To: Patterson, Joel
Cc: JSweetser@xxxxxxxx; oracledba.williams@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: SQL*Plus Question

 

On Mon, Feb 9, 2009 at 8:47 PM, <Joel.Patterson@xxxxxxxxxxx> wrote:

Well, I'm sad to hear no SQL*Plus in 11g, (so you probably should get
better with dbms_metadata).

 

 

C:\Documents and Settings\nlitchfield>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Feb 9 21:11:14 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL>

 

I suspect you may possibly mean no sqlplusw.exe, but that isn't a great
loss. 



-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: