Home » RDBMS Server » Backup & Recovery » Backup Strategy (Oracle 10g)
Backup Strategy [message #308936] Wed, 26 March 2008 00:42 Go to next message
someswar1
Messages: 53
Registered: January 2008
Member
Hi.

I am looking for some help.
We have a requirement to backup a 24x7 datbase, it is currently around 400 GB and growing rapidly.

Running Oracle 10.2.0.1.0
O/S Windows Xp Servicepack2

What Would the following strategy be successful for Backup And recovery? please give the details.

Regards
Someswar Bhattacharjee


Re: Backup Strategy [message #308964 is a reply to message #308936] Wed, 26 March 2008 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics
Database Backup and Recovery Quick Start Guide

Regards
Michel
Re: Backup Strategy [message #309328 is a reply to message #308936] Thu, 27 March 2008 02:17 Go to previous messageGo to next message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member
There are two high availability backup methods suggested.

Suggested Method 1: (RMAN tool for physical backup )
Recovery Manager (RMAN)

Oracle Recovery Manager (RMAN) is a tool integrated into the Oracle Database that satisfies the pressing demands of high-performance, manageable backup and recovery.

Advantage

1. RMAN backup performed while the database is on-line and available for read/write and database must be in archive log mode.

2. RMAN enables point in time recovery easy and less manual intervention

3. RMAN computes checksums for blocks during backups and restores, so block corruptions are found quickly.

4. RMAN allows block recovery, which could be faster and less disruptive than recovering an entire data file.

5. RMAN does not back up blocks that have never contained data, possibly making your backups smaller.

6. RMAN allows the testing of backups via virtual restores.

7. RMAN provides for easy parallelism, possibly reducing the overall backup time.



Suggested Method 2: (Data Pump alone)

Data Pump

Oracle Data Pump is a new feature of Oracle Database 10g that provides high speed, parallel, bulk data and metadata movement of Oracle database contents. It’s a server-side replacement for the original Export and Import utilities.

Advantage

1. Data Pump export is 2 times faster than original Export.

2. Data Pump Import is 10-45 times faster than original Import.

3. Data Pump computes checksums for blocks during backups, so block corruptions are found quickly.

With Regards
Raja Baskar
Re: Backup Strategy [message #309334 is a reply to message #309328] Thu, 27 March 2008 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Datapump is NOT a backup method.

Regards
Michel
Re: Backup Strategy [message #309338 is a reply to message #308936] Thu, 27 March 2008 02:46 Go to previous messageGo to next message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member
WHICH BACKUP METHOD SHOULD BE USED?

Oracle provides users a choice of several basic methods for making backups. The methods include:

Recovery Manager (RMAN) - A component that establishes a connection with a server process and automates the movement of data for backup and recovery operations.
Oracle Enterprise Manager - A GUI interface that invokes Recovery Manager.
Oracle Data Pump - The utility makes logical backups by writing data from an Oracle database to operating system files in a proprietary format. This data can later be imported into a database.
User Managed - The database is backed up manually by executing commands specific to the user's operating system.


http://www.oracle.com/technology/deploy/availability/htdocs/BR_Overview.htm

Re: Backup Strategy [message #309348 is a reply to message #309338] Thu, 27 March 2008 03:12 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is a logical "backup" that is it not a real backup.
Try to recover a file lost with datapump.

Regards
Michel

[Updated on: Thu, 27 March 2008 03:13]

Report message to a moderator

Previous Topic: Clone using RMAN
Next Topic: clone database from previous incarnation/dbid
Goto Forum:
  


Current Time: Sat Dec 10 05:00:34 CST 2016

Total time taken to generate the page: 0.20476 seconds