Home » RDBMS Server » Backup & Recovery » issue with disabling block chnage tracking (oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM)
issue with disabling block chnage tracking [message #680344] Fri, 08 May 2020 06:31 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
Hi,

I want to disable block change tracking and applied the following
alter database disable block change tracking;
now after 30 mins, it is like a hang status and no SQL prompt

my database size is 7.7TB?

someone can help why it is so? is it normal?

Regards
Re: issue with disabling block chnage tracking [message #680345 is a reply to message #680344] Fri, 08 May 2020 07:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What clues exist in alert_SID.log file?
Re: issue with disabling block chnage tracking [message #680346 is a reply to message #680344] Fri, 08 May 2020 07:45 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Better see if it is hanging. For example:
select u.osuser,u.machine,u.program,u.username,u.sid,u.event,u.seconds_in_wait secs,sql_text sql
from v$session u join v$sql using (sql_id)
where u.wait_class <> 'Idle' and u.wait_time=0
Re: issue with disabling block chnage tracking [message #680378 is a reply to message #680345] Sat, 09 May 2020 12:51 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
No clues it saying nothing abnormal . i think it is normal that it would take that much time , i guess, any how i kill the alter database wit ctl+C but still the SQL prompt is not rescued i have opened another window of SQL and when i check the status of block_change_tracking so it says ENABLED. please any clues
Previous Topic: Apply different policy on the same database
Next Topic: Using Rubrik to back Oracle DBs
Goto Forum:
  


Current Time: Thu Mar 28 10:31:56 CDT 2024