Home » RDBMS Server » Backup & Recovery » how to create script to backup the database
how to create script to backup the database [message #72400] Mon, 09 June 2003 02:00 Go to next message
Vijay
Messages: 116
Registered: September 1999
Senior Member
please help me
how to create script to backup the database.

thanx in advance
Re: how to create script to backup the database [message #72401 is a reply to message #72400] Mon, 09 June 2003 02:25 Go to previous messageGo to next message
kksrinivasan
Messages: 1
Registered: June 2003
Junior Member
Note : If u are working in a NT environment
--------------------------------------------
Create a Batch file & put the export commands in that
batch file & try to automate that batch file using the
scheduler

Try this sample scrit in a Test DB & after working out fine , continue with ur Productin DB

Scipt inside your Batch File
----------------------------
Exp system/****** full=y file=d:db_exp906_exp.dmp log=d:db_exp906_expL1.log

Step to Create a Batch File
---------------------------
1) Open Notepad from the dos mode
2) Write the above mentioned script in the notepad
& save it as "xxx.bat"
3) Schedule this script in the scheduler

Hope this works out - take care - KK
Re: how to create script to backup the database [message #72405 is a reply to message #72400] Mon, 09 June 2003 06:09 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please have a look here

http://orafaq.com/faqscrpt.htm#BRR

Previous Topic: Closed Backup Error
Next Topic: fail in backup with RMAN.
Goto Forum:
  


Current Time: Sat May 25 10:30:06 CDT 2024