Upgrading a 11.1.0.6 database which is part of Data Guard environment to
11.1.0.7 using dbua.
The log_archive_dest parameters are written on more than one line in the
11.1.0.6 database parameter file, for example.,
log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=testp"
log_archive_dest_2 = "SERVICE=p9secs ASYNC COMPRESSION=ENABLE
VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)
DB_UNIQUE_NAME=tests"
While upgrading to 11.1.0.7 using DBUA, these parameters are truncated to a
single line as below
log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST"
log_archive_dest_2 = "SERVICE=p9secs ASYNC COMPRESSION=ENABLE"
Since the init parameters are truncated by dbua, this has caused problems
with the rolling upgrade in the data guard environment for the customer
Bug: Bug 8225933: DBUA TRUNCATES INITIALIZATION PARAMETER(S)
1 comment:
I've already bookmark this article and will definitely refer this article to all my close friends and colleagues. Thanks for posting!
Post a Comment