Erro ao configurar o “log_archive_dest_1”
Verificando o parâmetro log_archive_dest_1
|
1 2 3 4 5 |
10:34:01 SYS@ORCL> show parameter log_archive_dest_1; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string |
Erro ORA-16179 ao definir o parâmetro.
|
1 2 3 4 5 6 7 8 9 |
10:34:10 SYS@ORCL> ALTER SYSTEM SET log_archive_dest_1='/u02/fra/ORCL/archivelog/'; ALTER SYSTEM SET log_archive_dest_1='/u02/fra/ORCL/archivelog/' * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE Elapsed: 00:00:00.00 |
Solução.
Adicionar o LOCATION
|
1 2 3 4 5 |
10:34:43 SYS@ORCL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u02/fra/ORCL/archivelog/'; System altered. Elapsed: 00:00:00.01 |
Verificando o parâmetro
|
1 2 3 4 5 6 |
SYS@ORCL> show parameter log_archive_dest_1; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string LOCATION=/u02/fra/ORCL/archi velog/ |