Oracle Apps DBA

Oracle apps dba workshop for all of you who are related Linux and Oracle. If you are looking for getting knowledge about oracle apps dba, oracle ebs and linux etc then you are in right place. Oracle apps dba workshop will provide info that is tested. whatever you are in beginner or advance level, you can follow this blog for increasing you knowledge in Linux and Oracle Apps DBA. You will find everything in step by step. So you can accept this blog as Oracle Apps DBA Workshop.

Showing posts with label RMAN backup and recovery. Show all posts

Saturday, December 10, 2022

how to enable archive log mode in oracle

How to enable/disable archive log mode in oracle database

How To Enable Archive Log Mode In Oracle Database 19c

Changing the Database Archiving Mode - Oracle

Connect database as sys user to configure it in archivelog mode

[oracle@12c ~]$ sqlplus / as sysdba

SQL> archive log list;

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog;

SQL> alter database open;

SQL> select open_mode from v$database;

SQL> archive log list;

Now you system is in Archive Mode and you can go for RMAN backup.

You can find me on Fiverr & LinkedIn