OCP-V13-337
来源:互联网 发布:winxp网络共享设置 编辑:程序博客网 时间:2024/06/05 19:52
QUESTION 337
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an
automated cross-check script that also does a delete expired backupset command. You have restored all
the backup set pieces from tape. What command would you use to get those backup set pieces
registered in the recovery catalog and the control file of the database again?
A. register database
B. recover catalog
C. load backupset
D. synch metadata
E. catalog start with
Correct Answer: E
由于磁盘故障你失去了你所有的RMAN备份集。不幸的是,你有一个
自动检查脚本,也删除过期的备份集的命令。你已经从磁带恢复了所有
备份集。使用什么命令再来获得这些备份集
注册在恢复目录和数据库的控制文件?
E. catalog start with
catalog start with 将RMAN备份集恢复到另一台机器 oracle10g 中rman的增强功能catalog
start with 将备份集注册到控制文件
http://blog.itpub.net/27042095/viewspace-759237/
catalog start with 是一个很好的命令. 有了这个命令后, 基本上可以不再使用catalog数据库了 .
因为可以通过这个命令将以前的备份集信息重新导入到当前控制文件中, 一般应用于使用rman恢复,
控制文件又是旧的或者是手工创建的(这样的控制文件当然没有最新的备份集的信息), 通过catalog start with
可以将最新的备份集以及归档日志文件列表导入到控制文中, 然后就可以进行rman的恢复了. 例如,拷贝备份集到 /data01 下
,
RMAN> startup nomount;RMAN> restore controlfile from '/data01/testdb_CF_c-3148051840-20110813-00'; # 从控制文件备份集恢复控制文件RMAN> alter database mount;catalog start with '/data01/'; (一定要用“/”结尾,不然找不到真实的路径)run{ allocate channel c1 type disk;allocate channel c2 type disk;allocate channel c3 type disk;set newname for datafile '+DATA/icare/datafile/system.309.717426483' to '/backup/supt/suptdata/system.309.717426483'; set newname for datafile '+DATA/icare/datafile/apps_undots1.283.717426031' to '/backup/supt/suptdata/apps_undots1.283.717426031'; set newname for datafile '+DATA/icare/datafile/apps_ts_tx_data.273.717426033' to '/backup/supt/suptdata/apps_ts_tx_data.273.717426033'; set newname for datafile '+DATA/icare/datafile/apps_ts_tx_data.275.717426033' to set newname for datafile '+DATA/icare/onlinelog/group_16.265.743248917' to '/data02/supt/suptdata/group_16.265.743248917';restore database force;switch datafile all;}如果备份集存放在多个路径,可以多次执行 RMAN> catalog start with '/data01/'; RMAN>catalog start with '/data02/'; RMAN>catalog start with '/data03/';
- OCP-V13-337
- OCP-V13-676
- OCP-V13-711
- OCP-V13-710
- OCP-V13-709
- OCP-V13-708
- OCP-V13-707
- OCP-V13-705
- OCP-V13-704
- OCP-V13-703
- OCP-V13-702
- OCP-V13-701
- OCP-V13-700
- OCP-V13-700
- OCP-V13-699
- OCP-V13-698
- OCP-V13-697
- OCP-V13-696
- 链表的操作
- 提前拥有需要付出代价,延后享受理应获得更多回报
- Cocoapods安装步骤
- 欢迎使用CSDN-markdown编辑器
- Android自定义控件:图片比例适配,解决图片白边(详解View中onMeasure方法)
- OCP-V13-337
- osg 1 添加纹理
- MySQL的常见SQL语句范例
- 04-树5 Root of AVL Tree
- Java压缩图片util,可等比例宽高不失真压缩,也可直接指定压缩后的宽高
- css
- Unity3D中数学知识之【1】:SmoothDamp平滑阻尼
- 开发google浏览器chrome的JS插件
- LayoutParams继承于Android.View.ViewGroup.LayoutParams.