Determine if the database is setup in archive log mode
SQL> Select log_mode from v$database
SQL> archive log list;
Archive log list gives a little bit detailed information about your archive log setup. By default, when you enable archive log, all the archive log files are written into flash_recovery_area.Below command will show you the OS path
sql> show parameter recovery_file_dest
To Disable Archive log
SQL> shutdown immediate
SQL> startup mount
SQL> alter database noarchivelog
SQL> alter database open
SQL> archive log list
Your database is now running in NO archive log mode
No comments:
Post a Comment