Oracle 10备份与恢复之归档模式配置

文章的前面回把开启归档模式及设置归档日志格式等内容放到前面，便于查阅及理清思路。后面会对每一部都进行详细的描述 SQL> archive log list //查看当前归档模式
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3
Current log sequence           5
开启归档模式SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup mount;
ORACLE instance started.Total System Global Area 612368384 bytes
Fixed Size                  2022832 bytes
Variable Size             222298704 bytes
Database Buffers          385875968 bytes
Redo Buffers                2170880 bytes
Database mounted.
SQL> alter database archivelog; //开启归档模式Database altered. SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3
Next log sequence to archive   5
Current log sequence           5 修改归档日志存放地SQL> alter system set db_recovery_file_dest=‘’;System altered. SQL> alter system set log_archive_dest=‘/home/oracle/backup’;System altered. SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/backup
Oldest online log sequence     3
Next log sequence to archive   5
Current log sequence           5
注：

从oracle10g开始默认情况下，归档日志会存放到快速恢复区所对应的目录（对应于初始化参数db_recovery_file_dest）并且会按照特定的格式生成归档日志文件名，如果我们不修改db_recovery_file_dest=‘"为空，而直接指定log_archive_dest的路径则会报错。如下：SQL> alter system set log_archive_dest="/home/oracle/backup";
alter system set log_archive_dest="/home/oracle/backup"
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or
DB_RECOVERY_FILE_DEST

SQL> alter system set log_archive_format=’ARC%S_%R.%T.arc‘ scope=spfile;System altered.SQL> alter system switch logfile; //日志格式的修改仍然没有生效，尝试重启数据库使之生效，生成.arc结尾的文件System altered.SQL> alter database open;Database altered.SQL> alter system switch logfile; //手工切换，目的是产生归档日志，在backup目录下查看生成的文件System altered.cd /home/oracle/backup
$ ls
1_5_736446919.dbf 1_6_736446919.dbf 1_7_736446919.dbf ARC0000000008_0736446919.0001.arc

【内容导航】
第1页：上	第2页：下

Oracle分区表新增主分区及子分区语句AIX5.3 设置Oracle数据的自动启动及关闭相关资讯 oracle

[INS-32052] Oracle基目录和Oracle （07/22/2014 07:41:41）
Oracle 4个大对象（lobs）数据类型（02/03/2013 12:33:05）
Oracle按时间段分组统计（07/26/2012 10:36:48）

[Oracle] dbms_metadata.get_ddl的（07/12/2013 07:37:30）
Liferay Portal 配置使用Oracle和（07/31/2012 20:07:18）
Concurrent Request:Inactive （07/20/2012 07:44:05）

本文评论查看全部评论（0）