Forum Discussion

Anish's avatar
Anish
Level 4
14 years ago

ORACLE RMAN BACKUP Configuration

Hi I am trying to configure RMAN backup. Followed below mentioned steps: 1. Created Backup policy on master server for RMAN backup--- Shell script path is mentioned in Backup selection.  And...
7.1.x and Earlier
Agent for Oracle on Windows or Linux Servers
Backing Up
Backup and Recovery
Configuring
NetBackup
Oracle
Solaris
Tip-How to
  • AAlmroth's avatar
    AAlmroth
    14 years ago

    1) Default-Application-Backup is the name of the Application backup schedule type. Oracle is an application as it qualifies for all properties of an process running in an OS. The specific application domain happens to be database...

     

    2) In versions prior to 11iR2, you used XML exports to make long-term at rest backup copies which were not tied to a specific version of Oracle and did not impact on the archive redo log file management. If you make an online backup and specify to store it for 5 years, you would also need 5 years of archive redo logs (Oracle design). This can be circumvented to some extent by changing the active incarnation, but that is not really recommended.

    With Oracle 11iR2, we can do long-term at rest online backups where the relevant archive redo log files are stored together with the backup, but is not included in the normal redo log management as such. A very nice new feature! Have missed this feature ever since RMAN was made part of the database management back in 8.1 days.

     

    3) Oracle RAC backups does require some design considerations, but generally you can use the normal SID if you don't care which node will do the backup. If you have a "backup node" in the RAC, you would instead want to use the sub-SID, and control which node to be used. There is plenty of documentation on this topic, both from Oracle and Symantec. I've done a lot of heavy scripting to control the instance backups, but the downside is you loose visibility in NBU when using to many scripts...

     

    /A

     

AAlmroth's avatar
AAlmroth
Level 6
14 years ago

1) Default-Application-Backup is the name of the Application backup schedule type. Oracle is an application as it qualifies for all properties of an process running in an OS. The specific application domain happens to be database...

 

2) In versions prior to 11iR2, you used XML exports to make long-term at rest backup copies which were not tied to a specific version of Oracle and did not impact on the archive redo log file management. If you make an online backup and specify to store it for 5 years, you would also need 5 years of archive redo logs (Oracle design). This can be circumvented to some extent by changing the active incarnation, but that is not really recommended.

With Oracle 11iR2, we can do long-term at rest online backups where the relevant archive redo log files are stored together with the backup, but is not included in the normal redo log management as such. A very nice new feature! Have missed this feature ever since RMAN was made part of the database management back in 8.1 days.

 

3) Oracle RAC backups does require some design considerations, but generally you can use the normal SID if you don't care which node will do the backup. If you have a "backup node" in the RAC, you would instead want to use the sub-SID, and control which node to be used. There is plenty of documentation on this topic, both from Oracle and Symantec. I've done a lot of heavy scripting to control the instance backups, but the downside is you loose visibility in NBU when using to many scripts...

 

/A