Forum Discussion

technimdaxviii's avatar
technimdaxviii
Level 5
8 years ago

Oracle Intelligent Policies (OIP)

If netbackup is using this policy to perform oracle database backup, what type of backup should I expect?  From the GUI of the netbackup(NetBackup Management > Policies > "DB Policy" > "Backup Selec...
  • Tousif's avatar
    Tousif
    8 years ago

    Hello,

     

    No problem,

    Kindly check the oracle rman configuration by using below command.

    Connect to rman prompt

    RMAN> show all

    If we select "CONTROLLFILE AUTOBACKUP ON" in rman configuration.

    It will take controlfile backup after save any changes in controlfile. It also take control file backup after successful backup from any third party vendor.

    I believe that, list backup output you shared earlier also belong to autobackup. Because in oracle catalog terminology use F = Full.

    Command / output reference attached. :)

     

    Regards,

     

Tousif's avatar
Tousif
Level 6

 

Hello,

The NBU Master server registers the instances available in environment automatic or we can do manually.

The WHOLE_DATABASE option backup complete database (database file, Archive Log and Control file) of that instance. The instance gets register with below information.

Instance Name: SID

HOST: Client Name

Oracle_HOME: home directory of oracle user for that instance.

Credential: The user authentication by NBU to connect and access the database.

We need to provide instance name, host name, home path  and credential (OS/Oracle) to register that instance. 

The instance should register successfully before configure the policy using OIP.

what type of backup should I expect? 

The OIP is nothing but run time template to take backup of database. So If we are using OIP it mean taking oracle database online backup using template.

 

Thanks & Regards,

technimdaxviii's avatar
technimdaxviii
Level 5
8 years ago

Hi Tousif,

 

Thank you for your response.

Yeah, I'm seeing we have the backup for these three database file, archive and control file. But checking my backup summary, I have two different database file backup, L0 (level0) and F (Full). Is it a duplicate?

  • Tousif's avatar
    Tousif
    Level 6
    8 years ago

    Hello,

    I have two different database file backup, L0 (level0) and F (Full). Is it a duplicate?

    The Level 0 and F both is full backup. If you configured the duplication or run manually then only it will show you the two copies under same backup id.

    Example command: /usr/openv/netbackup/bin/admincmd/bpimagelist –backupid <backupid> -L

    To check the backup images are full or incr, use the below command against client.

    Example command: /usr/openv/netbackup/bin/admincmd/bpimagelist –client <client_name> -U

     The default rman backup script snippet mentioned below for more information.

    # Schedule type is BACKUP_TYPE is
    # ---------------- --------------
    # Automatic Full INCREMENTAL LEVEL=0
    # Automatic Differential Incremental INCREMENTAL LEVEL=1
    # Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE

    If we select the ‘Full Backup’ schedule in backup policy configuration. It will consider as level=0 backup and execute the script parameter for full backup. The same way work for OIP (template) also.

    If we configured the incremental schedule in policy and run the backup then it will consider the backup level=1 backup and execute the script parameter for incremental backup. The same way work for OIP (template) also.

    Please refer the below article for more information about NBU for oracle terminology

    http://www.veritas.com/docs/000073330

    From your current question we are not able to understand about your expectation. There are different possible answers on your current query.

    If you not get your answer from above explanation then please share the command output your are getting for L0 and F.

     

    Thanks & Regards,

    Tousif Naik

    • technimdaxviii's avatar
      technimdaxviii
      Level 5
      8 years ago

      Hi Tousif,

      Thank you for the input.

      The Level 0 and F both is full backup. If you configured the duplication or run manually then only it will show you the two copies under same backup id.

       

      Yes its the same, but what should I expect (0 or F) if we're using OIP? Apologies for the confusion :)

      Please see screenshot above.

      • Michal_Mikulik1's avatar
        Michal_Mikulik1
        Moderator
        8 years ago

        Hello,

        I have reviewed my two instances with Oracle dbs backed up by OIPs. Actually, my RMAN "list backup summary" does not show any "0" values in "LV" column, just "F" and "A" values.

        I recommend you to map details of parent/child Oracle jobs in Activity Monitor from 20-JAN-2017 to information in RMAN list output, then you can get an answer for what is actually "hidden" behind "F" and "0" backups.

        Note - when NetBackup perform a duplication of backups, RMAN is not aware of this.

        Regards

        Michal

    • Michal_Mikulik1's avatar
      Michal_Mikulik1
      Moderator
      8 years ago

      Hello,

      not sure which "backup summary" you are referring to, but in Oracle terminology, Full backup is "Level 0" backup, and Incremental backup is "Level 1" backup.

      I recommend you to work closely with Oracle DBA when configuring Oracle policies.

      regards

      Michal

      • technimdaxviii's avatar
        technimdaxviii
        Level 5
        8 years ago

        Hi,

        Yeah, "Full" and "Level0" were the same. I 've just got confused why I have two level in our RMAN backup. For January 20, If you can see the "LV" column we have 0(Level0) and F(Full).