Home » RDBMS Server » Backup & Recovery » automatic backup
automatic backup [message #128482] Mon, 18 July 2005 22:46 Go to next message
rzkhan
Messages: 345
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
Riaz
Re: automatic backup [message #128483 is a reply to message #128482] Mon, 18 July 2005 22:53 Go to previous messageGo to next message
cuisia
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
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

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.

Regds
Girish
Re: automatic backup [message #186040 is a reply to message #128483] Sat, 05 August 2006 01:31 Go to previous message
csharat
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..
thanks
Previous Topic: Recovery from RMAN backup files
Next Topic: Help on a recovery scenario
Goto Forum:
  


Current Time: Sun Dec 04 19:02:55 CST 2016

Total time taken to generate the page: 0.07525 seconds