Experiment Name: Create a logical backup task under WIN7 experiment environment operating system WIN764bit flagship database Oracle11.2.0.1.064bit backup user scott1. create a backup solution for full backup of user data every Monday, three, five, and, delete the backup one week before the backup. 2. Write a script to add a txt text file, and change the suffix to bat.
Experiment Name: Create a logical backup task under WIN7 experiment environment operating system WIN7 64bit flagship database Oracle 11.2.0.1.0 64bit backup user scott 1. the backup scheme is developed to perform full backup of user data at every Monday, Wednesday, and Friday. The backup was deleted one week before the backup. 2. Write a script to add a txt text file, and change the suffix to bat.
Lab name: Create a logical backup task under WIN7
Lab Environment
Operating System |
WIN7 64bit flagship Edition |
Database |
Oracle 11.2.0.1.0 64bit |
Backup user |
Scott |
1. Develop backup solutions
Perform full backup of user data at every Monday, Wednesday, or Friday. The backup was deleted one week ago.
2. write scripts
Add a txt text file and change the suffix to bat, for example:
Edit the script as follows:
Monday script:
# Deleting a backup from the last Monday
Del D: \ files \ backtest \ Monday. dmp
Del D: \ files \ backtest \ Monday. log
# Back up data on Monday
Exp scott/tiger @ xckymy file = D: \ files \ backtest \ Monday. dmp log = D: \ files \ backtest \ Monday. log
Similarly, scripts for Wednesday, Friday, and Sunday are completed.
3. Develop planned tasks
WIN-accessories-System Tools-Task Scheduler
Click "create basic task", for example:
Add the "Task Scheduler" for Wednesday, Friday, and Sunday in the same way ".