block_change_tracking change [message #581233] |
Wed, 03 April 2013 12:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c7eadf3c842233b8f87a8a06ff898d16?s=64&d=mm&r=g) |
gatetec
Messages: 38 Registered: December 2012
|
Member |
|
|
SELECT filename, status, bytes
FROM v$block_change_tracking;
DISABLED
If we turn on block_change_tracking with RMAN, will it require a downtime?
|
|
|
|
|
|
|
|
|
Re: block_change_tracking change [message #581263 is a reply to message #581260] |
Wed, 03 April 2013 14:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:I have set it as IMMEDIATE.
No you have not, you can't, this is a hard-coded value which indicates what you can do with the parameter in ALTER SYSTEM command.
Quote:ould not require a reboot of instance to take effect?
What does the documentation say when the value returned by the previous query is immediate?
Regards
Michel
[Updated on: Wed, 03 April 2013 14:21] Report message to a moderator
|
|
|
|
|
Re: block_change_tracking change [message #581309 is a reply to message #581269] |
Thu, 04 April 2013 06:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:scope=spfile
I have the answer, if you modify in spfile ONLY then a reboot is needed.
If you want this to be taken immediately then use scope=MEMORY or scope=BOTH.
Regards
Michel
|
|
|