在Oracle 10g里启动自动归档模式
来源:互联网 发布:网络货币和虚拟货币 编辑:程序博客网 时间:2024/04/27 02:32
在Oracle10g中,只要启动数据库的归档模式,Oracle就会启用自动归档,从而避免了10g以前由于用户疏忽所带来的一系列问题。
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 09:53:25 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 25
Current log sequence 27
SQL> show parameter log_archive_start
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 3204448256 bytes
Fixed Size 1304912 bytes
Variable Size 651957936 bytes
Database Buffers 2550136832 bytes
Redo Buffers 1048576 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
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 25
Next log sequence to archive 27
Current log sequence 27
SQL>
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 09:53:25 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 25
Current log sequence 27
SQL> show parameter log_archive_start
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 3204448256 bytes
Fixed Size 1304912 bytes
Variable Size 651957936 bytes
Database Buffers 2550136832 bytes
Redo Buffers 1048576 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
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 25
Next log sequence to archive 27
Current log sequence 27
SQL>
- 在Oracle 10g里启动自动归档模式
- Oracle 10g里启动自动归档模式
- 修改 oracle 10g 的归档模式
- oracle 10g rac归档模式切换
- oracle 10g/11g RAC 启停归档模式
- oracle 10g rac standby 归档日志自动删除脚本
- 启用oracle自动归档模式
- 启用oracle自动归档模式
- Aix5.3下Oracle 10g设置归档模式[原创]
- Oracle 10G 归档模式下备份脚本
- oracle 10g归档模式与非归档模式之间的转换
- 在Linux上自动启动和关闭Oracle数据库(9i/10g/11g)
- 在10g oracle里面如何修改为手工归档
- Oracle 10G归档日志
- Oracle RAC 11g 修改归档模式
- Oracle 11g 开启归档模式
- 在redhat5上Oracle 10g 开机自动启动,及raw磁盘自动加载
- 在LINUX 启动时自动启动ORACLE 10G多个实例数据库的方法
- 验证工程师的要求
- 利用XMLBean轻轻松松读写XML
- 《心药方》
- linux下串口编程的个人心得
- 在 Linux 下建立 FTP 搜索引擎
- 在Oracle 10g里启动自动归档模式
- A small trail through the Linux kernel(ZT)
- emacs中让~文件不出现
- 感冒跑肚
- 青年人如何获得成功、自信、快乐
- 函数也会被隐藏!?
- 什么是技术?
- 特殊的日子~
- 可怕的天网防火墙