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: 25
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: 1118
Registered: November 2010
Location: Bedwas, 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: 25
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: 1118
Registered: November 2010
Location: Bedwas, 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: 8922
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: How to delete all data from the database
Next Topic: LRM-00101: unknown parameter name 'target'
Goto Forum:
  


Current Time: Thu Mar 28 17:13:48 CDT 2024