Forum Discussion

Born2rise's avatar
Born2rise
Level 4
8 years ago

Control file backup on windows machine usning RMAN in netbackup

Hi All,

I require information on control file backup of oracle DB which reside on windows through Netbackup.

If database exist on linux then we used to provide a policy for control file backup which is of type standard and have one user directed schedule....

Now i have doubts on oracle control file backup on windows machine using RMAN
What is the procedure for it ?.... Even DBA did not ask for control file policy.. they ask only for database and log backup policy which are of type oracle..

Please suggest on it..... How the backup should happen.... If no control file backup required on windows then how recovery happen ??
7.7
Windows Server 2008

4 Replies

Sort By
  • Tousif's avatar
    Tousif
    Level 6
    8 years ago

    Hello,

     

    In NBU using Oracle policy type take backup of control file. Following is sequence of oracle backup.

    1. Database files

    2. Archive Files

    3. Control file

    The below mentioned command will list the example output of database backup.

    #/usr/openv/netbackup/bin/bplist -C (source client name) -t 4 -R -l /

    output

    -rw-rw---- oracle asmadmin 18874368 Oct 16 22:46 /cntrl_511_1_893285208 (ControlFile)
    -rw-rw---- oracle asmadmin 862191616 Oct 16 22:45 /al_509_1_893285131 (Archive Log)
    -rw-rw---- oracle asmadmin 262144 Oct 16 22:44 /bk_579_1_893285067 (Database File)

    Restore:

    If you want database recovery. You need to first restore the control file from that date backup.

    The control file content the information of Database file and archive log sequence of that date backup.

    Once you restore the control file and load the restored control file in Oracle. it become easy for admin to recover the database.

     

    Regards,

     

    • Born2rise's avatar
      Born2rise
      Level 4
      8 years ago
      Thanks tausif for reply

      But i am looking for netbackup policy configuration which i should have to give to DBA for backing up control file of database which is hosted on windows machine. Database admin even did not ask me for control file policy in case of windows. They want only db and log backup policy.

      Like i said, i used to give policy of type standard if database hosted on linux machine.
      • Marianne's avatar
        Marianne
        Level 6
        8 years ago
        If your environment does not have an RMAN catalog and rely only on control file, then it is vitally important to include control file in EACH backup and no need for separate backup.

        If DBAs really want separate control file backup, then they can simply create a script and send you the path to the script along with frequency and retention requirements.