error message create db mirror

Hi there,

i am new to SQL Anywhere and i hope you can help me:

we are using SQL Anywhere 12.0 und try to setup a test mirroring (see Sybase/SAP tutorial). When i want to define the primary and secondary server, i get following error message:

"The database mirroring options are not supported for this database"... SQLCODE= -1307, ODBC 3 state = HY000

Can somebody tell me what does it mean? I can't find more information in the internet.

Thanks and best regards from germany Sabrina

mirroring error

asked 26 Feb '15, 04:05

sabstar
76●5●5●9
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

The docs do tell the following for that error message:

The current database does not have catalog support for database mirroring servers and options. To use this feature, upgrade your database to the most recent version.

So I would conclude that you are using v12 but the database has been created with an earlier version and therefore has to be upgraded (via DBUPGRAD) or - better - reloaded.

You can use "select * from syshistory" to find out about the database file version.

permanent link

answered 26 Feb '15, 04:52

Volker Barth
40.2k●361●550●822
accept rate: 34%

edited 26 Feb '15, 04:52

Thanks for your answer!

I used your query and got 3 rows:

Operation Version INIT 11.0.1.2044 LAST_START 12.0.0.2483 START 12.0.0.2483

Does it mean, that my db is allready runnig as v12? How do i use DBUGRAD?

Thanks and regards, Sabrina

(26 Feb '15, 05:00) sabstar

Replies hidden

Found it : http://dcx.sap.com/index.html#1200/en/dbadmin/dbupgrad.html

(26 Feb '15, 05:05) sabstar

The INIT row does tell the database has been created with v11 and has not been upgraded since.

Note: Both v11.0.2044 and 12.0.0.2483 are very old builds of v11 and v12 (the original GA releases, IIRC) so you are missing hundreds of bug fixes and enhancements. When doing tests I would very stronlgy recommend to use a new build of v12.0.1 (or v16), and particulary for tests with mirroring.

Furthermore, I would also recommend to do a full reload with the newest version instead of DBUPGRAD.

(26 Feb '15, 06:19) Volker Barth

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

error ×95
mirroring ×32

question asked: 26 Feb '15, 04:05

question was seen: 1,572 times

last updated: 26 Feb '15, 06:33

SAP SQL Anywhere

error message create db mirror

Follow this question

Related questions