bounce db 并解决restricted mode的问题

???? 7月前 634

https://kkdba.com/dbbp-bundle-patch-installed-in-the-cdb-but-not-in-the-pdb.html

Bounce database

在cdb模式下: alter pluggable database HRUPGUAT close immediate instances=all;

alter pluggable database HRUPGUAT OPEN instances=all;

但执行两个query后,pdb HRUPGUAT 是restricted mode,查询alert_log: select value from v$diag_info;

从alert_log中发现error在pdb_plug_in_violations中:

select time, name, cause, type, action, message from pdb_plug_in_violations where status<>'RESOLVED';

发现是过去patching没有完全patch成功,但可以用以下code来取消restricted 1.在 pdb下:shutdown immediate 2.在 cdb下:alter pluggable database all save state 3.在 pdb下:alter database open 4.在 cdb下:alter plugable database all save state

这样就可以解除restricted

This command will take the current state of the PDB and preserve that mode after the CDB is restarted.

Saved State is a feature in 12.1. 0.2 for saved the OPEN state of all PDBS when CDB is restart. It will bring PDBs to same state if it open then it bring the PDB in Open State or if PDB is closed when CDB restart then it bring PDB in closed state.

最后于 7月前 被????编辑 ,原因:
最新回复 (1)
返回
发新帖