ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
1、 将归档日志路径LOG_ARCHIVE_DEST的值改为空
idle>alter system set log_archive_dest='';
2、 设置归档日志路径log_archive_dest_1的值
idle>alter system set log_archive_dest_1 ='LOCATION=/software/cold_backup/' scope= both;
System altered.
3、 设置闪回路径
idle>alter system set db_recovery_file_dest='/software/flashback' scope=both;
System altered.
4、 开闪回
idle>alter database flashback on;
Database altered.
idle>select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
开闪回归档
idle>create flashback archive fba1 tablespace example quota 500m retention 1 year;
Flashback archive created.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-1418196/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-1418196/