vieri.
cazevedoSenhores estou precisando da ajuda URGENTE de vocês.
Estou configurando uma base de Standby, ao iniciar as configurações da base prod, ao tentar acertar o log_archive_dest_1, ocorre o seguinte erro:
SQL> alter system set log_archive_dest_2=’LOCATION=/oracle/oradata/orcl/arch’ scope=spfile;
alter system set log_archive_dest_2=’LOCATION=/oracle/oradata/orcl/arch’ scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby
Outras informações que podem ser úteis:
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/product/9.2.0/dbs/arch
Oldest online log sequence 14337
Current log sequence 14339
SQL> show parameter log_archive_dest
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
vieri[oracle@admbi1 archive]$ oerr ora 00439
00439, 00000, “feature not enabled: %s”
// *Cause: The specified feature is not enabled.
// *Action: Do not attempt to use this feature.
SQL> select * from v$option where parameter = ‘Managed Standby’;
PARAMETER VALUE
Managed Standby TRUE
Provavelmente vc está usando versão standart.
Porque não usa o parâmetro padrão :
log_archive_dest
abraços!!
SEXTA-FEIRA chegou…. !!!! 😀 😆 🙂 8) 😈 😉