Home » RDBMS Server » Backup & Recovery » Oracle DB backup/restore (merged)
Oracle DB backup/restore (merged) [message #399215] Tue, 21 April 2009 02:49 Go to next message
an_sush
Messages: 6
Registered: March 2009
Junior Member
I want to do a oracle database backup using scripting (without using any GUI Tool) to some location and also restore back to the backed up file later on by dropping the then existing database.
Can you please guide me a simple way to do so using sqlplus.
Preferably without stopping the db
Re: Oracle DB backup/restore [message #399219 is a reply to message #399215] Tue, 21 April 2009 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SQL*Plus is NOT a backup tool.
Use RMAN. All is explained in details in documentation, http://tahiti.oracle.com

Regards
Michel
Backup/Restore DB [message #399395 is a reply to message #399215] Wed, 22 April 2009 01:05 Go to previous messageGo to next message
an_sush
Messages: 6
Registered: March 2009
Junior Member
Hi All,

How can i backup/restore the whole database using command line (like sqlplus). I want to do it programatically. Keep the backup somewhere and then restore back if required. Kindly help. The minimum the no of steps, the better it would be do programatically
Re: Backup/Restore DB [message #399397 is a reply to message #399395] Wed, 22 April 2009 01:14 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Same answer to your same question yesterday.

And post your questions in the correct forum.

Regards
Michel

[Updated on: Wed, 22 April 2009 01:15]

Report message to a moderator

Previous Topic: Rman backup in mount stage
Next Topic: reduce rman backup size
Goto Forum:
  


Current Time: Fri Nov 22 08:26:58 CST 2024