Home » RDBMS Server » Backup & Recovery » oracle backup
oracle backup [message #73462] Wed, 05 May 2004 02:40 Go to next message
reaky
Messages: 1
Registered: May 2004
Junior Member
Hi all
i have an oracle database server on my company
oracle installed in RedHat Linux
and i'm new in oracle
so i want to make backup to the oracle server
i heard about command expr, but i know that it's interactive command ,but i don't know about it
so can any one help me or give me a full backup command to do the backup to my server
thank you for help
Re: oracle backup [message #73491 is a reply to message #73462] Tue, 11 May 2004 06:29 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Read the Backup/Recovery FAQ at http://www.orafaq.com/faqdbabr.htm

Let us know if you have any questions afterwards.

Best regards.

Frank
Re: oracle backup [message #73496 is a reply to message #73462] Tue, 11 May 2004 11:27 Go to previous message
croca
Messages: 50
Registered: January 2004
Member
EXP stands for export utility. You can do logical backups with export, you can export data from your tables, or you can export entire database.
When you do an expotr, a file is created wich will contain the information you exported.
You can do backup by copying datafiles to tape or other media. That's a physical backup. You can do it after shuting doen your db, or you can do online hot backup.
And you also can do do backup with RMAN utility (this tool comes when you install oracle, is not an option sold separatelly).

Hope this helps.
If you plan to use RMAN, try RMV from www.otools.com.ar
Best regards.
Previous Topic: backup problem
Next Topic: losing controlfile as RMAN repository
Goto Forum:
  


Current Time: Tue Apr 16 05:39:38 CDT 2024