Shulou(Shulou.com)06/02 Report--

In general, the production environment is archived, but some companies have been using non-archiving.

First of all, let's take a look at how db is archived.

SQL > archive log list

If it is archived, you can use rman for backup.

Platform: server 2008

Database:oracle 10g

Backup strategy refer to chapter 3 of the workshop II documentation in ocp (Differential Versus Cumulative section)

Full backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental backup on other days

Here is a backup scheme based on nocatlog

1: make a level 0 backup on Sunday. The script is called run0-orcl.txt.

Save policy: the resulting backup is kept on disk for 14 days and the archive log is kept for 6 days.

The script run0-orcl.txt contains the following

Run {

Configure retention policy to recovery window of 14 days

Backup incremental level=0 database include current controlfile format'C:\ db_bak\ fullback0_%d_%T_%s' plus archivelog format'C:\ archive_bak\ arch0_%d_%T_%s' delete all input

}

Report obsolete

Crosscheck backup

Delete noprompt expired backup

Delete noprompt obsolete recovery window of 14 days

Delete noprompt archivelog until time 'SYSDAY-1'

Note: if it is windows2003,sysday, it should be changed to sysdate

Then make a batch file of run0-orcl.bat, which is as follows

C:

Cd C:\ backup script

Set ORACLE_SID=ORCL

Rman target / cmdfile='C:\ backup script\ run0-orcl.txt' log='C:\ backup script\ run0-orcl_%date:~0,10%.log'

2: do level 1 differential incremental backups on Monday, Tuesday, Thursday and Saturday. The script is called run1d-orcl.txt.

Save policy: the resulting backup is kept on disk for 14 days and the archive log is kept for 6 days.

The script run1d-orcl.txt contains the following

Run {

Configure retention policy to recovery window of 14 days

Backup incremental level=1 database include current controlfile format'C:\ db_bak\ fullback1d_%d_%T_%s' plus archivelog format'C:\ archive_bak\ arch2d_%d_%T_%s' delete all input

}

Report obsolete

Crosscheck backup

Delete noprompt expired backup

Delete noprompt obsolete recovery window of 14 days

Delete noprompt archivelog until time 'SYSDAY-1'

Then make a batch file of run1d-orcl.bat, which is as follows

C:

Cd C:\ backup script

Set ORACLE_SID=ORCL

Rman target / cmdfile='C:\ backup script\ run1d-orcl.txt' log='C:\ backup script\ run1d-orcl_%date:~0,10%.log'

3: do level 1 cumulative incremental backups on Wednesday and Friday, and the script name is run1c-orcl.txt

The script run1c-orcl.txt contains the following

Run {

Configure retention policy to recovery window of 14 days

Backup incremental level=1 cumulative database include current controlfile format'C:\ db_bak\ fullback1c_%d_%T_%s' plus archivelog format'C:\ archive_bak\ arch2c_%d_%T_%s' delete all input

}

Report obsolete

Crosscheck backup

Delete noprompt expired backup

Delete noprompt obsolete recovery window of 14 days

Delete noprompt archivelog until time 'SYSDAY-1'

Then make a batch file of run1c-orcl.bat, which is as follows

C:

Cd C:\ backup script

Set ORACLE_SID=ORCL

Rman target / cmdfile='C:\ backup script\ run1c-orcl.txt' log='C:\ backup script\ run1c-orcl_%date:~0,10%.log'

4: set the execution task

Start-Administrative tools-Task Scheduler

Then follow the script above to create a new task plan

Increment. Jpg

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.