OraFAQ Forum: Backup & Recovery » Best Method for backup of PROD environment

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Best Method for backup of PROD environment [message #284159]

Thu, 29 November 2007 01:15

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

Report message to a moderator

Re: Best Method for backup of PROD environment [message #284163 is a reply to message #284159]

Thu, 29 November 2007 01:17

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

1) + Data Pump.

Report message to a moderator

Re: Best Method for backup of PROD environment [message #284167 is a reply to message #284159]

Thu, 29 November 2007 01:33

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The best way is RMAN.
It is then easier to manage RECOVERY.

Regards
Michel

Report message to a moderator

Re: Best Method for backup of PROD environment [message #284175 is a reply to message #284167]

Thu, 29 November 2007 01:39

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

Report message to a moderator

Re: Best Method for backup of PROD environment [message #284192 is a reply to message #284175]

Thu, 29 November 2007 02:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Best Method for backup of PROD environment [message #284246 is a reply to message #284192]

Thu, 29 November 2007 04:01

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

Report message to a moderator

Re: Best Method for backup of PROD environment [message #284248 is a reply to message #284246]

Thu, 29 November 2007 04:05

fadi.abadir
Messages: 4
Registered: November 2007
Location: Egypt

Junior Member

Sorry for bothering you... I found the link.. thanks Very Happy

Report message to a moderator

Previous Topic:	RMAN
Next Topic:	RMAN Incremental question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 21:43:49 CST 2024