| Backup Strategy [message #308936] |
Wed, 26 March 2008 00:42  |
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 #309328 is a reply to message #308936] |
Thu, 27 March 2008 02:17  |
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 #309338 is a reply to message #308936] |
Thu, 27 March 2008 02:46 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
