Shulou(Shulou.com)05/31 Report--

Editor to share with you how to verify the effectiveness of RMAN backup, 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!

RMAN provides commands for VALIDATE, which can be used to verify the validity of backup sets. Common commands are as follows:

Restore validate controlfile

Restore validate database

The verification command recommends the existence, integrity, and recoverability of the backup, which helps us to confirm whether the backup is valid or not.

For example, verify control files and parameter files:

RMAN > restore validate controlfile

Starting restore at 25-JAN-10

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=388 devtype=DISK

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / opt/oracle/product/db10g/dbs/c-1341966532-20100125-01

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/opt/oracle/product/db10g/dbs/c-1341966532-20100125-01 tag=TAG20100125T094817

Channel ORA_DISK_1: validation complete, elapsed time: 00:00:02

Finished restore at 25-JAN-10

RMAN > restore validate spfile

Starting restore at 25-JAN-10

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / opt/oracle/product/db10g/dbs/c-1341966532-20100116-00

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/opt/oracle/product/db10g/dbs/c-1341966532-20100116-00 tag=TAG20100116T033113

Channel ORA_DISK_1: validation complete, elapsed time: 00:00:02

Finished restore at 25-JAN-10

Verifying full backups is generally slow, so try it carefully:

RMAN > restore validate database

Starting restore at 25-JAN-10

Using channel ORA_DISK_1

Data file 22 will be created automatically during restore operation

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / data3/ordrbak/orderfullback_order_20100124_4691

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/data3/ordrbak/orderfullback_order_20100124_4691 tag=order

Channel ORA_DISK_1: validation complete, elapsed time: 00:02:36

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / data3/ordrbak/orderfullback_order_20100124_4692

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/data3/ordrbak/orderfullback_order_20100124_4692 tag=order

Channel ORA_DISK_1: validation complete, elapsed time: 00:01:45

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / data3/ordrbak/orderfullback_order_20100124_4693

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/data3/ordrbak/orderfullback_order_20100124_4693 tag=order

Channel ORA_DISK_1: validation complete, elapsed time: 00:00:26

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / data3/ordrbak/orderfullback_order_20100124_4694

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/data3/ordrbak/orderfullback_order_20100124_4694 tag=order

Channel ORA_DISK_1: validation complete, elapsed time: 00:00:56

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / data3/ordrbak/orderfullback_order_20100124_4695

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/data3/ordrbak/orderfullback_order_20100124_4695 tag=order

Channel ORA_DISK_1: validation complete, elapsed time: 00:00:07

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / data3/ordrbak/orderfullback_order_20100124_4696

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/data3/ordrbak/orderfullback_order_20100124_4696 tag=order

Channel ORA_DISK_1: validation complete, elapsed time: 00:00:04

Channel ORA_DISK_1: starting validation of datafile backupset

Channel ORA_DISK_1: reading from backup piece / data3/ordrbak/orderfullback_order_20100124_4697

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/data3/ordrbak/orderfullback_order_20100124_4697 tag=order

Channel ORA_DISK_1: validation complete, elapsed time: 00:00:07

Failover to previous backup

Data file 22 will be created automatically during restore operation

Finished restore at 25-JAN-10

The validation command does not actually perform the recovery, so you can subtract the hassle of off-machine testing and so on.

The above is all the contents of the article "how to verify the validity of RMAN backups". 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.