{Data Guardの実装その他}欠落した書き込みを検証するように初期化パラメータを設定

 

https://docs.oracle.com/cd/F19136_01/sbydb/examples-of-using-oracle-data-guard.html#GUID-8F4E7807-6013-480F-8780-088F5639732F

show parameter ultra
show parameter DB_LOST_WRITE_PROTECT

alter system set db_ultra_safe='DATA_AND_INDEX' scope=spfile sid='*' ;

shutdown immediate;
startup

 

declare
  Datafile_Name_or_Number varchar2(1000);
  Output_File varchar2(1000);
begin
  dbms_output.enable(1000000);
  Datafile_Name_or_Number:= 'all' ;
  Output_File:='BlockCompareAll_';
  sys.dbms_dbcomp.DBCOMP(Datafile_Name_or_Number, Output_File, true);
end;
/