检查数据文件一致性,包括物理一致性跟逻辑一致性
backup check logical validate database;
$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Mon May 30 03:04:15 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1280194524)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/backup/ctl_auto_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_orcl1.f'; # default
检查整个数据库
RMAN> RUN {
2> ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
3> ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
4> ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
5> ALLOCATE CHANNEL c4 DEVICE TYPE DISK;
6> backup check logical validate database;
7> RELEASE CHANNEL c4;
8> RELEASE CHANNEL c3;
9> RELEASE CHANNEL c2;
10> RELEASE CHANNEL c1;
11> }
allocated channel: c1
channel c1: sid=311 instance=orcl1 devtype=DISK
allocated channel: c2
channel c2: sid=293 instance=orcl1 devtype=DISK
allocated channel: c3
channel c3: sid=292 instance=orcl1 devtype=DISK
allocated channel: c4
channel c4: sid=291 instance=orcl1 devtype=DISK
Starting backup at 30-MAY-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/orcl/datafile/system.259.752366997
input datafile fno=00007 name=+DATA/orcl/datafile/test.dbf
channel c2: starting full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.260.752367003
channel c3: starting full datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00004 name=+DATA/orcl/datafile/undotbs2.263.752367007
input datafile fno=00005 name=+DATA/orcl/datafile/users.264.752367007
channel c4: starting full datafile backupset
channel c4: specifying datafile(s) in backupset
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux.261.752367003
input datafile fno=00006 name=+DATA/orcl/datafile/product.dbf
channel c2: backup set complete, elapsed time: 00:00:01
channel c3: backup set complete, elapsed time: 00:00:01
channel c4: backup set complete, elapsed time: 00:00:01
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-MAY-11
released channel: c4
released channel: c3
released channel: c2
released channel: c1
RMAN> quit
Recovery Manager complete.
检查单个数据文件或几个数据文件
RMAN> backup check logical validate datafile 1,2;
Starting backup at 30-MAY-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=292 instance=orcl1 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.260.752367003
input datafile fno=00001 name=+DATA/orcl/datafile/system.259.752366997
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 30-MAY-11
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 30 03:10:23 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
idle> conn /as sysdba
Connected.
检查过程的进度状态
sys@ORCL> select sid,serial#,context,sofar,totalwork,
2 round(sofar/totalwork*100,2) "%_complete"
3 from v$session_longops
4 where opname like 'RMAN%'
5 and opname not like '%aggregate%'
6 and totalwork != 0
7 and sofar <> totalwork
8 /
检查结果
sys@ORCL> select * from v$database_block_corruption;
no rows selected
sys@ORCL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
检查备份文件的一致性
检查数据库备份
RMAN> restore validate database;
Starting restore at 30-MAY-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /u02/backup/rac_orcl_all_20110529_01mdisji_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u02/backup/rac_orcl_all_20110529_01mdisji_1_1 tag=TAG20110529T212154
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
Finished restore at 30-MAY-11
检查最近的控制文件备份
RMAN> restore validate controlfile to '/u02/backup/ctl_auto_c-1280194524-20110529-00';
Starting restore at 30-MAY-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /u02/backup/ctl_auto_c-1280194524-20110529-00
channel ORA_DISK_1: restored backup piece 1
piece handle=/u02/backup/ctl_auto_c-1280194524-20110529-00 tag=TAG20110529T212157
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
Finished restore at 30-MAY-11
检查备份的日志文件
RMAN> restore validate archivelog from sequence 71 until sequence 72;
Starting restore at 30-MAY-11
using channel ORA_DISK_1
channel ORA_DISK_1: scanning archive log +FLASH_RECOVERY_AREA/orcl/archivelog/1_71_752413788.dbf
channel ORA_DISK_1: scanning archive log +FLASH_RECOVERY_AREA/orcl/archivelog/1_72_752413788.dbf
Finished restore at 30-MAY-11