3.启用归档
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
alter system set log_archive_dest_1='LOCATION=/u01/arch'
scope=spfile;
sql> shutdown immediate;
sql> startup mount;
sql> alter database archivelog;
sql> alter database open;
退出来创建/u01/arch 路径
4.配置主库初始化参数
alter system set log_archive_config='DG_CONFIG=(fxdb,sbdb)'
scope=both; 是指的 DB_UNIQUE_NAME 值
alter system set log_archive_dest_1='LOCATION=/u01/arch
评论0
最新资源