ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 178 discussion

Actual exam question from Oracle's 1z0-062
Question #: 178
Topic #: 1
[All 1z0-062 Questions]

A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN.
You lost all control files due to media failure.
Given the steps to recover from the error in random order:
1. Shut down the instance, if it is not already down.
2. Restore the control file from autobackup to a new location.
3. Start the database instance to NOMOUNT state.
4. Recover the database to the point of failure of the control file.
5. Open the database with the RESETLOGS option.
6. Mount the database.
7. Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command.
Identify the correct sequence of the required steps.

  • A. 1, 3, 2, 6, 7, 4, 5
  • B. 1, 3, 7, 2, 6, 4, 5
  • C. 1, 3, 2, 4, 5
  • D. 1, 2, 6, 4, 5
  • E. 1, 6, 2, 4, 5
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by dancymonkey at Aug. 11, 2020, 4:25 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dancymonkey
Highly Voted 4 years, 9 months ago
Sorry, I did the research https://docs.oracle.com/database/121/RCMRF/rcmsynta2008.htm#RCMRF149 Example 3-25 Restoring a Control File Autobackup to a Nondefault Location CONNECT TARGET / STARTUP FORCE NOMOUNT SET DBID 36508508; # required when restoring control file in NOCATALOG mode RUN { SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/disk1/prod_cf_auto_%F'; RESTORE CONTROLFILE TO '/tmp/cf_auto.dbf' FROM AUTOBACKUP MAXSEQ 20 MAXDAYS 150; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; } ALTER DATABASE OPEN RESETLOGS; The correct answer must be B
upvoted 9 times
loveroba
4 years, 5 months ago
all controlfiles are lost,so you must restore new controlfile and update the spfile before the next startup mount ,checked
upvoted 2 times
jackymak
3 years, 3 months ago
the spfile is only for startup the instance (ie to nomount mode). The db is already in nomount mode then it is no reason the modify the spfile?
upvoted 1 times
...
...
...
Ray520
Most Recent 2 years, 10 months ago
Steps as verified: Stop database startup nomout. restore controlfile from autobackup. startup mount. RECOVER DATABASE USING BACKUP CONTROLFILE: ORA-00280: change 9765681 for thread 1 is in sequence #479 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} <here enter the redo log name, might need to enter few times to get latest log, once that is applied below message will come: Log applied. Media recovery complete.> ALTER DATABASE OPEN RESETLOGS;
upvoted 1 times
...
Ray520
3 years, 1 month ago
Option B is correct. We can set new control file location using ALTER system command. then when we run RESTORE CONTROLFILE from autobackup, it wutomatically restores to new location.
upvoted 2 times
...
Ray520
3 years, 1 month ago
A is correct partially. (although we don't need the ALTER SYSTEM command to rename control file location ) Rest options don't look correct
upvoted 1 times
...
Ray_gk
3 years, 1 month ago
C must be the correct answer. Here is the outcome of option B: run{ 2> startup force nomount; 3> alter system set control_files='/home/app/oradata/SOURCE/controlfile/control1.ctl','/home/app/oradata/SOURCE/controlfile2.ctl','/home/app/oradata/SOURCE/controlfile3.ctl'; 4> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/backcontrolfile/control_%F'; 5> restore controlfile to '/home/app/oradata/SOURCE/controlfile' from autobackup; 6> alter database mount; 7> restore database; 8> recover database; 9> alter database open read only;} RMAN-03002: failure of sql statement command at 04/16/2022 18:07:59 ORA-02095: specified initialization parameter cannot be modified
upvoted 1 times
Ray_gk
3 years, 1 month ago
Here is the outcome for option A: RMAN> run{ 2> startup force nomount; 3> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/backcontrolfile/control_%F'; 4> restore controlfile to '/home/app/oradata/SOURCE/controlfile' from autobackup; 5> alter database mount; 6> alter system set control_files='/home/app/oradata/SOURCE/controlfile/control1.ctl','/home/app/oradata/SOURCE/controlfile2.ctl','/home/app/oradata/SOURCE/controlfile3.ctl'; 7> restore database; 8> recover database; 9> alter database open read only;} RMAN-03002: failure of configure command at 04/16/2022 18:16:10 ORA-01507: database not mounted
upvoted 1 times
Ray_gk
3 years, 1 month ago
C is the only series of commands to be performed successfully unless there is an error in the logic of my commands. Option C run{ startup force nomount; set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/backcontrolfile/control_%F'; restore controlfile from autobackup; alter database mount; restore database; recover database; alter database open resetlogs;}
upvoted 1 times
Ray_gk
3 years, 1 month ago
Went back to my commands and found an error for configuring controlfile autobackup format. Instead of Configure I should have put "CONTROLFILE AUTOBACKUP FORMAT." Sorry if that confuses some people. I tested the corrections and both A and C still do not work as intended.
upvoted 1 times
...
...
...
...
Hacova
3 years, 9 months ago
Answer must B for the autobackup definition.
upvoted 3 times
...
joe_doe
4 years, 9 months ago
correct answer should be A
upvoted 2 times
...
dancymonkey
4 years, 9 months ago
C is correct final answer Example 3-24 Recovering the Database with a Control File Autobackup Assume that the control file and some data files are lost and must be restored from tape. Because RMAN does not use a recovery catalog in this scenario, the SET DBID command is necessary to identify the control file to be restored. The example restores the control file from tape, mounts the database, and then restores and recovers the database. CONNECT TARGET / STARTUP FORCE NOMOUNT; SET DBID 36508508; # required when restoring control file in NOCATALOG mode RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT; RESTORE DATABASE; RECOVER DATABASE; } ALTER DATABASE OPEN RESETLOGS;
upvoted 1 times
...
dancymonkey
4 years, 10 months ago
C is correct You cannot Alter SYSTEM MEMORY for CONTROL_FILES while instance started in nomount state https://docs.oracle.com/database/121/REFRN/GUID-1D609657-4283-40DA-8A57-8097E719281C.htm#REFRN10021
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel