Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
flashback, use archive log: see "Changes between the last flashback log and the target time must be re-created based on the archived redo log. If no automatic channels are allocated for tape and a needed redo log is on tape, then the FLASHBACK DATABASE operation fails."
BDF
Why D? https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/FLASHBACK-DATABASE.html#GUID-584AC79A-40C5-45CA-8C63-DED3BE3A4511:~:text=You%20must%20enable%20flashback%20logging%20before%20the%20target%20time%20for%20flashback%20by%20issuing%20the%20SQL%20statement%20ALTER%20DATABASE%20...%20FLASHBACK%20ON.
You must enable flashback logging before the target time for flashback by issuing the SQL statement ALTER DATABASE ... FLASHBACK ON.
Archived redo log files are also used:
"RMAN uses flashback logs to undo changes to a point before the target time or SCN. RMAN automatically restores from backup any archived redo log files that are needed and recovers the database to make it consistent"
Database mounted.
SQL> ALTER DATABASE ARCHIVELOG;
Database altered.
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE FLASHBACK ON;
ALTER DATABASE FLASHBACK ON
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38709: Recovery Area is not enabled.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/tmp' SCOPE=BOTH;
System altered.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=1G SCOPE=BOTH;
System altered.
SQL> ALTER DATABASE FLASHBACK ON;
Database altered.
Well, E is wrong.
One prerequisite for FLASHBACK DATABASE is that the database "must be mounted with a current control file". When mounted the redo log files are not online, and redo cannot be written to it.
REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/FLASHBACK-DATABASE.html#GUID-584AC79A-40C5-45CA-8C63-DED3BE3A4511
In another point of the documentation, when using SQL*Plus: "Oracle Flashback Database returns your entire database or an entire PDB to a previous state without requiring you to restore files from backup."
REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-flashback-dbpitr.html#GUID-2E5F3F62-17ED-472A-ABBD-FAAF107C6852
Going BDF on this one. If this is an actual question we can contact Oracle support after the exam to point this point.
Thats the thing. they dont tell you if you are right or wrong on which questions. (unless you only wrong on few questions which you can *guess* which one you might be wrong based on the topic)
I think answer BEF too.
B: You can use sqlplus for FLASHBACK DATABASE. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FLASHBACK-DATABASE.html#GUID-BE0ACF9A-BC13-4810-B08B-33326440258B
Answer: B,D,F
"Flashback Database can only be used if flashback logs are available."
"Any remaining changes are recovered using online and archived redo logs if available."
https://blogs.oracle.com/maa/post/flashback-database-and-flashback-logs#:~:text=Flashback%20Database%20can%20only%20be,target%20to%20use%20Flashback%20Database.
B is False: "You can run this command from the RMAN prompt or from within a RUN command."
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/FLASHBACK-DATABASE.html#GUID-584AC79A-40C5-45CA-8C63-DED3BE3A4511
About C
The overhead of logging for Flashback Database depends on the mixture of reads
and writes in the database workload. When you have a write-intensive workload, the
Flashback Database logging overhead is high since it must log all those database
changes. Queries do not change data and thus do not contribute to logging activity for
Flashback Database.
A is wrong - they are never archived
B is CORRECT,
C is wrong - why queries would have FLASHBACK LOG overhead? only DMLs generate FLASHBACK LOGs
D is wrong - according to documentation and my practice some ARCHIVE LOGs are required too
E - no idea...
F is CORRECT.
... so the only option seems to be BEF
Can you clarify why do you think that queries generate FLASHBACK LOG? I think it is true FLASHBACK DATA ARCHIVE but it is different feature than FLASHBACK DATABASE.
upvoted 1 times
...
...
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.
mporislav
Highly Voted 2 years, 12 months agoantonica
Most Recent 1 month, 3 weeks agoantonica
1 month, 3 weeks agodancymonkey
4 months agojonsnoow
1 month agodancymonkey
3 months, 3 weeks agoKuraudio
4 months, 2 weeks agopiontk
8 months, 2 weeks agoJaredC
5 months, 3 weeks ago_gio_
10 months, 2 weeks agoErikJanssen
11 months, 1 week agoScottL
1 year agoDBA007
2 years, 2 months agoFeaRoX
2 years, 1 month agorodriguesJC
2 years, 6 months agonobody347
2 years, 7 months agonobody347
2 years, 8 months agoG_C
1 year, 7 months agoObserverPL
2 years, 12 months ago7206e44
3 weeks agoguretto
5 months agoRinD
3 years agoG_C
1 year, 7 months ago