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

Editor to share with you how to use the oracle RMAN backup script under Windows, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Modify RMAN related parameters

RMAN > show all

RMAN > CONFIGURE CONTROLFILE AUTOBACKUP ON

RMAN > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO'dVOUGUBUGUP% F'

RMAN > exit

After setting as above, the control file and spfile will be automatically backed up to the d:/backup with the database backup.

two。 Backup script

Rmanbackup.txt file, the contents are as follows:

RUN {

Allocate channel c1 type disk

Backup database format'DUR 'DRAPHERGUBG database% U'DU'DRAPHERA HotbackUnique% U'

Release channel c1

}

Exit

Rmanbackup.bat file, the contents are as follows:

Rman target sys/admin@dba nocatalog CMDFILE'dappled RMANBackup.txt'

LOG'dnav image rmanuel backups% datesupery 0Magi 4% datebuzz 5 minus 2% datebuzz 8J 2% ".log'

Just add the rmanbackup.bat file to the scheduled task and execute it regularly. After the backup is completed, the log file in the format of rman_backup_20100112.log is generated in the same directory.

Add an archive backup script:

Rmanarchbackup.txt file, the contents are as follows:

RUN {

Allocate channel c1 type disk

Backup archivelog all format'DRNAL Rmanbakome archetype% U'delete input

Release channel c1

}

Exit

Rmanarchbackup.bat file, the contents are as follows:

Rman target / nocatalog CMDFILE 'dlog' DVV log' Rmanarchbackup.txt'DMANBAKG rmanarchbackup.txt'DATERAMBAKBAGRMANBAGUBUP% DATEMORAPHY 0 append 4% DATEVOREGRAPHY 5% DATEREGULAR 8% 2% ".log 'Log'

The above is all the contents of the article "how to use oracle RMAN backup script under Windows". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.