Re: [Veritas-bu] [ORACLE] Backing up the "Control File" ...

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