| |
1, Start the Oracle instance error:
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter (s) specified for RDBMS instance
ORA-00439: feature not enabled: Managed Standby
SQL>
SQL> startup nomount;
ORA-32004: obsolete or deprecated parameter (s) specified for RDBMS instance
ORA-00439: feature not enabled: Managed Standby
SQL>
2. Background alert log log trac given as follows:
ORA-00439: feature not enabled: Managed Standby
Thu Dec 03 11:39:24 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file /oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_ora_5717.trc:
ORA-00439: feature not enabled: Managed Standby
Analysis: Is the reason being given the boot parameters
3. Export Parameter File
SQL> create pfile = '/ oracle / pfile1203.ora' from spfile;
File created.
SQL>
Parameter file as follows:
powerdes .__ db_cache_size = 3087007744
powerdes .__ java_pool_size = 67108864
powerdes .__ large_pool_size = 67108864
powerdes .__ oracle_base = '/ oracle / app / oracle' # ORACLE_BASE set from environment
powerdes .__ pga_aggregate_target = 3959422976
powerdes .__ sga_target = 7449083904
powerdes .__ shared_io_pool_size = 0
powerdes .__ shared_pool_size = 4026531840
powerdes .__ streams_pool_size = 134217728
* .audit_file_dest = '/ Oracle / app / oracle / admin / powerdes / adump'
* .audit_sys_operations = TRUE
* .audit_trail = 'NONE'
* .compatible = '11 .2.0.0.0 '
* .control_files = '/ Home / oradata / powerdes / control01.ctl', '/ oracle / app / oracle / flash_recovery_area / powerdes / control02.ctl'
* .db_block_size = 8192
* .db_domain = ''
* .db_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / pwerdes'
* .db_name = 'Powerdes'
* .db_recovery_file_dest = '/ Oracle / app / oracle / flash_recovery_area'
* .db_recovery_file_dest_size = 16106127360
* .db_unique_name = 'Pdunq'
* .diagnostic_dest = '/ Oracle / app / oracle'
* .dispatchers = '(PROTOCOL = TCP) (SERVICE = powerdesXDB)'
* .fal_client = 'PD'
* .fal_server = 'PD_DG'
* .global_names = FALSE
* .job_queue_processes = 1000
* .log_archive_config = 'DG_CONFIG = (pdunq, pddgunq)'
* .log_archive_dest_1 = 'LOCATION = / oracle / app / oracle / flash_recovery_area / archivelog VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = pdunq'
* .log_archive_dest_2 = 'SERVICE = PD_DG VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = pddgunq lgwr sync affirm'
* .log_archive_dest_3 = ''
* .log_archive_dest_state_1 = 'ENABLE'
* .log_archive_dest_state_2 = 'Defer'
* .log_archive_dest_state_3 = 'ENABLE'
* .log_archive_format = '% T_% s_% r.dbf'
* .log_archive_max_processes = 20
* .log_archive_start = FALSE
* .log_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / powerdes'
* .memory_target = 11379146752
* .open_cursors = 300
* .optimizer_index_caching = 90
* .optimizer_index_cost_adj = 25
* .optimizer_mode = 'FIRST_ROWS'
* .processes = 1000
* .remote_login_passwordfile = 'EXCLUSIVE'
* .sessions = 335
* .standby_file_management = 'AUTO'
* .undo_tablespace = 'UNDOTBS1'
4, modify the parameter file
Remove archive_dest
* .log_archive_config = 'DG_CONFIG = (pdunq, pddgunq)'
* .log_archive_dest_1 = 'LOCATION = / oracle / app / oracle / flash_recovery_area / archivelog VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = pdunq'
* .log_archive_dest_2 = 'SERVICE = PD_DG VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = pddgunq lgwr sync affirm'
* .log_archive_dest_3 = ''
* .log_archive_dest_state_1 = 'ENABLE'
* .log_archive_dest_state_2 = 'Defer'
* .log_archive_dest_state_3 = 'ENABLE'
Remove fal
* .fal_client = 'PD'
* .fal_server = 'PD_DG'
Remove the standby
* .standby_file_management = 'AUTO'
Save as pfile1203_01.ora:
powerdes .__ db_cache_size = 3087007744
powerdes .__ java_pool_size = 67108864
powerdes .__ large_pool_size = 67108864
powerdes .__ oracle_base = '/ oracle / app / oracle' # ORACLE_BASE set from environment
powerdes .__ pga_aggregate_target = 3959422976
powerdes .__ sga_target = 7449083904
powerdes .__ shared_io_pool_size = 0
powerdes .__ shared_pool_size = 4026531840
powerdes .__ streams_pool_size = 134217728
* .audit_file_dest = '/ Oracle / app / oracle / admin / powerdes / adump'
* .audit_sys_operations = TRUE
* .audit_trail = 'NONE'
* .compatible = '11 .2.0.0.0 '
* .control_files = '/ Home / oradata / powerdes / control01.ctl'
* .db_block_size = 8192
* .db_domain = ''
* .db_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / pwerdes'
* .db_name = 'Powerdes'
* .db_recovery_file_dest = '/ Oracle / app / oracle / flash_recovery_area'
* .db_recovery_file_dest_size = 16106127360
* .db_unique_name = 'Pdunq'
* .diagnostic_dest = '/ Oracle / app / oracle'
* .dispatchers = '(PROTOCOL = TCP) (SERVICE = powerdesXDB)'
* .global_names = FALSE
* .job_queue_processes = 1000
* .log_archive_dest_1 = 'LOCATION = / oracle / app / oracle / flash_recovery_area / archivelog VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = pdunq'
* .log_archive_dest_state_1 = 'ENABLE'
* .log_archive_format = '% T_% s_% r.dbf'
* .log_archive_max_processes = 20
* .log_archive_start = FALSE
* .log_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / powerdes'
* .memory_target = 11379146752
* .open_cursors = 300
* .optimizer_index_caching = 90
* .optimizer_index_cost_adj = 25
* .optimizer_mode = 'FIRST_ROWS'
* .processes = 1000
* .remote_login_passwordfile = 'EXCLUSIVE'
* .sessions = 335
* .undo_tablespace = 'UNDOTBS1'
5. Rebuild parameter files
SQL> create spfile from pfile = '/ oracle / pfile1203_01.ora';
File created.
SQL>
6, restart the nomount
SQL> startup nomount;
ORA-32004: obsolete or deprecated parameter (s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1.1358E + 10 bytes
Fixed Size 2216744 bytes
Variable Size 8254393560 bytes
Database Buffers 3087007744 bytes
Redo Buffers 13946880 bytes
SQL> |
|
|
|