u说明
在Oracle 11g,开启archive log模式时,默认归档目录为db_recovery_file_dest指定。此参数在pfile/spfile中可以指定:
db_recovery_file_dest=‘/u01/app/oracle/flash_recovery_area‘
需要在mount状态下,更改归档模式
u修改步骤
ü启动到mount状态
SQL> startup mount;
ü查看归档模式
SQL> archive log list;
Database log modeNo Archive Mode
Automatic archivalDisabled
Archive destinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence5
Current log sequence7
ü修改归档路径,不使用默认的路径
更改log_archive_dest_1参数可更改归档日志目录(pfile/spfile中参数db_recovery_file_dest指定的目录将无效)
SQL> show parameter log_archive_dest_1;
NAMETYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_1string
修改路径:
SQL> alter system set log_archive_dest_1=‘location=/u01/oracle/archivelog‘ scope=spfile;
ü重新启动到mount状态
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ü修改成归档模式
SQL> alter database archivelog;
Database altered.
ü检查归档是否生效
SQL> archive log list;
Database log modeArchive Mode
Automatic archivalEnabled
Archive destination/u01/oracle/archivelog
Oldest online log sequence5
Next log sequence to archive7
Current log sequence7
SQL> alter database open;
SQL> alter system switch logfile;
System altered.
生成归档文件:
1_7_888826695.dbf
原文:http://12865902.blog.51cto.com/12855902/1920505