SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-38774: cannot disable media recovery - flashback database is enabled
SQL> Select name from v$restore_point;
no rows selected
SQL> select NAME,FLASHBACK_ON from v$database;
NAME FLASHBACK_ON
--------- ------------------
ProdDB01 YES
SQL> alter database flashback off;
Database altered.
SQL> alter database noarchivelog;
Database altered.
No comments:
Post a Comment