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博客 ” ，链接：https://blog.itpub.net/13750068/viewspace-758502/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- ctgmq00
- HAIP&linked-local ip&RFC-3927&IPv4 169.254xxlinked local
- How to Create Oracle Database QoS Management Administrator Accounts
- Creating Physical Standby Using RMAN DUPLICATE
- MultiColumn Statistics
- Result Cache Can Not Be Enabled
- Convert Range-Partitioned Table To Interval-Range-Partitioned Table
- Indexing on Virtual Columns
- Create Reference-Partitioned Tables
- How To Use Virtual Column-Based Partitioning
