SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38707: Media recovery is not enabled.
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38707: Media recovery is not enabled.
Cause : For enable flashback database must be archive mode. To resolve this error enable archive log mode.
SQL>
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 630501376 bytes
Fixed Size 2215984 bytes
Variable Size 381685712 bytes
Database Buffers 243269632 bytes
Redo Buffers 3330048 bytes
Database mounted.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/oradata/archive
Oldest online log sequence 434
Current log sequence 436
SQL> alter database archivelog;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL>
I am getting below error after i restored the database via cold backup and tried to restart the database
ReplyDeleteDatabase dismounted.
ORACLE instance shut down.
SQL> startup force
ORACLE instance started.
Total System Global Area 2.0844E+10 bytes
Fixed Size 2290320 bytes
Variable Size 9797897584 bytes
Database Buffers 1.1006E+10 bytes
Redo Buffers 38440960 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination G:\Oracle\DMESLT95\Oradata\archive
Oldest online log sequence 15
Next log sequence to archive 18
Current log sequence 18
SQL> alter database archivelog;
Database altered.
SQL> lter database flashback on;
SP2-0734: unknown command beginning "lter datab..." - rest of line ignored.
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
SQL>
Can you post message from alert log.
ReplyDelete