block_change_tracking change [message #581233] |
Wed, 03 April 2013 12:35 |
|
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 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
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 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|