-
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!!
-
your shared pool isnt big enough
-
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!!
-
no, you set the shared memory settings.
You need to increase the shared pool database parameter
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|