数据库环境:
OS:Redhat as 4
DB:Oracle 10.2.0.4
User:travel
数据文件:select file#,status,enabled,name from v$datafile;
控制文件:select * from v$controlfile;
联机日志:
设置归档模式
root 登录
su – oracle
sqlplus /nolog
conn / as sysdba
select name,log_mode from v$database;
也可以
archive log list
数据库该为归档模式
alter systemset log_archive_dest_1='location=/home/oracle/arch/log/archive_log';
没有目录的话:
mkdir -p /oracle/arch/log/
还可以添加一个日志位置可使用以下语句
SQL>alter system setlog_archive_dest_2='location=/home/oracle/arch/log/archive_log2';
shutdown immediate
startup mount
alter database archivelog
alter database open
alter system set log_archive_max_processes = 5;修改归档最大进程数
alter system set log_archive_format ="archive_%t_%s_%r.log" scope=spfile spfile生效
archive log list