Home » RDBMS Server » Backup & Recovery » automatic backup
automatic backup [message #128482] Mon, 18 July 2005 22:46 Go to next message
Messages: 356
Registered: March 2005
Senior Member
Hi there..
Could any body let me know how could I program my win2k, 8i enterprise to take backup (dump file) automatically on every Friday 2:00 PM. I have an idea of batch file using win2k services, but m not clear. plz help
Re: automatic backup [message #128483 is a reply to message #128482] Mon, 18 July 2005 22:53 Go to previous messageGo to next message
Messages: 21
Registered: July 2005
Junior Member
create a batch file for exporting database then set it on the windows scheduler to run the file every friday at 2:00.

Mike Cuisia
Oracle DBA
Re: automatic backup [message #128494 is a reply to message #128483] Mon, 18 July 2005 23:58 Go to previous messageGo to next message
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member

That way you will be taking the logical backup of database.

First you need to decide what type of backup you want to have & how you want to perform this backup. Whether you want logical backups or physical backups.

If you want user managed physical backups, then are you planning hot backup or cold backup?... Batch files containing backup scripts will do for this. In later case...cold backup... you will be reuired to shutdown the database as well using those scripts itself.

If you are going to use RMAN for backup then windows scheduler need not be configured. This backup timing configuration can be done at RMAN level.

Re: automatic backup [message #186040 is a reply to message #128483] Sat, 05 August 2006 01:31 Go to previous message
Messages: 7
Registered: August 2006
Junior Member

hi can you let me know the steps to create a batch file & how to set windows scheduler..
Previous Topic: Please help
Next Topic: linking oracle with MML
Goto Forum:

Current Time: Tue Aug 22 04:24:32 CDT 2017

Total time taken to generate the page: 0.02413 seconds