A database is configured in ARCHIVELOG mode. Full RMAN backups are taken daily and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)
A.
when any archived log from, before, or after the most recent backup is corrupt.
B.
after losing all copies of the control file
C.
after losing an archived log from after the most recent backup
D.
after losing an archived log from before the most recent backup
I vote for DE,
but disagree that b will do a resetlogs.
If there is no backup of controlfile in trace and backup of controlfile at all, no copy of controlfile, DBA may still know all information to re-create controlfile !!! (values like MAXLOGFILES 16, MAXLOGMEMBERS 3, MAXDATAFILES 100, ...) since lot of databases uses dbca defaults or have other documentation.
Then refer section "Set #1. NORESETLOGS" in https://prakashoracledba.wordpress.com/2015/02/16/step-by-step-alter-database-backup-controlfile-to-trace/
...
I did sucessfully fixed this way 19c db. with lost of ontrol file (disk error) and no backup of contfolfile at all, no copy (db. was in archived mode). I'm living proof that B is also right, but it's a bit hacking.
i think D and E are correct.
If you lose any archive from after the backup, you can't do a complete recovery, so A and C are discarted, also you can't mount the database if you don't have a valid control file. (not B)
well if the question was "incomplete recovery" then i think that you only need the control file and the backup, so it could be possible to do the incomplete recovery in A,C,D, and also E, fortunately they ask for the complete recovery scenario, so i'm going with D, E :)
DE
Complete Recovery
Apply online or archived redo logs, or a combination of the two
In this case, we need choice C to do complete recovery
Incomplete Recovery
you do not apply all of the redo records generated after the most recent backup.
https://docs.oracle.com/cd/B13789_01/server.101/b10743/backrec.htm
B is a weird one.
If autobackup is ON, we would have an extra backup piece for the control file in the backupset. (for CDBs and non-CDBs, starting with 12.0.0 or higher, autobackup is turned on)
Even if autoback is OFF, then, when we issue a BACKUP DATABASE or BACKUP TABLESPACE that includes data file 1 (system), then by default oracle includes the control file as part of the backup, but not as a separate backup piece.
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50
Why i would say B is wrong is because we somehow lost "ALL copies of the control files"
All other situations will either deprive you of some transactional information }current or archived redo logs to redo the transactions up to date) or you do not have current LSN to complete the recovery (as the LSN is written in the controlfile header).
A - FALSE of course - database recovery is possible ony to SCN with, the last transaction in previous archivied redo log,
B - TRUE/FALSE because we do not know how the backup was taken,
C - FALSE (no any doubts),
D - TRUE (no any doubts),
E - TRUE (because we can restore full database),
B and D
thegeekstuff.com/2014/11/oracle-rman-restore/
This is a complete recovery even though the database is opened with resetlogs option:
RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;
if only non default parameter CONFIGURE CONTROLFILE AUTOBACKUP ON or you have taken your backup using following command
RUN {
BACKUP DATABASE;
BACKUP SPFILE;
}
# or if your database does not use a server parameter file:
RUN {
BACKUP DATABASE;
BACKUP CURRENT CONTROLFILE;
}
but we do not know that ...
If controlfile need to restore from autobackup, it may not be the latest version. In such case, should it be in-complete recovery instead of complete recovery?
upvoted 1 times
...
...
...
This section is not available anymore. Please use the main Exam Page.1z0-083 Exam Questions
Log in to ExamTopics
Sign in:
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.
cerebro2000x
Highly Voted 4 years, 2 months ago1451755
3 weeks agoveginha
Highly Voted 4 years, 4 months agotaotsumiau
4 years, 4 months agoveginha
4 years, 4 months agodancymonkey
Most Recent 9 months, 1 week agoeleeitor
1 year, 3 months agoBlob44
1 year, 4 months agoScottL
1 year, 6 months ago_gio_
1 year, 6 months agojareach
1 year, 8 months agohilaire
1 year, 9 months agoG_C
2 years, 1 month agoAlvinzzz
2 years, 5 months agoabaisyet
3 years, 2 months agoG_C
2 years agodacoben415lywenw
4 years, 4 months agonww
3 years, 12 months agoAlvinzzz
1 year, 4 months ago