查看原有归档配置
节点1：
SQL> select arch_name , arch_type , arch_dest , arch_file_size , arch_space_limit from v$dm_arch_ini ;
行号 ARCH_NAME ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT
---------- -------------- --------- ----------- -------------- ----------------
1 ARCHIVE_LOCAL1 LOCAL /dm8/dmarch 512 2048
2 ARCH_REMOTE1 REMOTE DSC2 512 2048
已用时间: 1.689(毫秒). 执行号:800.
节点2：
SQL> select arch_name , arch_type , arch_dest , arch_file_size , arch_space_limit from v$dm_arch_ini ;
行号 ARCH_NAME ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT
---------- -------------- --------- ----------- -------------- ----------------
1 ARCHIVE_LOCAL1 LOCAL /dm8/dmarch 512 2048
2 ARCH_REMOTE1 REMOTE DSC1 512 2048
已用时间: 2.833(毫秒). 执行号:202.
节点1：
alter database mount;
alter database noarchivelog;
alter database delete archivelog 'DEST=/dm8/dmarch, TYPE=LOCAL, FILE_SIZE=512, SPACE_LIMIT=2048';
alter database delete archivelog 'DEST=dsc2, TYPE=REMOTE, FILE_SIZE=512, SPACE_LIMIT=3096, INCOMING_PATH=/dm8/remote_arch';
sf_archivelog_delete_before_time(sysdate+1); --删除之前生成的归档日志文件
alter database archivelog;
alter database add archivelog 'DEST=/dm8/dmarch, TYPE=LOCAL, FILE_SIZE=1024, SPACE_LIMIT=3096';
alter database add archivelog 'DEST=dsc2, TYPE=REMOTE, FILE_SIZE=1024, SPACE_LIMIT=3096, INCOMING_PATH=/dm8/remote_arch';
alter database open;
节点2：
alter database mount;
alter database noarchivelog;
alter database delete archivelog 'DEST=/dm8/dmarch, TYPE=LOCAL, FILE_SIZE=512, SPACE_LIMIT=2048';
alter database delete archivelog 'DEST=dsc2, TYPE=REMOTE, FILE_SIZE=512, SPACE_LIMIT=3096, INCOMING_PATH=/dm8/remote_arch';
sf_archivelog_delete_before_time(sysdate+1); --删除之前生成的归档日志文件
alter database archivelog;
alter database add archivelog 'DEST=/dm8/dmarch, TYPE=LOCAL, FILE_SIZE=1024, SPACE_LIMIT=3096';
alter database add archivelog 'DEST=dsc1, TYPE=REMOTE, FILE_SIZE=1024, SPACE_LIMIT=3096, INCOMING_PATH=/dm8/remote_arch';
alter database open;
节点1：
SQL> select arch_name , arch_type , arch_dest , arch_file_size , arch_space_limit from v$dm_arch_ini ;
行号 ARCH_NAME ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT
---------- -------------- --------- ----------- -------------- ----------------
1 ARCHIVE_LOCAL1 LOCAL /dm8/dmarch 1024 3096
2 ARCH_REMOTE1 REMOTE DSC2 1024 3096
已用时间: 0.940(毫秒). 执行号:804.
节点2：
SQL> select arch_name , arch_type , arch_dest , arch_file_size , arch_space_limit from v$dm_arch_ini ;
行号 ARCH_NAME ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT
---------- -------------- --------- ----------- -------------- ----------------
1 ARCHIVE_LOCAL1 LOCAL /dm8/dmarch 1024 3096
2 ARCH_REMOTE1 REMOTE DSC1 1024 3096
已用时间: 0.856(毫秒). 执行号:207.
