The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

I'm about to upgrading an ASA 8.0.3 SQL Remote setup to SA 11.0.1 (and testwise to SA 12 RC1).

The old database uses some CREATE DATABASE options I would like to change in the new one, e.g. to turn

  • blank padding off
  • ase compatible off
  • checksum on.

As the database is involved in replication, I would like to use the easy way by DBUNLOAD -ar. However, this seems to make me unable to change the above settings as DBUNLOAD does not support to change these options - and lateron it's too late, as they must be specified at database creation time.

Question:

Do I have to use the "unload process with manual intervention", i.e. with dblog -x -z, or is there a further alternative to change these options? (Not that the manual process would not be feasible.)

asked 23 Jun '10, 09:57

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644
accept rate: 32%


You cannot change any of the database settings when using the dbunload -ar or -an switch since the new database is created (by dbunload) with the exact same attributes as the original. There are some exceptions to this rule. For example you can change the encryption of the database and the page size of the rebuilt database.

Therefore if you want to change the settings that you have listed, you must use the manual process.

permanent link

answered 23 Jun '10, 13:08

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262
accept rate: 40%

Thanks for the confirmation! In the end, this is not a real limitation in my case, as I will have to use the manual process in order to achieve further changes, e.g. naming check constraints and other stuff not possible wie ASA 8...

(23 Jun '10, 13:29) Volker Barth

By the way, in SA 12 RC1, CHECKSUM ON seems to be the default for CREATE DATABASE (which is fine to me) - in contrast to the docs. Haven't checked with 11.0.1 yet.

(23 Jun '10, 13:41) Volker Barth
1

Yes, the docs were a little behind with the s/w changes at the time we released RC1. We have decided to turn checksums on by default because there are many advantages and not a lot of disadvantages. The GA docs will have the required changes. Note also that in GA even if the database was created with CHECKSUM ON you will be able to turn checksums off by running ALTER DATABASE CHECKSUM OFF but then you will not be able to turn checksums back on without rebuilding the database.

(23 Jun '10, 13:50) Mark Culp

I welcome that change - Breck's statement that you guys tend to use sensible defaults (in my words) continues to be right:)

(23 Jun '10, 14:28) Volker Barth
Your answer
toggle preview

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

Question tags:

×73
×37
×8

question asked: 23 Jun '10, 09:57

question was seen: 1,279 times

last updated: 23 Jun '10, 13:08