Oracle 19.3 dataguard环境下同步新增pdb
备库相关的pdb_test01文件为offline状态,该pdb为mounted状
备份新增pdb(主库端执行)
BACKUP as compressed backupset incremental level 0 PLUGGABLE DATABASE pdbXXXX;
使备库待恢复pdb_test01处于disable recovery状态,不影响现有备库其他pdb进行mgr日志应用(备库端执行)
alter PLUGGABLE DATABASE pdb_test01 disable recovery;
SELECT name, open_mode, recovery_status FROM v$pdbs
备库执行单个pdb恢复(备库端执行),数据库恢复操作:
catalog start with '/backup‘;
restore PLUGGABLE DATABASE pdbXXXX;
恢复完执行新增同步pdb enable recover
SELECT name, open_mode, recovery_status FROM v$pdbs;
alter session set container=pdb_test01
alter pluggable database pdb_test01 enable recovery;
alter database recover managed standby database using current logfile disconnect from session;
- 点赞
- 收藏
- 关注作者
评论(0)