This post explains about the steps are used by DBA for recovery From Redo Log File. Check the archive log status SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 2 Current log sequence 4 List the tablespaces SQL> select name from v$tablespace; NAME —————————— […]
Articles Tagged: Redo Log Files
Automatic Deletion of Redo Log Files by SQL Apply
Archive log files which are used by SQL apply process at Logical Standby database is said to be Foreign Archive Logs or Remote Archived Logs. Foreign Archive log files are managed by SQL Apply process. To know more about it Oracle Dataguard After all the redo entries of Archive log files are applied using SQL apply process, these […]