ORA-19760: error starting change tracking
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-19760: error starting change tracking

  1. #1
    Join Date
    Aug 2002
    Posts
    56

    ORA-19760: error starting change tracking

    Hi All,
    I am using 10g R2 (64 bit) on Solaris 10 Sparc server with 24gig memory. The database is in archivelog mode and I am implementing RMAN on it. I wanted to use the new block tracking feature of RMAN and when I run the following command:-

    alter database enable block change tracking using file '/oradump01/orcl/rman/track/btf.dbf';

    I get this error:-
    ERROR at line 1:
    ORA-19760: error starting change tracking

    On checking the alert log file I get the following message:

    alter database enable block change tracking using file '/oradump01/orcl/rman/track/btf.dbf'
    Thu Apr 6 13:26:27 2006
    Block change tracking file is current.
    Starting background process CTWR
    CTWR started with pid=18, OS id=22233
    Thu Apr 6 13:26:33 2006
    Errors in file /orahome/admin/orcl/bdump/orcl_ctwr_22233.trc:
    ORA-04031: unable to allocate 15613832 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","CTWR dba buffer")
    Block change tracking service stopping.
    Thu Apr 6 13:26:33 2006
    Stopping background process CTWR
    ORA-19760 signalled during: alter database enable block change tracking using file '/oradump01/orcl/rman/track/btf.dbf'...
    Deleted file /oradump01/orcl/rman/track/btf.dbf


    The shared memory setting for the server is :
    set shmsys:shminfo_shmmax=0xffffffff --Maximum available
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmseg=50

    Any suggestions would be helpful.

    Thanks,
    Sandeep
    When in doubt ...go to the basics!!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your shared pool isnt big enough

  3. #3
    Join Date
    Aug 2002
    Posts
    56
    But it has been set for maximum use by oracle with the 0xffffffff setting. Would this be a problem for block change tracking?
    When in doubt ...go to the basics!!

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, you set the shared memory settings.

    You need to increase the shared pool database parameter

  5. #5
    Join Date
    Dec 2009
    Posts
    1

    Increase specifically the large pool....

    just increasing the shared pool didn't do it for me. Increasing specifically the large pool did. Good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width