4 Replies Latest reply: Feb 5, 2010 11:18 PM by Anand... RSS

    RMAN BCT file

    138002
      Hi,
      I have oracle 10g running on HP-UX with ASM. I relocated my bct file by issuing ALTER DATABASE DISABLE BLOCK CHANGE TRACKING; followed by ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/newlocation.dbf';

      My question is if i restart my database how RMAN will know about the new BCT file location? Is there any init.ora parameter that i need to use?
      Thanks
        • 1. Re: RMAN BCT file
          637286
          That information is stored in v$block_change_tracking.
          • 2. Re: RMAN BCT file
            Aman....
            No there is no init parameter that I can think of which is used by Oracle to remember the location. Once the file is created and is enabled, the location is stored in the control file I guess and oracle remembers it.

            HTH
            Aman....
            • 3. Re: RMAN BCT file
              Anand...
              Hi,

              As Aman has said "location is stored in the control file I guess and oracle remembers it." is true.
              10:38:13 SYS @ oracle >SELECT filename, status, bytes
              10:38:14   2  FROM v$block_change_tracking;
              
              FILENAME                       STATUS          BYTES
              ------------------------------ ---------- ----------
                                             DISABLED
              
              Elapsed: 00:00:00.01
              10:38:19 SYS @ oracle >
              10:38:19 SYS @ oracle >
              10:38:20 SYS @ oracle >
              10:38:20 SYS @ oracle >
              10:38:20 SYS @ oracle >ALTER DATABASE  ENABLE BLOCK CHANGE TRACKING
              10:38:30   2  USING FILE 'D:\oracle\product\10.2.0\oracle\blk_chg.log';
              
              Database altered.
              
              Elapsed: 00:00:02.17
              10:39:02 SYS @ oracle >SELECT filename, status, bytes
              10:39:20   2  FROM v$block_change_tracking;
              
              FILENAME                                      STATUS          BYTES
              ------------------------------                        ----------       ----------
              D:\ORACLE\PRODUCT\10.2.0\ORACL ENABLED      11599872
              E\BLK_CHG.LOG
              
              
              Elapsed: 00:00:00.06
              10:39:21 SYS @ oracle >
              10:39:22 SYS @ oracle >
              10:39:22 SYS @ oracle >alter database backup controlfile to trace;
              
              Database altered.
              
              Elapsed: 00:00:00.42
              
              Controlfile content:-
              -- or if the last shutdown was not normal or immediate.
              RECOVER DATABASE USING BACKUP CONTROLFILE
              *-- Block change tracking was enabled, so re-enable it now.*
              *ALTER DATABASE ENABLE BLOCK CHANGE TRACKING*
              *USING FILE 'D:\ORACLE\PRODUCT\10.2.0\ORACLE\BLK_CHG.LOG' REUSE;*
              *-- Set Database Guard and/or Supplemental Logging*
              
              10:39:35 SYS @ oracle >ALTER DATABASE DISABLE BLOCK CHANGE TRACKING; 
              
              Database altered.
              
              Elapsed: 00:00:00.20
              10:39:22 SYS @ oracle >alter database backup controlfile to trace;
              
              Database altered.
              
              Elapsed: 00:00:00.42
              
              Controlfile content:-
              -- re-create incarnation records.
              -- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ORACLE\ORACLE_ARCH_1_649363582_1';
              -- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ORACLE\ORACLE_ARCH_1_701523840_1';
              -- Recovery is required if any of the datafiles are restored backups,
              -- or if the last shutdown was not normal or immediate.
              RECOVER DATABASE USING BACKUP CONTROLFILE
              -- Set Database Guard and/or Supplemental Logging
              
              I Change the location of the block change tracker:-
              
              10:46:06 SYS @ oracle >SELECT filename, status, bytes
              10:46:13   2  FROM v$block_change_tracking;
              
              FILENAME                                           STATUS          BYTES
              -------------------------------------------------- ---------- ----------
                                                                 DISABLED
              
              Elapsed: 00:00:00.06
              10:46:13 SYS @ oracle >ALTER DATABASE  ENABLE BLOCK CHANGE TRACKING
              10:46:21   2  USING FILE 'D:\oracle\product\10.2.0\oracle_blk_chg.log';
              
              Database altered.
              
              Elapsed: 00:00:01.45
              10:46:46 SYS @ oracle >SELECT filename, status, bytes FROM v$block_change_tracking;
              
              FILENAME                                           STATUS          BYTES
              -------------------------------------------------- ---------- ----------
              D:\ORACLE\PRODUCT\10.2.0\ORACLE_BLK_CHG.LOG        ENABLED      11599872
              
              Elapsed: 00:00:00.07
              10:46:55 SYS @ oracle >
              10:47:07 SYS @ oracle >alter database backup controlfile to trace;
              
              Database altered.
              
              Elapsed: 00:00:00.26
              
              Control file Content:-
              -- re-create incarnation records.
              -- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ORACLE\ORACLE_ARCH_1_649363582_1';
              -- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\PRODUCT\10.2.0\ARCHIVE\ORACLE\ORACLE_ARCH_1_701523840_1';
              -- Recovery is required if any of the datafiles are restored backups,
              -- or if the last shutdown was not normal or immediate.
              RECOVER DATABASE
              *-- Block change tracking was enabled, so re-enable it now.*
              *ALTER DATABASE ENABLE BLOCK CHANGE TRACKING*
              *USING FILE 'D:\ORACLE\PRODUCT\10.2.0\ORACLE_BLK_CHG.LOG' REUSE;*
              *-- Set Database Guard and/or Supplemental Logging*
              HTH
              Anand
              • 4. Re: RMAN BCT file
                138002
                Thank you all, that was helpful