OraFAQ Forum: Backup & Recovery » HOW TO BACK UP MY DATABASE

Home » RDBMS Server » Backup & Recovery » HOW TO BACK UP MY DATABASE

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

HOW TO BACK UP MY DATABASE [message #193090]

Thu, 14 September 2006 21:00

jamesrussell15
Messages: 16
Registered: September 2006
Location: philippines

Junior Member

HOW TO BACKUP MY DATABASE?

THANK YOU.

Report message to a moderator

Re: HOW TO BACK UP MY DATABASE [message #193098 is a reply to message #193090]

Thu, 14 September 2006 21:25

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Time to start reading the fine manuals Backup and Recovery Basics.

Report message to a moderator

Re: HOW TO BACK UP MY DATABASE [message #193100 is a reply to message #193090]

Thu, 14 September 2006 21:26

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: HOW TO BACK UP MY DATABASE [message #193263 is a reply to message #193090]

Fri, 15 September 2006 08:37

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,

Report message to a moderator

Re: HOW TO BACK UP MY DATABASE [message #193559 is a reply to message #193090]

Mon, 18 September 2006 04:53

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';
}
--->

Report message to a moderator

Previous Topic:	Disaster Recovery
Next Topic:	ORa-01135

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 14:26:20 CDT 2024