Activate archivelog mode on a database
As you can see, database is in "No Archive Mode" and Archive destination is "/u01/app/oracle/flash_recovery_area" SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 308 Current log sequence 309 SQL> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size big integer 2G We can change archive destination by doing: SQL> alter system set DB_RECOVERY_FILE_DEST='' scope=both SID='*'; System altered. SQL> alter system set log_archive_dest='/u01/app/oracle/prueba' scope=both SID='*'; System altered. We also should to check destination f...