Home » RDBMS Server » Backup & Recovery » Best Method for backup of PROD environment (Oracle Database 10.1.0.5 or Oracle Database 10.2.0.2)
Best Method for backup of PROD environment [message #284159] Thu, 29 November 2007 01:15 Go to next message
fadi.abadir
Messages: 4
Registered: November 2007
Location: Egypt
Junior Member
Hello everyone,

I wanted to know what is the best approach for backing up a PROD environment.

I have one of 2 alternatives (which I still don't know any details of how to do them):

1) Using RMAN
2) Hot Backup using SQL scripts and making tablespaces in backup mode

I wanted to know how to do those types of backup, and what is the best way to do the backup.

We need to do the backup on Tape device. Database size is around 110 GB, this is an Oracle Applications 11.5.10.2 Database release 10.1.0.5.

Best regards,
Fadi Abadir
Re: Best Method for backup of PROD environment [message #284163 is a reply to message #284159] Thu, 29 November 2007 01:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

1) + Data Pump.
Re: Best Method for backup of PROD environment [message #284167 is a reply to message #284159] Thu, 29 November 2007 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The best way is RMAN.
It is then easier to manage RECOVERY.

Regards
Michel
Re: Best Method for backup of PROD environment [message #284175 is a reply to message #284167] Thu, 29 November 2007 01:39 Go to previous messageGo to next message
fadi.abadir
Messages: 4
Registered: November 2007
Location: Egypt
Junior Member
Thanks for your replies...

But Is there any good fast-to-read & fast-to-do documentation in order to do this RMAN backup (and using the datapump [which I never heard of])?

Thanks
Re: Best Method for backup of PROD environment [message #284192 is a reply to message #284175] Thu, 29 November 2007 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=3

Backup and Recovery Advanced User's Guide
Backup and Recovery Basics
Backup and Recovery Quick Start Guide
Backup and Recovery Reference

DataPump is the new way to export/import, see "Utilities" in the same link.

Regards
Michel
Re: Best Method for backup of PROD environment [message #284246 is a reply to message #284192] Thu, 29 November 2007 04:01 Go to previous messageGo to next message
fadi.abadir
Messages: 4
Registered: November 2007
Location: Egypt
Junior Member
Thanks a lot... this was of great help..

I just wanted to add one point, I am unable to find the documentation for the 10gR1 database. Looks like they removed it.

Does the same apply as in the 10gR2 document to the 10gR1?

Thanks again...appreciate your help
Re: Best Method for backup of PROD environment [message #284248 is a reply to message #284246] Thu, 29 November 2007 04:05 Go to previous message
fadi.abadir
Messages: 4
Registered: November 2007
Location: Egypt
Junior Member
Sorry for bothering you... I found the link.. thanks Very Happy
Previous Topic: RMAN
Next Topic: RMAN Incremental question
Goto Forum:
  


Current Time: Sat Dec 03 20:16:43 CST 2016

Total time taken to generate the page: 0.04282 seconds