使用RMAN来PDB执行完全恢复
发表于:2024-09-22 作者:千家信息网编辑
千家信息网最后更新 2024年09月22日,可以对一个或多个PDB执行完全恢复而不影响其它为open状态的PDB的操作。RMAN有两种方法来恢复PDB:.连接到CDB的root容器,然后使用restore pluggable database与
千家信息网最后更新 2024年09月22日使用RMAN来PDB执行完全恢复
可以对一个或多个PDB执行完全恢复而不影响其它为open状态的PDB的操作。RMAN有两种方法来恢复PDB:
.连接到CDB的root容器,然后使用restore pluggable database与recover pluggable database命令。这种方法能让你使用单个命令来恢复多个PDB。
.连接到PDB并使用restore database与recover database语句,这种方法只能恢复单个PDB并且能让你使用相同的命令来恢复non-CDB数据库
使用RMAN恢复一个或多个PDB
1.启动RMAN并使用有sysdba或sysbackup权限的公共用户连接到root容器
[oracle@jytest1 ~]$ rman target/ catalog rco/xxxxx@jypdb_173Recovery Manager: Release 12.2.0.1.0 - Production on Mon Dec 11 16:56:58 2017Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.connected to target database: JY (DBID=979425723)connected to recovery catalog database
2.关闭你要执行恢复操作的PDB
SQL> alter pluggable database jypdb,testpdb close immediate;Pluggable database altered.SQL> select name,open_mode from v$pdbs;NAME OPEN_MODE-------------------------------------------------------------------------------------------------------------------------------- ----------PDB$SEED READ ONLYJYPDB MOUNTEDTESTPDB MOUNTEDSQL>
3.可选操作,使用configure命令来配置缺省设备类型与自动通道
4.执行restore pluggable database与recover pluggable database命令,下面的语句恢复 jypdb,testpdb
RMAN> restore pluggable database jypdb,testpdb;Starting restore at 11-DEC-17starting full resync of recovery catalogfull resync completeallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=2279 instance=jy1 device type=DISKskipping datafile 5; already restored to file +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675skipping datafile 6; already restored to file +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675skipping datafile 8; already restored to file +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00010 to +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649channel ORA_DISK_1: restoring datafile 00011 to +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649channel ORA_DISK_1: restoring datafile 00012 to +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649channel ORA_DISK_1: restoring datafile 00013 to +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649channel ORA_DISK_1: restoring datafile 00014 to +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649channel ORA_DISK_1: restoring datafile 00015 to +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609channel ORA_DISK_1: reading from backup piece +TEST/rman_backup/jy_979425723_20171211_0osls830_1_1channel ORA_DISK_1: piece handle=+TEST/rman_backup/jy_979425723_20171211_0osls830_1_1 tag=TAG20171211T164446channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:35channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00016 to +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409channel ORA_DISK_1: restoring datafile 00017 to +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409channel ORA_DISK_1: restoring datafile 00018 to +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409channel ORA_DISK_1: restoring datafile 00019 to +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409channel ORA_DISK_1: restoring datafile 00020 to +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409channel ORA_DISK_1: restoring datafile 00021 to +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409channel ORA_DISK_1: reading from backup piece +TEST/rman_backup/jy_979425723_20171211_0psls843_1_1channel ORA_DISK_1: piece handle=+TEST/rman_backup/jy_979425723_20171211_0psls843_1_1 tag=TAG20171211T164446channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:36Finished restore at 11-DEC-17RMAN> recover pluggable database jypdb,testpdb;Starting recover at 11-DEC-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=2279 instance=jy1 device type=DISKstarting media recoverymedia recovery complete, elapsed time: 00:00:02Finished recover at 11-DEC-17
5.open PDB(jypdb,testpdb)
SQL> alter pluggable database jypdb,testpdb open;Pluggable database altered.SQL> select name,open_mode from v$pdbs;NAME OPEN_MODE-------------------------------------------------------------------------------------------------------------------------------- ----------PDB$SEED READ ONLYJYPDB READ WRITETESTPDB
命令
多个
方法
单个
容器
语句
相同
数据
数据库
权限
状态
用户
类型
设备
通道
面的
影响
配置
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
jdbc怎么对数据库更新
计算机网络技术学就业
金利谱网络安全
网络技术基础知识视频
极睿管理服务器
服务器维修哪个质量好
香港免费云服务器
数据库中怎么储存文章
网络储存服务器属于设备还是软件
湖北软件开发价格表
关注网络安全的英文
网络安全网址检测
普陀区工程软件开发销售厂
网络安全大赛搜了战队
服务器内存条参数
oracle 查询没数据库
网络技术论文选题
目前有哪些著名的网络安全技术
软件开发服务提供商
外国小伙成立网络安全公司
大手互联网网络科技
数据库怎么防止并发更新
aspen中怎么选择数据库
怎么打开服务器建立安全连接
网络技术求职意愿
服务器开启端口
无锡java软件开发培训
网络安全教育课视频高清
网络安全设计环境
建湖缀赂网络技术有限公司