Recover From Redo Log File

This post explains about the steps are used by DBA for recovery From Redo Log File. Check the archive log status

List the tablespaces

Create new tablespace and create a table with some dummy data

Shutdown the database

Delete the datafile and try to start the database

Recreate the datafile and […]

Read More

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

Read More