[OAUGNetDBA]-Re: 10gR2 RMAN backup

["Simmons, Bradley J" <bsimmons@lanl.gov>]

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>