oracle 第12章归档日志文件

2015-10-23

//查看归档信息
SQL> col name for a30;
SQL> col value for a15;
SQL> select name,type,value from v$parameter where name like 'log_archive%';
//查看归档模式
SQL> archive log list;
//设置归档模式
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog/noarchivelog;
SQL> alter database open;
//查看归档进程
SQL> show parameter log_archive_max_process;
SQL> select * from v$archive_processes;
//设置归档进程
SQL> alter system set log_archive_max_processes=4;
//查看默认归档目录
SQL> show parameter db_recovery_file_dest;
SQL> col name for a30;
SQL> col value for a40;
SQL> select name,value from v$parameter where name like 'db_recovery_file_dest%';
//查看归档目录
SQL> show parameter log_archive_dest;
SQL> desc v$archive_dest;
SQL> col destination for a50;
SQL> select destination,binding,target,status from v$archive_dest where destination is not null;
//设置归档目录
SQL> alter system set log_archive_dest_n='location';
//查看归档历史
SQL> select * from v$loghist;
//查看归档日志命名格式
SQL> show parameter log_archive_format;
//修改归档日志命名格式
SQL>  alter system set log_archive_format = 'arch_%t_%s_%r.arc';