[OAUGNetDBA]-Re: 10gR2 RMAN backup

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

Well, that would be easier wouldn't it? ;-)

--
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
> Simmons, Bradley J
> Sent: Wednesday, August 06, 2008 9:16 AM
> To: OAUG Net DBA listserver
> Subject: [OAUGNetDBA]-Re: 10gR2 RMAN backup
> 
> Once you can connect to your catalog,
> Rman> resync catalog
> 
> ...updates the catalog with the contents of your controlfile.
> 
> -----Original Message-----
> From: OAUG Net DBA listserver [mailto:OAUGNetDBA@oaug.com] On Behalf
Of
> Quiles, Robert
> Sent: Wednesday, August 06, 2008 6:26 AM
> To: OAUG Net DBA listserver
> Subject: [OAUGNetDBA]-Re: 10gR2 RMAN backup
> 
> 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>