Forum Discussion

Zakirk_Khan's avatar
Zakirk_Khan
Level 4
10 years ago

How to schedule some automated hourly restore job.

Hello,

I am pressure to create a scripted for restore job. 

We have two server say server 1 and server 2.

On server 1 we are using netbackup 7.6 (Windows Server 2008) for backup.

We have one database, which need to be backup on hourly basis and want this hourly backup to be restore on diffrent server with same name and path.

What I want?
I am backing up a folder (located at \\Server1\XYZ\ABC) that includes 2 .mdb files on a hourly basis. 
Afterwards I want to restore these 2 files to a different server. 

Is it possible to create and schedule some automated hourly restore job and make it restore thes 2 files in netbackup or any other tool.

Any help will be really appreciated! 

Zakir Khan.

7.6
Backing Up
Backup and Recovery
Installing
NetBackup
Restore
Windows Server (2003-2008)
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    10 years ago

    You cannot schedule restores in NetBackup. You can use the windows scheduler or cron (unix) to schedule tasks and execute scripts.

11 Replies

Sort By
Show More
  • jim_dalton's avatar
    jim_dalton
    Level 6
    10 years ago

    You cant just grab an oracle instance hot and think it will work. Can you not...run an export to disk, backup the export , figure out how to script the restore as advised above then give it a go? Or you need to use the ora agent to back it up hot and carry out the same investigation to script a restore but for the hot ora agent.

    Stepping back you might want to look at totaly different solution:Oracle dataguard covers this kind of functionality: talk to your DBA. Jim.