Home » RDBMS Server » Backup & Recovery » Best way to backup a database (Oracle 10g AIX 5.3)
Best way to backup a database [message #302112] Sat, 23 February 2008 12:15 Go to next message
jefkatz
Messages: 2
Registered: February 2008
Junior Member
Hi,
what's the best way to backup (the quickest and the more efficient in term of storage capacity and time it consumes) to backup an Oracle database.
Is making a compressed archive from data files a good choice. Is it necessary to stop database when restoring (overwriting data files with previous version) ? Is there a risk if the database is not stopped and even if there's no activity on the database ?
Thanks a lot.
Re: Best way to backup a database [message #302113 is a reply to message #302112] Sat, 23 February 2008 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Are you unwilling or incapable of Reading The Fine Manual yourself?

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm
Re: Best way to backup a database [message #302114 is a reply to message #302112] Sat, 23 February 2008 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics

Regards
Michel
Re: Best way to backup a database [message #302117 is a reply to message #302112] Sat, 23 February 2008 13:59 Go to previous messageGo to next message
jefkatz
Messages: 2
Registered: February 2008
Junior Member
To reply to your question perhaps both !
But thanks a lot for your reply! It will help perhaps.
Re: Best way to backup a database [message #304304 is a reply to message #302117] Tue, 04 March 2008 16:43 Go to previous message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
What version database are you running.

the Oracle recommended way of backing up an oracle database is to use RMAN.

with 10g this also allows compression to be done in the rman statement. If you are using 9i then use an OS utility to compress the backup pieces.

regards

Alan
Previous Topic: Which type of backup shall I use?
Next Topic: Recover the old snapshot of view.
Goto Forum:
  


Current Time: Wed Dec 07 20:12:21 CST 2016

Total time taken to generate the page: 0.17410 seconds