Saturday, December 10, 2022

how to enable archive log mode in oracle

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

 

 

No comments:

Post a Comment