1. Check Database is In Archive Log Mode Or Not
SQL > select name,log_mode from v$database;
NAME LOG_MODE ---------------------- ----------------------------- MYDB NOARCHIVELOG
2. To enable ARCHIVELOG mode status, enter the following SQL commands:
SQL> Shutdown immediate SQL> Startup mount SQL> Alter database archivelog; SQL> alter database open;
3. To check the ARCHIVELOG mode status, enter the following SQL command:
SQL> archive log list;
For Learn More About Oracle :- Click Here
For Learn More About Oracle :- Click Here
1