$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 10 13:38:57 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 5016387584 bytes
Fixed Size 2027744 bytes
Variable Size 922750752 bytes
Database Buffers 4076863488 bytes
Redo Buffers 14745600 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 62
Current log sequence 64
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 5016387584 bytes
Fixed Size 2027744 bytes
Variable Size 922750752 bytes
Database Buffers 4076863488 bytes
Redo Buffers 14745600 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=/ora_data/cpntest/archive';
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 5016387584 bytes
Fixed Size 2027744 bytes
Variable Size 922750752 bytes
Database Buffers 4076863488 bytes
Redo Buffers 14745600 bytes
Database mounted.
aDatabase opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ora_data/cpntest/archive
Oldest online log sequence 62
Next log sequence to archive 64
Current log sequence 64
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
注意:
如果是oracle9i,还需要更改如下参数:
alter system set log_archive_start=true scope=spfile;
但是如果在10g中也更改这些参数,数据库重启时会有如下提示:
ORA-32004: obsolete and/or deprecated parameter(s) specified
alter system set log_archive_format='%t_%s.dbf' scope=spfile;
但是如果在10g中也更改这些参数,数据库会不能启动,如下提示:
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-19905: log_archive_format must contain %s, %t and %r
本文来自:韦少乾博客(mven.cn)
详细出处:http://mven.cn/post/41.html
分享到:
相关推荐
Aix5.3及oracle10g安装
4、 AIX5.3下安装的需求 5、 配置 hacmp5.3 第 2 部分 为 Oracle 配置 AIX 1、 创建 Oracle 组和用户帐户 2、 设置 ORACLE_BASE 和 ORACLE_HOME 环境变量:.profile 3、 创建挂载点 4、 配置 Shell 限制, 系统需求, ...
aix 5.3 安装oracle
AIX5.3上安装Oracle10g的文档
AIX 5.3下Oracle 10G升级补丁到10.2.0.5.0步骤20110805.doc
详细介绍了AIX5.3的安装过程以及在AIX5.3系统下安装oracle10g的过程。
AIX5.3+ORACLE10G安装,其中包括详细的环境检查、系统包和补丁的安装、数据库的安装。
oracle 10g rac for aix5.3安装文档
Oracle10gRAC在IBM-AIX5.3上的安装手册
利用NBU6.5备份AIX5.3下的ORACLE_10G数据库
Aix5.3环境下安装Oracle11gr1(11.1.0.7)文档
oracle 10g for aix 5.3 install 很好的一个oracle 10g for aix的安装文档,介绍的很全面
AIX5.3中使用Java和PHP开发AIX5.3中使用Java和PHP开发AIX5.3中使用Java和PHP开发
Oracle 10g on AIX5.3 Oracle公司的培训文档
oracle10G在 AiX 5.3安装配置RAC详细步骤,对每一步操作有详细安装说明,
Oracle10g在AIX5.3上的安装
ORACLE 10G 安装指南(AIX 5.3 +ASM)