First, confirm that the operating system process is running:
$ ps -ef | grep FBDA
oracle 18199 8264 0 13:22:12 pts/5 0:00 grep FBDA
--> The background proceess FBDA is running in the background
Check the setting
sqlplus / as sysdba:
select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and substr(ksppinm,1,1)='_' and ksppinm like '%archiver%' order by a.ksppinm; Parameter Session Value Instance Value ----------------------------------- --------------- -------------- _disable_flashback_archiver 0 0 _flashback_archiver_partition_size 0 0by setting the parameter _disable_flashback_archiver and restarting your instance, you disable the flashback archiver process:
alter system set "_disable_flashback_archiver"=1 scope=spfile;
No comments:
Post a Comment