RMAN指令例子分析

不使用恢复目录连接到数据

库

连接到目标数据库和恢复目

录数据库

连接到目标数据库和辅助数

据库

关闭数据库

启动数据库

备份USERS表空间

作业命令

运行SQL命令

运行存储脚本

运行操作系统命令

运行RMAN命令

配置通道的并行度

配置所有通道的备份文件格

式

配置特定通道的备份文件格

式

配置默认存储设备

配置备份集的最大尺寸

配置备份片最大尺寸

配置备份优化

配置多重备份

配置免除表空间

配置备份冗余策略

配置辅助例程的数据文件名改变快照控制文件的名称和

位置

显示RMAN环境配置

显示默认设备类型

显示自动通道配置

显示备份冗余策略

显示备份优化

显示快照控制文件

显示备份集最大尺寸

显示多重备份

清除RMAN配置

完全数据库备份集

免除表空间表空间备份

数据文件备份集

控制文件备份集

SPFILE备份集

归档日志备份集

并行化备份集

建立多重备份

备份备份集

建立多个备份片

建立压缩备份集

备份数据文件和归档日志

指定备份集标记

建立数据文件映像副本

建立控制文件映像副本

建立归档日志映像副本

并行化建立映像副本

指定映像副本标记

查询归档日志备份

查询控制文件和数据文件的

备份集信息

查询损坏数据块信息

所有数据文件被删除的恢复数据文件所在磁盘出现硬件

故障的恢复

system被误删后的恢复system所在磁盘损坏后的恢

复

数据文件被误删后恢复数据库文件所在磁盘损坏后

恢复

open时数据文件被误删除open时数据文件所在磁盘出

现故障

open时恢复未备份的数据文

件

恢复表空间

不完全恢复

删除早期备份并重新建立新

的备份

基于SCN恢复

基于日志序列号的不完全恢

复

基于备份控制文件恢复报告目标数据库的物理结构报告需要备份的数据文件报告特定天数未备份的数据

文件

报告低于特定备份次数的数

据文件

报告在恢复时间窗口内未备

份的数据文件报告陈旧备份

报告不可恢复的数据文件列出数据文件备份集

列出控制文件备份集

列出归档日志备份集

列出SPFILE备份集

列出数据文件映像副本

列出控制文件映像副本

列出归档日志映像副本

列出数据库副本

核对所有备份集

核对所有数据文件的备份集核对特定表空间的备份集核对特定数据文件的备份集核对控制文件的备份集

核对SPFILE的备份集

核对归档日志的备份集

核对所有映像副本

核对所有数据文件的映像副

本

核对特定表空间的映像副本核对特定数据文件的映像副

本

核对控制文件的映像副本核对归档日志的映像副本

删除陈旧备份

删除EXPIRED备份集

删除EXPIRED副本

删除特定备份集

删除特定备份片

删除所有备份集

删除特定映像副本

删除所有映像副本

改变备份集状态

改变映像副本状态

建立长期备份

注册副本

注册备份片

注册特定目录的所有备份文

件

注销备份记录建立恢复目录

建立存储脚本

运行存储脚本显示存储脚本内容替换存储脚本

删除存储脚本列出所有存储脚本重新同步恢复目录指令1

rman target sys/ly870119@orcl nocatalog

rman target sys/ly870119@orcl catalog rman/rman@rcat

rman target sys/ly870119@orcl auxiliary sys/admin@aux

shutdowm immediate

startup

backup format 'd:\\backup\\%d_%s.bak' tablespace users

run {allocate channel d1 type disk;backup format 'd:\\backup\\%d_%s.bak' tablespace users;release channel d1;}

sql 'alter system switch logfile'

run {execute script s1;}

run {host "dir d:\\backup";}

run { configure channel device type disk maxpiecesize 100M;backup format 'D:\\backup\\%d_%s_%p.BAK' tablespace system;}

configure device type disk parallelism 3

configure channel device type disk format 'd:\\backup\\%d_%s_%p.bak' configure channel 1 device type disk format 'd:\\backup\\%d_%s_%p.bak' configure default device type to sbt

configure maxsetsize to 1G

configure channel device type disk maxpiecesize 500M

configure backup optimization on

configure datafile backup copies for device type disk to 3

configure exclude for tablespace user03

configure retention policy to redundancy 2

configure auxname for datafile 2 to 'd:\\auxi\\df_2.dbf' configure snapshot controlfile name to 'D:\\oracle\\ora10\\snfcDEMO.ora'

show all

show default device type

show channel for device type disk

show retention policy

show backup optimization

show snapshot controlfile name

show maxsetsize

show archivelog backup copies

configure retention policy clear

rman target sys/ly870119@orcl nocatalog/shutdown immediate/startup mount/backup database format='d:\\backup\\%d_%s.dbf'/sql 'alter system

archive log current'

configure exclude for tablespace user03/backup database

format='d:\\backup\\%d_%s.dbf'/sql 'alter system archive log current'

backup tablespace user03 format='d:\\backup\\%N_%s.dbf'

backup datafile 5 format='d:\\backup\\%N_%f_%s.dbf' backup current controlfile format='d:\\backup\\%d_%s.ctl'

backup spfile format='d:\\backup\\%d_%s.par'

backup format='d:\\backup\\%d_%s.arc' archivelog from time='sysdate-1'

until time 'sysdate'

configure device type disk parallelism 3/backup database format='d:\\backup\\%d_%s.dbf'/configure device type disk clear

backup copies 3 tablespace users

format='d:\\bak1\\%N_%s.dbf','d:\\bak2\\%N_%s.dbf','d:\\bak3\\%N_%s.dbf' backup backupset 32 format='d:\\bak1\\%d_%s.bak'

configure channel device type sbt maxpiecesize 4G/backup device type

sbt format '%d_%s_%p.dbf' database

backup as compressed backupset tablespace users

format='d:\\backup\\%d_%s.dbf'

backup format 'd:\\backup\\%d_%s.bak' tablespace user01 plus archivelog backup format 'd:\\backup\\%d_%s.bak' tablespace users tag='users' backup as copy format='d:\\backup\\df_5.dbf' datafile 5 backup as copy format='d:\\backup\\demo.ctl' current controlfile

backup as copy format='d:\\backup\\archive\\arc20.log' archivelog

sequence 20

configure device type disk parallelism 3/backup as copy format='d:\\backup\\df_%f.dbf' datafile 5,6,7/configure device type

disk clear

backup as copy format='d:\\backup\\df_%f.dbf' datafile 5 tag=df_5

select sequence#,name,first_change# from v$archived_log where

status='A'

select a.file#,b.handle,a.blocks*a.block_size byte from

v$backup_datafile a,v$backup_piece b where a.set_stamp=b.set_stamp

and b.status='A'

select file#,block#,blocks,marked_corrupt from v$backup_corruption rman target sys/ly870119@orcl nocatalog/startup force mount/run {restore database;recover database;sql 'alter database open';} run { startup force mount;set newname for datafile 1 to

'C:\\demo\\system01.dbf';set newname for datafile 2 to 'C:\\demo\bs01.dbf';..;restore database;switch datafile all;recover database;sql 'alter database open';} run { startup force mount;restore datafile 1;switch datafile 1;recover datafile 1;sql 'alter database open';}

run{startup force mount;set newname for datafile 1 to

'd:\\demo\\system01.dbf';restore datafile 1;switch datafile 1;recover datafile 1;sql 'alter database open';}

run { startup force mount;sql 'alter database datafile 4 offline';sql 'alter database open';restore datafile 4;recover datafile 4; sql

'alter database datafile 4 online';}run { startup force mount;sql 'alter database datafile 4 offline';sql 'alter database open';set newname for datafile 4 to 'd:\\demo\01.dbf';restore datafile 4;recover datafile 4;sql

'alter database datafile 4 offline';}

run { sql 'alter database datafile 4 offline';restore datafile

4;recover datafile 4;sql 'alter database datafile 4 online';}

run { sql 'alter databasse datafile 4 offline';set newname for

datafile 4 to 'C:\\demo\01.dbf';restore datafile 4;switch

datafile 4;recover datafile 4;sql 'alter database datafile 4

online';}

run {startup force mount;sql 'alter database datafile 7 offline';sql 'alter database open';restore datafile 7;recover datafile 7;sql

'alter database datafile 7 online';}

run { sql 'alter tablespace users offline for recover';restore tablespace users;recover tablespace users;sql 'alter tablespace users

online';}

run { startup force mount;set until time='2008-09-19

17:00:00';restore database;recover database;sql 'alter database open

resetlogs';}

run {delete noprompt backup;delete nopromopt copy;backup database format='d:\\backup\\%d_%s.bak';sql 'alter system archive log current';}

select current_scn from v$database

run { startup force mount;set until sequence=6;restore database;recover database;sql 'alter database open resetlogs';} set nls_date_format=yyyy-mm--dd hh24:mi:ss/rman target

sys/ly870119@orcl nocatalog

report schema

report need backup incremental 3

report need backup days 3 tablespace users

report need backup redundancy 2 database

report need backup recovery window of 6 daysreport obsolete redundancy 2

report unrecoverable

list backup of tablespace user01

list backup of controlfile

list backup of archivelog all

list backup of spfile

list copy of datafile 5

list copy of controlfile

list copy of archivelog all

list incarnation of database

crosscheck backup

crosscheck backup of database

crosscheck backup of tablespace system

crosscheck backup of datafile 4

crosscheck backup of controlfile

crosscheck backup of spfile

crosscheck backup of archivelog sequence 3

crosscheck copy

crosscheck copy of database

crosscheck copy of tablespace users

crosscheck copy of datafile 6

crosscheck copy of controlfile

crosscheck copy of archivelog sequence 4

delete obsolete

delete noprompt expired backup

delete noprompt expired copy

delete noprompt backupset 19

delete noprompt backuppiece 'D:\\backup\\demo_18.bak'

delete noprompt backup

delete nopromt datafilecopy 'D:\\backup\\demo_31.bak'

delete nopromt copy

change backupset 22 unavailable

change datafilecopy 'd:\\backup\\orcl_37.bak' unavailable change backupset 156 keep forever logs/change backupset 156 nokeep catalog datafilecopy 'd:\\backup\01.bak'

catalog backuppiece 'd:\\backup\\demo_40.dbf'

catalog start with 'd:\\bak'

change datafilecopy 'd:\\bak\01.bak' uncatalog/change controlfilecopy 'd:\\bak\\demo.ctl' uncatalog/change backuppiece

'd:\\bak\\demo_35.bak' uncatalogsqlplus system/ly870119@catdb/create tablespace rman_ts datafile 'F:\\oradata\\catdb\\rman.dbf' size 50M/create user rman identified by rman default tablespace rman_ts/grant

connect,resource,recovery_catalog_owner to rman

rman catalog rman/rman@catdb target sys/ly870119@orcl

run {execute script bak_database;}

print script bak_database

replace script bak_database{backup database

format='F:\\orclbackup\\%d_%s.bak';}

delete script bak_database

list script names

resync catalog指令2状态rman nocatalog/connect sys/ly870119 @orcl DOC/RMAN

DOC rman/connect target sys/oracle@orcl/connect

auxiliary sys/admin@aux DOC/RMAN

rman

rman

rman

rman sql "create tablespace user03 datafile

''d:\\demo\3.dbf'' size 5m rman

rman

rman

rman configure device type sbt parallelism 3rman

rman configure channel 2 device type disk format

'd:\\backup\\%u.bak'rman configure dafault device type to disk rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman backup database format='d:\\backup\\%d_%s.dbf'/sql

'alter system archive log current rman

rmanrman

rman backup datafile 5 format='d:\\backup\\%d_%s/dbf'

include current controlfile rman

rman

rman

rman

rman

rman

rman

rman

rman

rman copy datafile 5 to 'd:\\backup\\df_5.dbf'rman copy current controlfile to 'd:\\backup\\demo.ctl'rman copy archivelog 'd:\\demo\\archive\\arc00020_xxx.xx'

to 'd:\\backup\\archive\\arc20.log'rman

rman copy datafile 5 to 'd:\\backup\\df_%f.dbf' tag=df_5rman

rman

rman select file#,block#,blocks,marked_corrupt from

v$copy_corruption rman

rman

rman

rman

rman

rman

rman

rman

rman run { startup force mount;sql 'alter database

datafile 7 offline';sql 'alter database open';set

newname for datafile 7 to

'C:\\demo\4.dbf';restore datafile 7;switch

datafile 7;recover datafile 7;sql 'alter database

datafile 7 online';}rman run {sql 'alter tablespace users offline for

recover';set newname for datafile 4 to

'd:\\demo\1.dbf';restore tablespace

users;switch datafile all;recover tablespace

users;sql 'alter tablespace users online';}rman

set nls_date_format=yyyy-mm-dd hh24:mi:ss rman

rman run { startup force mount;set until

scn=511413;restore database;recover database;sql

'alter database open resetlogs';}open/rman

rman startup force nomount/set dbid=3282656886/restore controlfile from autobackup maxseq 6/alter

database mount/run { set until time='2008-09-19

17:00:00';restore database;recover database;sql

'alter database open resetlogs';}rman

rman

rman

rman

rman

rmanrman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman

rman delete noprompt obsolete rman

rman

rman

rman

rman

rman

rman

rman

list backupset 22rman list datafilecopy 'd:\\backup\\orcl_37.bak'rman change backupset 198 keep until time 'sysdate+60'

logs rman

rman

rman

rman

rmanrman catalog rman/rman@catdb/create

catalog/connect target sys/oracle@orcl/register

database/report schema rman create script bak_database{backup

format='F:\\orclbackup\\%d_%s.bak' database include

current controlfile plus archivelog;sql 'alter

system archive log current';}rman rman catalog rman/rman@catdb target

sys/ly870119@orcl script bak_database rman/doc

rman

rman

rman

rman

rman备注

指令1，2功能相同，连接到目标

数据库准备备份

有待补充

有待补充

作业是成组方式执行的命令指令2中有加单引号内容用两个

单引号

将磁盘磁带的并行度配置为3指令1是一致性备份，指令2是非

一致性备份

TAG选项指定备份集标记

指令1是误删除，指令2是磁盘故

障情况

指令1是误删除，指令3是磁盘故

障情况

基于时间的不完全恢复

建议在执行完不完全恢复后，重

新备份数据库

建议在执行完不完全恢复后，重

新备份数据库

建议在执行完不完全恢复后，重

新备份数据库

没有使用恢复目录，就必须激活控制文件自动备份，否则将不能转存控制文件备份

增量备份个数超过3次的数据文件需要执行完全备份，缩短转存

时间

为了缩短恢复时间，需要报告备份需要多少天恢复日志备份文件要多来几份才保险报告需要恢复天数大于6天的备

份文件

报告备份次数超过两次的陈旧备

份

指令2是无提示删除，冗余度很重要，决定那些备份是陈旧的指令1是修改永久保留与否，指

令2是保留60天指令1是在恢复目录数据库建立恢复目录，指令2是注册目标数据库，查看恢复目录controlfile内容改变后都要同步一下，更新恢复目录