SQL> alter system set log_archive_dest_1='localtion=/oracle/backup_m';
alter system set log_archive_dest_1='localtion=/oracle/backup_m'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby
大家帮忙看一下应该怎么改,谢谢
alter system set log_archive_dest_1='localtion=/oracle/backup_m'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby
大家帮忙看一下应该怎么改,谢谢
试试:
ALTER SYSTEM SET log_archive_dest_1='localtion=/oracle/backup_m' SCOPE=spfile还有数据库是spfile启动的还是pfile启动的?如果这样不行,就直接在pfile里面改...
--------------------------------------------------------------------------------D:\ORACLE\DB_1\DBS\SPFILEORCL.ORA
--这样可以查看你使用的是SPFILE还是PFILE
谢谢您,请看下面SQL> show parameter spfileNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string ?/dbs/[email protected]
SQL> ALTER SYSTEM SET log_archive_dest_1='localtion=/oracle/backup_m' SCOPE=spfile;
ALTER SYSTEM SET log_archive_dest_1='localtion=/oracle/backup_m' SCOPE=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby
SQL> show parameter spfileNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string ?/dbs/[email protected]
SQL> ALTER SYSTEM SET log_archive_dest_1='localtion=/oracle/backup_m' SCOPE=spfile;
ALTER SYSTEM SET log_archive_dest_1='localtion=/oracle/backup_m' SCOPE=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby