RMAN Recipes for Oracle 8i on Windows
Okay so I'm trying to help a friend who's set up at work is still on 8i on Windows 2000 server. They don't plan to upgrade as they are actually planning to switch databases soon. But for now, he needs help implementing an automated backup plan. Let's say level 0 backup on Sunday, level 1 on Tuesdays on Thursdays, then archivelog backup on the other days. Additionally, we want to purge the archivelogs during the level 0 backup. If this was at least 10g and on Linux, I wouldn't have a problem. However I need to research a bit more on 8i. So far I've been able to create the catalog and make a full backup.
One thing I don't have any idea of is the equivalent of cron/scheduled jobs in Windows 2000 server.
Note that I know where to look for the solution (Oracle documentation, etc), but I would like to do this quickly so would appreciate if you can share your recipes for this requirement. Assume write the backup to internal disk only.
Thanks.
One thing I don't have any idea of is the equivalent of cron/scheduled jobs in Windows 2000 server.
Note that I know where to look for the solution (Oracle documentation, etc), but I would like to do this quickly so would appreciate if you can share your recipes for this requirement. Assume write the backup to internal disk only.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks manzoor_dba! Ok it seems I have that part covered, but I guess I'll really have to research on the RMAN recipes myself.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks MrJoltCola! Just give me time to setup my local test environment to try them out and then will give you feedback.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was thinking actually the same thing. What's the equivalent of "delete archivelogs all completed before 'sysdate - 30'" in 8i?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again!
You can find this in control panel named as scheduled task.
Thanks..