Be aware of non-critical recovery situations. Make sure you are aware of the many situations that are considered a non-critical loss. Be aware of the six main areas of non-critical losses: temporary tablespaces, redo log members, index tablespaces, indexes, read-only tablespaces, and password files.
Understand non-critical recovery with temporary tablespaces. Know how to create a new temporary tablespace if needed. Know how to start the database with a missing tempfile. Understand how to alter the default temporary tablespace to a different tablespace.
Understand non-critical recovery with redo logs. Understand how to rebuild redo log members. Know how to identify that there is a missing redo log member from the alert log. Be aware of multiplexing or mirroring redo logs and why they are important.
Identify non-critical recovery with index tablespaces and contents. Know how to rebuild a missing index tablespace and the contents or indexes within the tablespace. Make sure to maintain scripts of the indexes so that these can be rebuilt quickly if necessary.
Understand non-critical recovery with read-only tablespaces. Be aware of how to recover a read-only tablespace. Understand the three different read-only tablespace scenarios that impact recovery.
Be aware of non-critical recovery with password files. Understand the two primary authentication methods for administrators. Know how to recover from the remote authentication method by rebuilding the password file.