Re: [Veritas-bu] [ORACLE] Backing up the "Control File" ...
2007-06-25 08:17:31
You can't determine or verify the status of RMAN backups via NBU. You'll need to either query RMAN directly or write something that parses your RMAN logs.
===================================
Steven L. Sesar
Lead Operating Systems Programmer/Analyst
UNIX Application Services R101
The MITRE Corporation
202 Burlington Road - MS K101
Bedford, MA 01730
tel: (781) 271-7702
fax: (781) 271-2600
mobile: (617) 519-8933
email: ssesar AT mitre DOT org
===================================
-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu on behalf of Wilkinson, Alex
Sent: Sun 6/24/2007 10:38 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] [ORACLE] Backing up the "Control File" ...
Anyone ?
Surely people are backing up their control files for Oracle ?
If so ... can you tell me how you are confirming this via NB ?
-aW
0n Fri, Jun 22, 2007 at 04:35:04PM +0800, Wilkinson, Alex wrote:
>Hi all,
>
>Our RMAN template contains the following run block:
>
> ALLOCATE CHANNEL ch00
> TYPE 'SBT_TAPE';
> SEND
> 'NB_ORA_CLIENT=hostname.dsto.defence.gov.au,NB_ORA_POLICY=EDN-hostname-ORA,NB_ORA_SERV=hostname.dsto.defence.gov.au,NB_ORA_SCHED=Default-Application-Backup';
> BACKUP
> FORMAT 'ctlfile_%d_u%u_s%s_p%p_t%t'
> CURRENT CONTROLFILE;
> RELEASE CHANNEL ch00;
> }
>
>The only modification to this template has been the FORMAT strings.
>
>The problem:
>
>We never see any evidence of the control file being backed via the output of the
>FORMAT string 'ctlfile_%d_u%u_s%s_p%p_t%t' in NetBackup's activity monitor.
>
>The Questions:
>
>1. From all my reading the Oracle policy type includes the control file.
> Can someone please confirm this ?
>
>2. Why would we never see a string output of 'ctlfile_%d_u%u_s%s_p%p_t%t' even
> though it has been defined within the RMAN template ?
>
>3. How can I confirm whether or not NetBackup is actually backing up the control file ?
>
>
> -aW
>
>IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the CRIMES ACT 1914. If you have received this email in error, you are requested to contact the sender and delete the email.
>
>
>_______________________________________________
>Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|