OraFAQ Forum: Backup & Recovery » alter database enable block change tracking

Home » RDBMS Server » Backup & Recovery » alter database enable block change tracking (oracle 10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 #438955 is a reply to message #438954]

Wed, 13 January 2010 03:37

Michel Cadot
Messages: 68641
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

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,

Report message to a moderator

Re: alter database enable block change tracking [message #438967 is a reply to message #438958]

Wed, 13 January 2010 04:41

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: alter database enable block change tracking [message #439294 is a reply to message #438955]

Fri, 15 January 2010 09:32

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

Report message to a moderator

Re: alter database enable block change tracking [message #439298 is a reply to message #439294]

Fri, 15 January 2010 09:37

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: alter database enable block change tracking [message #439331 is a reply to message #439298]

Fri, 15 January 2010 12:21

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?

Report message to a moderator

Re: alter database enable block change tracking [message #439336 is a reply to message #439331]

Fri, 15 January 2010 12:43

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: alter database enable block change tracking [message #439495 is a reply to message #439336]

Sun, 17 January 2010 22:17

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

But as you replied to #msg_439294..Which is
LKBrwn_DBA `s message...

sriram Wink

Report message to a moderator

Re: alter database enable block change tracking [message #439509 is a reply to message #439495]

Mon, 18 January 2010 00:02

Michel Cadot
Messages: 68641
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 07:47:27 CDT 2024