环境:
DB:12.2.0.1
1.关闭pdb
alter pluggable database pdb3 close;
2.恢复
SQL>alter session set container=cdb$root;
SQL>alter system set standby_file_management=auto;
SQL>alter database recover managed standby database cancel;
SQL>alter session set container=pdb3;
SQL>alter pluggable database disable recovery;
rman进行恢复
##tnsslnngk2 是连接到主库的tns
run{
restore pluggable database pdb3 from service tnsslnngk ;
}
3.恢复使用enable recovery
SQL> alter session set container=cdb$root;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter session set container=pdb3;
SQL> alter pluggable database enable recovery;
SQL> alter session set container=cdb$root;
SQL> alter database recover managed standby database using current logfile disconnect from session;
4.打开pdb
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect from session;
5.打开pdb
alter pluggable database pdb3 open;