Home » RDBMS Server » Backup & Recovery » HOW TO BACK UP MY DATABASE
HOW TO BACK UP MY DATABASE [message #193090] Thu, 14 September 2006 21:00 Go to next message
jamesrussell15
Messages: 16
Registered: September 2006
Location: philippines
Junior Member

HOW TO BACKUP MY DATABASE?

THANK YOU.
Re: HOW TO BACK UP MY DATABASE [message #193098 is a reply to message #193090] Thu, 14 September 2006 21:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Time to start reading the fine manuals Backup and Recovery Basics.
Re: HOW TO BACK UP MY DATABASE [message #193100 is a reply to message #193090] Thu, 14 September 2006 21:26 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
The answer to your question can be found in the Backup & Recovery Reference manual found at http://tahiti.oracle.com
Re: HOW TO BACK UP MY DATABASE [message #193263 is a reply to message #193090] Fri, 15 September 2006 08:37 Go to previous messageGo to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

This also one way to take the exp/emp to backup of your database

exp userid=system/manager@orcl file=c:\backup.dmp log=c:\backup.log owner=scott

Now it will take the backup of your scott schema.

Thanks,




Re: HOW TO BACK UP MY DATABASE [message #193559 is a reply to message #193090] Mon, 18 September 2006 04:53 Go to previous message
coolbalaga
Messages: 24
Registered: September 2006
Junior Member
You can use rman command to take the backup of the database.
It would be good to read rman(Recovery manager) guide.

<---
$rman target <tgt_string> nocatalog
run {
allocate channel 'dev_0' type disk;
backup database;
release channel 'dev_0';
}
--->
Previous Topic: Disaster Recovery
Next Topic: ORa-01135
Goto Forum:
  


Current Time: Thu Dec 08 10:09:33 CST 2016

Total time taken to generate the page: 0.10477 seconds