[OAUGNetDBA]-Re: 10gR2 RMAN backup

["Quiles, Robert" <rquiles@incresearch.com>]

Gerry,
Are you saying that you want the duplicate action to use an older
backup?  How much older?  Usually that is fine as long as the metadata
for the older backup exists in the target controlfile.  You can set
UNTIL TIME to perform the duplicate action using an older backup.  See
my example below.

run {
set until time "to_date('31-JUL-2008 00:48:44','DD-MON-YYYY
HH24:MI:SS')";
allocate auxiliary channel c1 device type disk;
duplicate target database to dupdb;
}

Now, if the metadata for the older backup is gone from the controlfile I
think you would have to catalog that backup set first.  

There might be easier ways to do this but it is a scenario I haven't
encountered.  

My apologies if this is not what you meant.

--
Rob Quiles
Sr. Database Administrator
INC Research
4700 Falls of Neuse Rd, Suite 100
Raleigh, NC 27609
Office 919-334-3526
Mobile 919-418-0690
http://www.incresearch.com
 
> -----Original Message-----
> From: OAUG Net DBA listserver [mailto:OAUGNetDBA@oaug.com] On Behalf
Of
> Gerry McGreevy
> Sent: Thursday, August 07, 2008 4:34 PM
> To: OAUG Net DBA listserver
> Subject: [OAUGNetDBA]-Re: 10gR2 RMAN backup
> 
> To change things up slightly, what if:
> 
>    No recovery catalog is being used.
> 
>    Target action:  DUPLICATE DATABASE using backups consisting:
> datafile copy, archivelogs as needed, and controlfile).
> 
>    Apparently RMAN connects to the source instance, and reads from the
> controlfile, and sees backups that are  more current, and tries to use
> those, but the backup being restored from is older than than the
> metadata stored in the source controlfile?
> 
> So a restore (using the correct path the the backup files as they were
> taken) gets errors like:
>       destination for restore of datafile 00044: <path>/<filename>.dbf
>       ORA-19505: failed to identify file
>       ORA-27037: unable to obtain file status
>       SVR4 Error: 2: No such file or directory
>       ORA-19600: input file is datafile-copy 0 (/u02/ . . .
/<datafile>)
> 
> It has been determined that it is looking for the most recent backup
> pieces, and not what should be listed in the restored controlfile.
> 
> How to resync this information?
> 
> Thanks,
> Gerry
> 
> 
> 
> On Wed, Aug 6, 2008 at 7:26 AM, Quiles, Robert
<rquiles@incresearch.com>
> wrote:
> >
> > You can use the CATALOG command in RMAN to add those pieces to the
> > recovery catalog.  The main caveat being that the backup pieces must
be
> > on disk.  If you are using FRA you can (re)catalog the contents and
then
> > you will have all of the data in the repository.  There are many
backup
> > related V$ views that contain the information needed for recovery
one of
> > which is V$BACKUP_PIECE.
> >
> > The backup info needed for recovery is in the control file as well
as
> > the catalog.  You can easily recover from media failures without an
RMAN
> > recovery catalog as long as the backup occurred within the time
> > specified by the init parameter CONTROL_FILE_RECORD_KEEP_TIME.
> >
> > Check the CATALOG command in the 10g Backup and Recovery Reference
> > manual.
> >
> > --
> > Rob Quiles
> > Sr. Database Administrator
> > INC Research
> > 4700 Falls of Neuse Rd, Suite 100
> > Raleigh, NC 27609
> > Office 919-334-3526
> > Mobile 919-418-0690
> > http://www.incresearch.com
> >
> > > -----Original Message-----
> > > From: OAUG Net DBA listserver [mailto:OAUGNetDBA@oaug.com] On
Behalf
> > Of
> > > prashanth k
> > > Sent: Wednesday, August 06, 2008 5:28 AM
> > > To: OAUG Net DBA listserver
> > > Subject: [OAUGNetDBA]-10gR2 RMAN backup
> > >
> > > Hi
> > >
> > > I have few questions regarding rman backup in 10gR2.
> > >
> > > While taking rman backups the recovery catalog database was down
> > > so rman wrote the catalog information to the database controlfile
> > > and completed the backups.
> > >
> > > In such scenario, we cannot query the recovery catalog database
> > > to get the full backup information because part of the information
> > > is in the source database control file. How do we then find the
> > > backups information like say, names of the backup pieces and
> > > archives needed for recovery etc?
> > >
> > > Is there a way to move the backup information present in the
control
> > > file to the recovery catalog when the recovery catalog database is
> > > available later on? How do we do it?
> > >
> > > Thank you.
> > >
> > > #############################################################
> > > This message is sent to you because you are subscribed to the
mailing
> > list
> > > <OAUGNetDBA@oaug.com>.
> > > To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
> > > To switch to the FEED mode, send any message to
> > <OAUGNetDBA-feed@oaug.com>
> > > To switch to the DIGEST mode, E-mail to
<OAUGNetDBA-digest@oaug.com>
> > > To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
> > > Send administrative queries to  <OAUGNetDBA-request@oaug.com>
> >
> > ** INC Research is a registered trademark of INC Research, Inc.
> Notice: This transmission is intended only for the use of the
individual
> or entity to which it is addressed and may contain information that is
> privileged, confidential and exempt from disclosure. If the reader of
this
> message is not the intended recipient, or an employee or agent
responsible
> for delivering the message to the intended recipient, you are hereby
> notified that any disclosure, dissemination, distribution or copying
of
> the communication is strictly prohibited. If you have received this
> communication or any associated attachments in error, please notify
the
> sender immediately.  Thank you in advance.
> >
> > #############################################################
> > This message is sent to you because you are subscribed to the
mailing
> list <OAUGNetDBA@oaug.com>.
> > To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
> > To switch to the FEED mode, send any message to <OAUGNetDBA-
> feed@oaug.com>
> > To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
> > To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
> > Send administrative queries to  <OAUGNetDBA-request@oaug.com>
> >
> 
> #############################################################
> This message is sent to you because you are subscribed to the mailing
list
> <OAUGNetDBA@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
> To switch to the FEED mode, send any message to
<OAUGNetDBA-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
> Send administrative queries to  <OAUGNetDBA-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>