ブロックトレースの簡単な操作

文書ディレクトリ

概要

1.クエリステータス

2.オープン

3.パスの変更

3.1 mount状態でrename

3.2 open状態で

を再開

概要
ブロックトレースはデフォルトで無効です.インクリメンタルバックアップが有効な場合は、ブロックトレースをオンにすることをお勧めします.ブロックトラッキングファイルのサイズは、データファイルの数に関係しますが、いずれも小さいです.
1.問合せステータス

SYS@regan> select * from v$block_change_tracking;

STATUS     FILENAME                                      BYTES     CON_ID
---------- ---------------------------------------- ---------- ----------
DISABLED

2.オープン

SYS@regan> alter database enable block change tracking using file '/u01/rman/track.log';

Database altered.

SYS@regan> select * from v$block_change_tracking;

STATUS     FILENAME                                      BYTES     CON_ID
---------- ---------------------------------------- ---------- ----------
ENABLED    /u01/rman/track.log                        11599872          0

SYS@regan> !ls -l /u01/rman/track.log
-rw-r-----. 1 oracle oinstall 11600384 Aug  7 14:02 /u01/rman/track.log

3.パスの変更
3.1 mount状態でのrename

SYS@regan> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@regan> !mv /u01/rman/track.log /u01/rman/trc.log

SYS@regan> !ls -l /u01/rman/
total 11332
-rw-r-----. 1 oracle oinstall 11600384 Aug  7 14:10 trc.log

SYS@regan> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2483025656 bytes
Fixed Size                  8660728 bytes
Variable Size             671088640 bytes
Database Buffers         1795162112 bytes
Redo Buffers                8114176 bytes
Database mounted.
SYS@regan> select * from v$block_change_tracking;
select * from v$block_change_tracking
              *
ERROR at line 1:
ORA-19755: could not open change tracking file
ORA-19750: change tracking file: '/u01/rman/track.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

SYS@regan> alter database open;
--            ，           ，       。           。          ，            。
Database altered.

SYS@regan> select * from v$block_change_tracking;

STATUS     FILENAME                                      BYTES     CON_ID
---------- ---------------------------------------- ---------- ----------
ENABLED    /u01/rman/track.log                        11599872          0

SYS@regan> !ls -l /u01/rman/
total 22664
-rw-r-----. 1 oracle oinstall 11600384 Aug  7 14:12 track.log
-rw-r-----. 1 oracle oinstall 11600384 Aug  7 14:10 trc.log

SYS@regan> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@regan> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2483025656 bytes
Fixed Size                  8660728 bytes
Variable Size             671088640 bytes
Database Buffers         1795162112 bytes
Redo Buffers                8114176 bytes
Database mounted.
SYS@regan> !rm /u01/rman/trc.log

次のパス変更操作を再開します.

SYS@regan> !mv /u01/rman/track.log /u01/rman/trc.log

SYS@regan> alter database rename file '/u01/rman/track.log' to '/u01/rman/trc.log';

Database altered.

SYS@regan> select * from v$block_change_tracking;

STATUS     FILENAME                                      BYTES     CON_ID
---------- ---------------------------------------- ---------- ----------
ENABLED    /u01/rman/trc.log                          11599872          0

SYS@regan> alter database open;

Database altered.

SYS@regan> !ls -l /u01/rman
total 11332
-rw-r-----. 1 oracle oinstall 11600384 Aug  7 14:15 trc.log

3.2 open状態で再開

SYS@regan> alter database disable block change tracking;

Database altered.

SYS@regan> alter database enable block change tracking using file '/u01/rman/track.log';

Database altered.

SYS@regan> select * from v$block_change_tracking;

STATUS     FILENAME                                      BYTES     CON_ID
---------- ---------------------------------------- ---------- ----------
ENABLED    /u01/rman/track.log                        11599872          0

SYS@regan> !ls -l /u01/rman
total 11332
-rw-r-----. 1 oracle oinstall 11600384 Aug  7 14:21 track.log