博森瑞公开课_rman控制文件恢复.pdf

Oracle 控制文件回复 博森瑞老邱 2-1 Copyright © Bosenrui, 2013. All rights reserved. 自动控制文件备份没有打开 (备份到磁盘上） rman target / nocatalog log /tmp/rman_control.log run {allocate channel c1 type disk; restore controlfile from ‘/oracle/control_backup_set’; } 2-2 Copyright © Bosenrui, 2013. All rights reserved. 自动控制文件备份没有打开 (备份到磁带上） rman target / nocatalog log /tmp/rman_control.log run {allocate channel c1 type sbt_tape; restore controlfile from ‘ctl_QYL67_1’; } 2-3 Copyright © Bosenrui, 2013. All rights reserved. 自动控制文件备份打开（默认位置） 从磁盘恢复 打开控制文件自动备份(数据库必须在mount或open) rman target / rmanCONFIGURE CONTROLFILE AUTOBACKUP ON; rmanCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; 数据库恢复： Rman target / nocatalog Rmanset dbid 1333881881; Rman Run {allocate channel c1 type disk; Restore controlfile from auto backup; } 2-4 Copyright © Bosenrui, 2013. All rights reserved. 自动控制文件备份打开（不在默认位置） 从磁盘恢复 打开控制文件自动备份(数据库必须在mount或open) rman target / rmanCONFIGURE CONTROLFILE AUTOBACKUP ON; rmanCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/oracle/%F; 数据库恢复： rman target / nocatalog rmanset dbid 1333881881; rman run {SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE disk TO ‘/oracle/%F; restore controlfile from auto backup; } 2-5 Copyright © Bosenrui, 2013. All rights reserved. 自动控制文件备份打开 从磁带库回复 打开控制文件自动备份(数据库必须在mount或open) rman target / rmanCONFIGURE CONTROLFILE AUTOBACKUP ON; rmanCONF