General

General

ORA-38774 whiles disabling archivelog mode

I got the following error while disabling archivelog mode on a database. SQL> alter database noarchivelog;alter database noarchivelog*ERROR at line 1: ORA-38774: cannot disable media recovery - flashback database is…

Comments Off on ORA-38774 whiles disabling archivelog mode
February 12, 2023
General

How to enable ARCHIVELOG mode in Oracle Database 11g,12c,18c,19c

1. Connect to database [oracle@srv1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 27 20:56:28 2022 Version 19.8.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights…

Comments Off on How to enable ARCHIVELOG mode in Oracle Database 11g,12c,18c,19c
March 28, 2022