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
Increase specifically the large pool....
just increasing the shared pool didn't do it for me. Increasing specifically the large pool did. Good luck!