Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
A lost SPFILE can be recovered from memory using SQL*PLUS because the SPFILE can be recreated with the command 'create spfile from memory.' A lost password file can be manually re-created with the orapwd utility, which is explicitly designed for this purpose. A lost index tablespace can be re-created without performing any recovery because indexes can be rebuilt after dropping the tablespace and recreating it, making the data available again without traditional recovery operations.
ADF correct
Why F? you can drop datafiles of tablespace where are INDEXes only, then restart DB. It will fail as datafiles cannot be found so make them offline drop and open DB. From dictionary view extract DDLs to create indexes and save it in your notepad. Drop tablespace including contents. Create tablespace with the same name. Use DDLs to re-create indexes from your notepad. Done. Tested in practice minutes ago.
C - is wrong, tempfile can be recreated automatically since 10g: https://oracle-help.com/backup-and-recovery/recovery-recover-loss-temporary-tablespace/ F is correct i think (lost datafiles can be offline dropped and recreated, index can be rebuild without need of recovery) So, my opinion: A, D, F
A. CORRECT. SQL> create spfile from memory; C. CORRECT drop the temporary tablespace and then create a new one and assign new one to the database users. D. CORRECT. use orapwd to recreate
C is wrong. It is talking about datafile, not tablespace. If you delete a TEMP datafile, Oracle will recreate it autoamtically before opening the database.
I think E is wrong because of "with SQLPlus"
ADF correct
ADF option are correct
A,D,F correct. F - recreate tablespace and indexes using DDL
My opinion, A C and D A. CORRECT. SQL> create spfile from memory; B. WRONG. Not possible. C. CORRECT. No harm to DB, only warning. Drop and recreate D. CORRECT. use orapwd to recreate E. WRONG. PFILE is just text file no need SQLPLUS. Just copy paste content of pararamterfrom alert_SID.log. save it as $ORACLE_HOME/dbs/initSID.ora via text editor or vi. F. WRONG. Recovery needed
A and D are correct. Between E and F, I think E is correct. So I say, ADE. Anybody agree?
Pfile can re-create from spfile or moemory, but not alter log.
but can recovery from alter log by text editor, nor sql*plus
I think A - D - E. 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 https://www.thegeekdiary.com/how-to-create-the-oracle-password-file-using-orapwd-command/ E- create pfile from log https://docs.oracle.com/en/database/oracle/oracle-database/18/tutorial-recover-a-lost-or-damaged-server-parameter-file/index.html#CreateSPFILE
E- is Incorrect U can't create pfile from log only with sqlplus. You must use text editor for that. "Locate the alert_ORCLCDB.log file, which you need to use to extract the initialization parameters and their values."
why F?
It will probably be because of my low level of English, but I don't understand the meaning of option E (A lost PFILE can be re-created alert.log using SQL * PLUS). Lost PFILE can be recreated from the alert.log and It can also be created using SQL*PLUS, but I don't understand both in that sentence...
I think there is a missing word: "E : A lost PFILE can be re-created with alert.log using SQL*PLUS."