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 —————————— […]