OraFAQ Forum: Backup & Recovery » how to create script to backup the database

Home » RDBMS Server » Backup & Recovery » how to create script to backup the database

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

how to create script to backup the database [message #72400]

Mon, 09 June 2003 02:00

Vijay
Messages: 116
Registered: September 1999

Senior Member

please help me
how to create script to backup the database.

thanx in advance

Report message to a moderator

Re: how to create script to backup the database [message #72401 is a reply to message #72400]

Mon, 09 June 2003 02:25

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

Report message to a moderator

Re: how to create script to backup the database [message #72405 is a reply to message #72400]

Mon, 09 June 2003 06:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please have a look here

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 07:21:30 CDT 2024