OraFAQ Forum: Server Administration » Block change tracking in standby database

Home » RDBMS Server » Server Administration » Block change tracking in standby database (Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Block change tracking in standby database [message #666333]

Mon, 30 October 2017 07:18

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.

Report message to a moderator

Re: Block change tracking in standby database [message #666334 is a reply to message #666333]

Mon, 30 October 2017 07:29

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What release of Oracle?

Report message to a moderator

Re: Block change tracking in standby database [message #666335 is a reply to message #666334]

Mon, 30 October 2017 07:39

SamuelJk
Messages: 25
Registered: August 2007

Junior Member

Oracle 11.2.0.4

Report message to a moderator

Re: Block change tracking in standby database [message #666336 is a reply to message #666335]

Mon, 30 October 2017 08:07

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

On the standby, what does the following yield?

SQL> select * from  v$block_change_tracking;

Report message to a moderator

Re: Block change tracking in standby database [message #666344 is a reply to message #666333]

Mon, 30 October 2017 09:34

John Watson
Messages: 9005
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?

Report message to a moderator

Previous Topic:	How to delete all data from the database
Next Topic:	LRM-00101: unknown parameter name 'target'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 25 08:23:57 CDT 2026