ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 开启归档模式

开启归档模式

原创 Linux操作系统 作者:jichengjie 时间:2012-06-07 16:30:32 1 删除 编辑
SQL>alter system set log_archive_start=TRUE scope=spfile;
SQL>alter system set log_archive_dest_1='LOCATION=/u01/ora9/oradata/itown01/archive' scope=spfile;
 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
oracle@linux-unknown:/u01/ora9/oradata/itown01/archive> ls
oracle@linux-unknown:/u01/ora9/oradata/itown01/archive> sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 7 15:47:31 2012
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> alter system switch logfile;
System altered.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
oracle@linux-unknown:/u01/ora9/oradata/itown01/archive> ls
1_1330.dbf
 
注:在oracle10g只需要执行开启归档模式命令即可
SQL> alter database archivelog;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26870952/viewspace-732168/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-04-10

  • 博文量
    151
  • 访问量
    416911