Technical Notes

We're all on the same page!

Showing posts with label archive log. Show all posts
Showing posts with label archive log. Show all posts
Friday, 24 February 2017

How to manage archive logs?

›
Check status of archivelog mode: SQL> archive log list; Open if it is closed: Link SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST -...
Tuesday, 14 October 2014

How to check/open archive log in sqlplus?

›
Check in archive log open: SQL> SELECT LOG_MODE FROM SYS.V$DATABASE; or SQL>  archive log list; Open achieve log mode: SQL> ...
›
Home
View web version
Powered by Blogger.