| alter database enable block change tracking [message #438943] |
Wed, 13 January 2010 03:06  |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
Hi,
I want to enable block tracking for RMAN.
Previously it was set at +data/dbs/db.pct
then i disabled block change tracking with below command.
alter database disable block change tracking;
I am trying with below statement.
alter database enable block change tracking using file '/dba/apps/db.bct';
But is it running from 2 hurs.
Normally it executed within a second.
How i can troubleshoot it?
Thanks,
[Updated on: Wed, 13 January 2010 03:15] Report message to a moderator |
|
|
|
| Re: alter database enable block change tracking [message #438954 is a reply to message #438943] |
Wed, 13 January 2010 03:31  |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
--------------------------------------------------------------------------------
DB Version - Oracle 10.2.0.4
Environment - RAC
OS - AIX
OS Version - 5.3
--------------------------------------------------------------------------------
What is the session waiting for?
Executed below statement.
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/orabin/apps/oracle/product/dbs10.2.0/dbs/rfsodsp.bct'
--------------------------------------------------------------------------------
Are there any information in your alert.log?
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/orabin/apps/oracle/product/dbs10.2.0/dbs/rfsodsp.bct'
Wed Jan 13 03:56:23 2010
Block change tracking file is current.
Wed Jan 13 03:56:23 2010
Starting background process CTWR
CTWR started with pid=46, OS id=1286298
Block change tracking service is active.
--------------------------------------------------------------------------------
SQL> select * from v$block_change_tracking;
STATUS FILENAME BYTES
TRANSITION /orabin/apps/oracle/product/dbs10.2.0/dbs/rfsodsp.bct
Please let know if other information is required.
Thanks,
[Updated on: Wed, 13 January 2010 03:33] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: alter database enable block change tracking [message #438958 is a reply to message #438943] |
Wed, 13 January 2010 03:50 |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
One strange thing i observerd..
I killed my session having statement...........
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/orabin/apps/oracle/product/dbs10.2.0/dbs/rfsodsp.bct'
Then just executed alter database enable block without file option.......
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
And it works....................
SQL> select * from v$block_change_tracking;
STATUS FILENAME BYTES
--------------------------------------------------------------------------------
ENABLED +DATA/rfsodsp/CHANGETRACKING/rfsodsp.bct 11020233
How is it working withiout using file option?
Thanks,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
