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
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.
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
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.
answered 23 Jun '10, 13:08