Home » RDBMS Server » Backup & Recovery » alter database enable block change tracking (oracle 10.2.0.4)
alter database enable block change tracking [message #438943] Wed, 13 January 2010 03:06 Go to next message
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 Go to previous messageGo to next message
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 #438955 is a reply to message #438954] Wed, 13 January 2010 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From Reference manual:

Quote:
TRANSITION - Block change tracking is in the process of transitioning between the enabled and disabled states. The TRANSITION state should usually never be observed, because it only exists while enabling or disabling block change tracking. This state might be observed if the instance crashed while enabling or disabling block change tracking, in which case it will be cleaned up automatically the next time that the database is opened.

I think that changing the file is like an instance crash for it and it recovers the information in the previous file to the new one (just my opinion).
You can activate Oracle trace on the current session and maybe truss/tusc os trace on CTWR process to know what they are doing.

Regards
Michel
Re: alter database enable block change tracking [message #438958 is a reply to message #438943] Wed, 13 January 2010 03:50 Go to previous messageGo to next message
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,
Re: alter database enable block change tracking [message #438967 is a reply to message #438958] Wed, 13 January 2010 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you say it goes from "+data/dbs/db.pct" to "+DATA/rfsodsp/CHANGETRACKING/rfsodsp.bct" without you to change the name?

Regards
Michel

icon10.gif  Re: alter database enable block change tracking [message #439294 is a reply to message #438955] Fri, 15 January 2010 09:32 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Clould it be because it's trying to transition from shared storage (+ASM) to local storage file '/dba/apps/db.bct'?

Just a thought...
Razz

Re: alter database enable block change tracking [message #439298 is a reply to message #439294] Fri, 15 January 2010 09:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It could be, I'm waiting for an answer to my previous question before investigating other points.

By the way, ora_2007, do you have any feedback? Does your problem solve? Do you have an explication?

Regards
Michel
icon5.gif  Re: alter database enable block change tracking [message #439331 is a reply to message #439298] Fri, 15 January 2010 12:21 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Michel Cadot wrote on Fri, 15 January 2010 10:37

By the way, ora_2007, do you have any feedback? Does your problem solve? Do you have an explication?

ora_2007?

Re: alter database enable block change tracking [message #439336 is a reply to message #439331] Fri, 15 January 2010 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, ora_2007 is OP, don't you see it? my last paragraph was for him.

Regards
Michel
Re: alter database enable block change tracking [message #439495 is a reply to message #439336] Sun, 17 January 2010 22:17 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
But as you replied to #msg_439294..Which is
LKBrwn_DBA `s message...

sriram Wink
Re: alter database enable block change tracking [message #439509 is a reply to message #439495] Mon, 18 January 2010 00:02 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes because my first paragraph was for LKBrwn_DBA.
It seems obvious to me.

Regards
Michel

[Updated on: Mon, 18 January 2010 00:02]

Report message to a moderator

Previous Topic: Help using RMAN to do a simple backup
Next Topic: RMAN backup not backing up archivelog after database backup
Goto Forum:
  


Current Time: Thu Dec 08 01:53:39 CST 2016

Total time taken to generate the page: 0.31696 seconds