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

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

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

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

4，打开数据库... 1

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

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

正文：

1，查看当前归档模式

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

2，重启数据库到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.

3，开启归档模式

SQL> alter database archivelog;

Database altered.

4，打开数据库

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.

5，关闭归档模式的步骤

SQL> startup mount;

SQL> alter database noarchivelog;

SQL> alter database open;

6，9i和10g的区别

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

log_archive_start = true

10g中已经废弃该参数