ORACLE归档日志打开关闭方法.docVIP

ORACLE 归档日志打开关闭方法 ?一 设置为归档方式 view plaincopy to clipboardprint? 1?sql ?archive?log?list;???#查看是不是归档方式?? 2?sql ?alter?system?set?log_archive_start true?scope spfile;?#启用主动归档 sql ?alter?system?set?log_archive_dest location /oracle/ora9/oradata/arch?scope spfile; #设置归档路径 sql ?alter?system?set?log_archive_dest_1 location /oracle/ora9/oradata/arch1?scope spfile; sql ?alter?system?set?log_archive_dest_2 location /oracle/ora9/oradata/arch2?scope spfile; #如果归档到两个位置，则可以通过上边方法实现 sql ?alter?system?set?log_archive_format arch_%d_%t_%r_%s.log??#设置归档日记款式?? 3?sql ?shutdown?immediate;?? 4?sql ?startup?mount;??