Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

The correct answer is A. A lost SPFILE can be recovered from memory using SQL*PLUS. D. A lost password file can be manually re-created with the orapwd utility. F. A lost index tablespace can be re-created without performing any recovery. A - create spfile from memory https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE- SPFILE.html#GUID-D3E295B7-A3A4-43D3-8BBD-5CBE171A2E52 D - create password file using orapwd F - lost datafiles can be offline dropped and recreated, index can be rebuild…

Perform Backup and Recovery

Question

Options

AA lost SPFILE can be recovered from memory using SQL*PLUS.
BA lost password file can be re-created with SQL*PLUS.
CA lost TEMPFILE must always be re-created manually.
DA lost password file can be manually re-created with the orapwd utility.
EA lost PFILE can be re-created alert.log using SQL*PLUS.
FA lost index tablespace can be re-created without performing any recovery.

How the community answered

(20 responses)

A
75% (15)
B
15% (3)
C
5% (1)
E
5% (1)

Explanation

A - create spfile from memory https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE- SPFILE.html#GUID-D3E295B7-A3A4-43D3-8BBD-5CBE171A2E52 D - create password file using orapwd F - lost datafiles can be offline dropped and recreated, index can be rebuild without need of

Topics

#manual recovery#SPFILE recovery#orapwd utility#index tablespace

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice