OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » automatic backup

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

automatic backup [message #128482]

Mon, 18 July 2005 22:46

rzkhan
Messages: 370
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

Report message to a moderator

Re: automatic backup [message #128483 is a reply to message #128482]

Mon, 18 July 2005 22:53

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

Report message to a moderator

Re: automatic backup [message #128494 is a reply to message #128483]

Mon, 18 July 2005 23:58

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

Report message to a moderator

Re: automatic backup [message #186040 is a reply to message #128483]

Sat, 05 August 2006 01:31

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

Report message to a moderator

Previous Topic:	Recovery from RMAN backup files
Next Topic:	Help on a recovery scenario

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 11:52:58 CST 2024