【RMAN】如何开启oracle归档模式RMAN

【RMAN】如何开启oracle归档模式

RMAN 2010-04-01 15:27:10 阅读20 评论0 字号：大中小

1，查看当前归档模式... 1

2，重启数据库到mount状态... 1

3，开启归档模式... 1

4，打开数据库... 1

5，关闭归档模式的步骤... 1

6，9i和10g的区别... 2

正文：

，查看当前归档模式

SQL> archive log list;

Database log mode             No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence      210

Current log sequence           212

，重启数据库到mount状态

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

 

Total System Global Area       6442450944 bytes

Fixed Size                  2030368 bytes

Variable Size                 1358955744 bytes

Database Buffers              5066719232 bytes

Redo Buffers               14745600 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     210

Next log sequence to archive    212

Current log sequence          212

SQL> archive log start;

Statement processed.

 

，关闭归档模式的步骤

SQL> startup mount;

SQL> alter database noarchivelog;

SQL> alter database open;

 

，9i和10g的区别

9i中需要修改初始化参数

log_archive_start = true

10g中已经废弃该参数