Dbvisit Community http://www.dbvisit.com/forums/ Dbvisit Community - Oracle Standby Database. Disaster Recovery en Sun, 19 May 2013 09:40:59 GMT vBulletin 60 http://www.dbvisit.com/forums/images/misc/rss.jpg Dbvisit Community http://www.dbvisit.com/forums/ Dbvisit Replicate and Reporting 2.4.26 released http://www.dbvisit.com/forums/showthread.php?t=1591&goto=newpost Thu, 16 May 2013 21:09:15 GMT Dbvisit Replicate and Reporting version 2.4.26 released 1. Fix LIST STATS for mysql target 2. OFF for notification time would evaluate as... Dbvisit Replicate and Reporting version 2.4.26 released
  1. Fix LIST STATS for mysql target
  2. OFF for notification time would evaluate as midnight
  3. No support package for simple db connectivity errors
  4. Small fixes in the test emials sent by NOTIFY SENDQ
  5. Changed logo in notification emails
  6. Fix: obsolete redologs were not deleted by mine (fetcher in use)
  7. Fix: improve mine speed in case of large history of DDL changes
  8. Support TRUNCATE for mysql and MS SQL
]]> Dbvisit Announcements Arjen Visser http://www.dbvisit.com/forums/showthread.php?t=1591 Dbvisit Replicate and Reporting 2.4.24 released http://www.dbvisit.com/forums/showthread.php?t=1590&goto=newpost Wed, 08 May 2013 23:17:59 GMT *2.4.24 (9 May 2013)* 1. Fix crash due to incorrect parse of index operation (kdxbur 2. Fix numbering of columns in supplemntal logging for LOB... 2.4.24 (9 May 2013)
  1. Fix crash due to incorrect parse of index operation (kdxbur
  2. Fix numbering of columns in supplemntal logging for LOB operations
  3. Improve speed for non-replicated partitioned tables
  4. SHOW now displays a message when no such variable exists
  5. Add current threshold to notification emails for time differenc
  6. Fix: added SNMP trap for time difference
  7. Improve error messaging when the operation fails (change text for OK-0)
  8. Fix some cases when crash would create two support packages instead of one
  9. Fix: auditing information could contain excess binary characters
  10. Remove [] non-described tables from list progress, use list progress (not all) in daily progress
  11. Fix: PL/SQL would see only first column of primary key
  12. Fix: IOT: distinguish between key and other columns
  13. Fix: advance SCN even when some of RAC threads are idle
  14. Fix: crash during ENGINE LOCK run from console
  15. Fix: check RBA limits properly on restart (even pre-start SCN)
  16. Fix: log packaging sometimes failed with fetcher configuration
  17. Fix: WAN/LAN setting in the setup wizard was ignored
  18. Fix: allow OFF for time values
  19. Fix: memory usage for big-endian (signature merging)

Download from http://www.dbvisit.com/products/downloads ]]> Dbvisit Announcements Arjen Visser http://www.dbvisit.com/forums/showthread.php?t=1590 Graceful Switchover fails while coping redo logs http://www.dbvisit.com/forums/showthread.php?t=1587&goto=newpost Sat, 04 May 2013 03:54:42 GMT Hi All, Switchover failed with following message. This is happening while transferring redo logs from primary database to standby database. ... Hi All,

Switchover failed with following message. This is happening while transferring redo logs from primary database to standby database.

Standby Database orcl shutdown successfully.
Waiting for Checkpoint 5 on proddb...
201305040738 - Cancelling graceful switchover. Cannot obtain checkpoint
/usr/tmp/X.dbvisit.444.orcl.lck5 key from proddb
Switchover has NOT completed successfully on drdb for checkpoint 5.

ssh has been configured and we are able to connect to servers without passwords.

Please help me to solve this issue. i have attached the trace file from the primary site.

Thank you.
Attached Files
File Type: zip 28174_dbv_oraStartStop_switchover_orcl_201305040737.zip (42.8 KB)
]]> Dbvisit Standby - Graceful Switchover gayanj http://www.dbvisit.com/forums/showthread.php?t=1587 APPLY process FATAL-9217 http://www.dbvisit.com/forums/showthread.php?t=1585&goto=newpost Tue, 30 Apr 2013 14:53:05 GMT When starting replication in target server: Initializing......done WARN-1850: No DDC DB available, dictionary table does not exist. DDC loaded... When starting replication in target server:

Initializing......done
WARN-1850: No DDC DB available, dictionary table does not exist.
DDC loaded from database (0 variables).
Dbvisit Replicate version 2.4.22.2762
Copyright (C) Dbvisit Software Limited. All rights reserved.
DDC file /var/oracle/XE-APPLY.ddc loaded.

Starting process APPLY...Created directory /var/oracle/log/trace/
Trying to create support package (base error: FATAL-9217: Unsupported process type OFF.)
Trying to create support package (base error: FATAL-9217: Unsupported process type OFF.)

Packaging into ZIP file: /var/oracle/log/trace/dbvisit_support_dbvrep_DDC_APPLY._5DR.zip for process APPLY, addinfo []

Zip file created: /var/oracle/log/trace/dbvisit_support_dbvrep_DDC_APPLY._5DR.zip (status: 1)

FATAL-9217: Unsupported process type OFF. ]]> Dbvisit Replicate - Setup dsdata http://www.dbvisit.com/forums/showthread.php?t=1585 Perl problem? :s http://www.dbvisit.com/forums/showthread.php?t=1584&goto=newpost Wed, 24 Apr 2013 09:02:17 GMT Hi Everybody,

I'm new to all this so please be gentle :)

I am getting an error saying stating the following...

201304240956 - Unable to find log file after 82 times. MAX_TIMES_TRIED (4) exceeded.
Log sequence 269417 thread 1 still not on standby site.
Dbvisit Standby terminated.
Return code = 409

I have tried to run dbvisit manually and get the following error:

Reading from filehandle failed at PERL2EXE_STORAGE/Dbv_utilityWin32.pm line 667.

Does anybody have any ideas?

This is a 10g R2 database running on Windows Server 2003 R2 64 bit.

It has been running fine previously but failed this morning at about 1:30 i think.

Any help would be much much appreciated.

Thanks,

Andy ]]> Dbvisit Standby - Technical Questions or Issues Dina0312 http://www.dbvisit.com/forums/showthread.php?t=1584