故障现象:
SQL> show spparameter log_archive_dest_1;
SID NAME TYPE VALUE
- log_archive_dest_1 string location=+arc
ycloans1 log_archive_dest_1 string location=+arc
ycloans2 log_archive_dest_1 string location=+arc
归档文件设置了多个路径:
解决方法:
alter system reset log_archive_dest_1 sid='ycloans1';
alter system reset log_archive_dest_1 sid='ycloans2';
show spparameter log_archive_dest_1;
SID NAME TYPE VALUE
- log_archive_dest_1 string location=+arc
- log_archive_dest_10 string
- log_archive_dest_11 string
- log_archive_dest_12 string
- log_archive_dest_13 string
- log_archive_dest_14 string