How to Effectively Backup, Protect, Restore and Clone Oracle Databases Using SnapCenter 1.1
2016-04-27 07:31 AM
NetApp® SnapCenter is a centralized product suite that provides a single pane of glass management for a variety of applications, databases and hypervisors. Through SnapCenter, you can centrally deploy plug-ins to remote hosts, schedule and monitor backups, Clone, Restore and perform Backup verification operations. SnapCenter uses centralized role-based access control (RBAC) and offers reports and centralized dashboard across all plug-ins. The Plug-in for Oracle is a host-side component of the NetApp integrated storage solution offering application-aware backup management, restore, recovery, and Cloning of Oracle Database.
Let’s learn how to perform Data protection and management for Oracle databases using SnapCenter software.
Step1: Assuming that the SnapCenter software is already installed and following pre-requisites are performed by your Storage/Server administrators. This is a One-Time activity.
- Register NetApp storage SVM’s
- Register RUNAS credentials for all the Hosts to avoid the repeated use of credentials during workflows
- Register your Linux Hosts to the SnapCenter server which auto installs Oracle plugins to these hosts and their clustered hosts (if any).
- Auto-discover the Oracle databases in Inventory page.
Detailed steps for installation and configuration is mentioned below
Step2: Create Backup Policies and Datasets for your Oracle databases [One-Time activity]
Login as Oracle Admin or SnapCenter admin user on the SnapCenter GUI:-
- Open Policies tab and click Add
- Provide policy name and select the scope of Backup
- Choose Archivelog management or pruning [ if required]
- Provide your Backup retention based on days or number
- Choose secondary replication option such SnapVault /Mirror to archive your backups to a secondary destination for a longer retention
- Provide any schedules [ If required ]
- Click Finish and confirm the policies are created .
- Open Datasets tab and click new backup dataset
- Provide Dataset name and associate this dataset to a list of policies created earlier.
- Select a given database that needs to be backed up. You can also group multiple databases in a single dataset and Click finish
Step 3: Take an Online/ Offline Backup of your Oracle database
- Select a given Dataset and click Backup Now
- Choose a given policy and click OK. The Backup takes few seconds to minutes to complete.
- Track the job id in Monitor screen. You can track the progress of each Backup at the granular level
- You can also view the logs or download them from Monitor page
- If you have secondary replication enabled in the Backup policy , the Backup snapshots will get updated automatically to the secondary storage.
- Choose a given and click Backup
- Create your own dataset and click Ok. Check Monitor screen to track the progress of the backup.
Step 4: Create a clone of your Oracle database using a given Snapshot Oracle Backup
- Open Inventory page , choose a given database and click clone backup
- On the Clone wizard , Enter the Target SID name and choose a given backup from either primary or secondary replicated storage
- Choose the host and the location where the cloned database to be staged
- Provide Oracle Home settings
- Choose recovery scope for the clone [ SCN , DATE AND TIME , No recovery]
- Click finish and track the Job progress in Monitor screen.
Step 5: Perform a Restore/Recovery Operation for a given Pluggable database on a given Container database
- Open Inventory page , choose a given database and click Restore
- On the Restore wizard, choose a preferred backup for your restore operation.
- Select the scope of restore [ datafiles , PDB tablespaces ,PDB ,Controlfiles ]
- Select the Recovery scope as either All Logs or Date and Time or No recovery.
- Enable the checkbox for database open option after recovery and click finish.
- Track the progress in the Monitor screen
Step 6: Dashboard and Reports
- To check the overall Dashboard of all the Jobs , Open Dashboard page and review the success , failure and warning counts for each jobs [ Backups ,restore, clone and secondary replication]
- Check for Clone savings after each clone in GB /TB
- Open reports page, use the filters for selecting the database, date and time and generate detailed reports for Backup, Clone and restore.
- Data Protection Guide for Oracle Databases Review the PDF to see command line syntaxes for the above jobs which would be more simple and comfortable to perform any automation task.
This NetApp Community is public and open website that is indexed by search engines such as Google. Participation in the NetApp Community is voluntary. All content posted on the NetApp Community is publicly viewable and available. This includes the rich text editor which is not encrypted for https.
- Software files (compressed or uncompressed)
- Files that require an End User License Agreement (EULA)
- Confidential information
- Personal data you do not want publicly available
- Another’s personally identifiable information
- Copyrighted materials without the permission of the copyright owner