oracle11gr1怎么打开,Oracle11gr1打开数据库的闪回flashback

打开数据库flashback1. 确认一个数据库是否打开了flashback，有两个简单的方法：(1)直接查数据库SQLgt; select name,log_mode

打开数据库flashback

1. 确认一个数据库是否打开了flashback，有两个简单的方法：

(1)直接查数据库

SQL> select name,log_mode,flashback_on from v$database;

NAME LOG_MODE FLASHBACK_ON

--------- ------------ ------------------

ORA11G ARCHIVELOG NO--> flashback未打开

2. 如果数据库没有打开flashback，那么将flashback打开：

(1)确定flashback的存储路径

SQL> show parameter recovery

System altered.

SQL> show parameter recovery

NAME TYPE VALUE

------------------------------- ----------- ------------------------------

db_recovery_file_dest string

db_recovery_file_dest_size big integer 20G

recovery_parallelism integer 0

SQL> alter system set db_recovery_file_dest = '/home/oracle/flashback' scope = both;

System altered.

SQL> show parameter recovery

NAME TYPE VALUE

------------------------------- ----------- ------------------------------

db_recovery_file_dest string /home/oracle/flashback

db_recovery_file_dest_size big integer 20Grecovery_parallelism integer 0

(2)打开flashback

SQL> alter database flashback on;

alter database flashback on

*

ERROR at line 1:

ORA-38759: Database must be mounted by only one instance and not open.

上面的错误，是因为在打开数据库的flashback必须要mount状态下方可以，于是：

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 5344731136 bytes

Fixed Size 2169104 bytes

Variable Size 2130708208 bytes

Database Buffers 3204448256 bytes

Redo Buffers 7405568 bytes

Database mounted.

SQL> alter database flashback on;

Database altered.

SQL> alter database open;

Database altered.

SQL> select name,log_mode,flashback_on from v$database;

NAME LOG_MODE FLASHBACK_ON

--------- ------------------ ------------

ORA11G ARCHIVELOG YES

， 本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：php中文网