ORA-38706 ORA-3871

SQL> startup mount;

ORACLE instance started.

Total System Global Area  205520896 bytes

Fixed Size                  1218508 bytes

Variable Size              92276788 bytes

Database Buffers          104857600 bytes

Redo Buffers                7168000 bytes

Database mounted.

SQL> alter database flashback on;

alter database flashback on

*

ERROR at line 1:

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

ORA-38714: Instance recovery required.

SQL> alter database force logging;

Database altered.

SQL> SQL>  alter database flashback on;

 alter database flashback on

*

ERROR at line 1:

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

ORA-38714: Instance recovery required.

SQL>  alter database flashback  off;

Database altered.

SQL> alter database open;

shutdown immediate

Database altered.

SQL> SQL> Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01034: ORACLE not available

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  205520896 bytes

Fixed Size                  1218508 bytes

Variable Size              92276788 bytes

Database Buffers          104857600 bytes

Redo Buffers                7168000 bytes

Database mounted.

Database opened.

SQL>  select flashback_on from v$database;

FLASHBACK_ON

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

NO

SQL> shutdown immediate;

startup   mount;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> ORACLE instance started.

Total System Global Area  205520896 bytes

Fixed Size                  1218508 bytes

Variable Size              92276788 bytes

Database Buffers          104857600 bytes

Redo Buffers                7168000 bytes

Database mounted.

SQL> SQL> SQL> alter database flashback on;

alter database 

Database altered.

SQL> 

  2  

SQL> alter database open;

Database altered.

SQL>  select flashback_on from v$database;

FLASHBACK_ON

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

YES

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-758502/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-758502/