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

This article mainly introduces how to use RMAN to verify the effectiveness of the backup, the article is very detailed, has a certain reference value, interested friends must read 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 use RMAN to verify the validity of backups". Thank you for reading! Hope to share the content to help you, more related 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.