Wednesday, December 22, 2010

Oracle: Enable Archive log mode

Launch SQLPLUS and login as SYS

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 Enable Archive log
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog
SQL> alter database open
SQL> archive log list

Your database is now running in archive log mode

1 comment:

  1. Power BI classes online: Cover Power Query, star‑schema modeling, DAX, dashboards, and publishing with lifetime LMS, real projects, and interview prep aligned to PL‑300 skills.

    ReplyDelete