使用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安全错误
数据库的锁怎样保障安全
本地访问远程服务器
数据库grant使用方法
rbc服务器出错
禄劝软件开发厂家价格
河北地理信息软件开发
学软件开发的五年大专学费
述评网络安全需要生态治理吗
技术服务合同与软件开发
软件开发哪一行吃香
hbase分布式数据库爬虫
蚌埠市网络安全与信息化
大岳咨询ppp数据库
问卷软件开发的可行性分析
致爱网络技术上市
嘉定区数据软件开发诚信服务
开通网络安全策略
互联网科技知识竞赛题库
控制网络技术基础课后题
外汇第三方软件开发
山东仓库管理软件开发
永州电子仓库软件开发
正是因为网络技术新应用
服务器可以连接多少个路由器
为什么数据库服务启动不了
华为服务器无法识别固态硬盘
课程数据库建表代码
2020网络安全风险
广州智能软件开发服务
服务器有没有自动运行程序
战斗吧剑灵怎么增加服务器