Here is the common error you see when you enable it:
SQL> alter database enable block change tracking;
alter database enable block change tracking
ERROR at line 1:
ORA-19773: must specify change tracking file name
The error is due to we need set both db_create_file_dest
If not,
alter system set db_create_file_dest='+DATA' scope=both sid='*';
or manually use location:
alter database enable block change tracking using file 'location';
All these parameters are dynamic, no need to bounce DB
No comments:
Post a Comment