Home » RDBMS Server » Server Administration » Block change tracking in standby database (Solaris)
Block change tracking in standby database [message #666333] Mon, 30 October 2017 07:18 Go to next message
SamuelJk
Messages: 19
Registered: August 2007
Junior Member
Hi all,

Block change tracking is enabled in Primary database and in standby it is disabled. But standby block change tracking file size keep on increasing

How to avoid this ?

Thanks
Samuel.
Re: Block change tracking in standby database [message #666334 is a reply to message #666333] Mon, 30 October 2017 07:29 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
What release of Oracle?
Re: Block change tracking in standby database [message #666335 is a reply to message #666334] Mon, 30 October 2017 07:39 Go to previous messageGo to next message
SamuelJk
Messages: 19
Registered: August 2007
Junior Member
Oracle 11.2.0.4
Re: Block change tracking in standby database [message #666336 is a reply to message #666335] Mon, 30 October 2017 08:07 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
On the standby, what does the following yield?
SQL> select * from  v$block_change_tracking;
Re: Block change tracking in standby database [message #666344 is a reply to message #666333] Mon, 30 October 2017 09:34 Go to previous message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Fast incremental backups do require licensing Active Data Guard. I haven't tested, but perhaps you need to open the standby for it to work properly. Have you done that?
Previous Topic: I need to create 2 tables for below data how to map between the data values
Next Topic: LRM-00101: unknown parameter name 'target'
Goto Forum:
  


Current Time: Fri Nov 24 12:46:45 CST 2017

Total time taken to generate the page: 0.24641 seconds