SHOW PARAMETER DB_CREATE_FILE_DEST File will create here --To Enable : ALTER DATABASE ENABLE BLOCK CHANGE TRACKING ; --To check col filename for a70 select filename,status from v$block_change_tracking; ==== --to disable: alter database disable block change tracking; --To check col filename for a70 select filename,status from v$block_change_tracking; or set linesize 400 col FILENAME for a70 col NAME for a15 col BCT_STATUS for a15 col MB for 99999.99 select inst_id, dbid, name, db_unique_name, open_mode, log_mode, flashback_on, switchover_status, database_role,CONTROLFILE_TYPE,filename, BCT_STATUS, bytes/1024/1024 MB from (select inst_id, dbid, name, db_unique_name, open_mode, log_mode, flashback_on, switchover_status, database_role,CONTROLFILE_TYPE from gv$database), (select filename, status BCT_STATUS, bytes from v$block_change_tracking) ;
Search This Blog
Total Pageviews
Tuesday, 12 December 2023
How to Enable Oracle Change Tracking (BCT)?
How to Enable Oracle Change Tracking (BCT)?
===
Subscribe to:
Posts (Atom)
Oracle DBA
anuj blog Archive
- ► 2011 (362)