In which situation can you use Flashback Database?
A.
when undoing a shrink data file operation
B.
when retrieving a dropped tablespace
C.
when returning to a point in time before the restoration or re-creation of a control file
D.
when returning to a point in time before the most recent open resetlogs operation
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm (prerequisites,
third para)
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194
You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file. If the database control file is restored from backup or re-created, then all existing flashback log information is discarded.
So, C is wrong
B and D
A, D
https://docs.oracle.com/database/121/RCMRF/rcmsynta023.htm#RCMRF194
This command works by undoing changes made by Oracle Database to the data files that exist when you run the command. Flashback can fix logical failures, but not physical failures. Thus, you cannot use the command to recover from disk failures or the accidental deletion of data files.
You can drop a tablespace without delete datafiles.
B is correct.
It’s B and D
Here’s why :
Prerequisites of Flashback Database
You are not trying to use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file. If the database control file is restored from backup or re-created, then all accumulated flashback log information is discarded.
You are not trying to use FLASHBACK DATABASE to undo a resize datafile operation. Note that shrinking a database object such as a table does not affect your ability to use FLASHBACK DATABASE.
Read all
Prerequisites of Flashback Database
To use the FLASHBACK DATABASE command to return your database contents to points in time within the flashback window, your database must have been previously configured for flashback logging as described in “Configuring Oracle Flashback Database and Restore Points”. To return the database to a guaranteed restore point, you must have previously defined a guaranteed restore point as described in “Creating Normal and Guaranteed Restore Points”.
Flashback Database works by undoing changes to the datafiles that exist at the moment that you run the command. Note the following important prerequisites:
No current datafiles are lost or damaged. You can only use FLASHBACK DATABASE to rewind changes to a datafile made by an Oracle database, not to repair media failures or recover from accidental deletion of datafiles.
You are not trying to use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file. If the database control file is restored from backup or re-created, then all accumulated flashback log information is discarded.
You are not trying to use FLASHBACK DATABASE to undo a resize datafile operation. Note that shrinking a database object such as a table does not affect your ability to use FLASHBACK DATABASE.
Why do you have two answers they clearly state: In which situation, not situations?!?
Thanks Feedback for showing this!
D. Confirm.
TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS.
Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later.
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194
You’re right… It’s B then
I read about it a bit more and answer should be D, not A.
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta023.htm#RCMRF194
I mean D instead of B.
You can use flashback to retrieve a dropped tablespace. So B is correct .
http://www.dba-oracle.com/t_rman_159_restore_dropped_tablespace.htm
So Answer is B,D
B
BD because A and C is not possible according to Oracle documentation:
https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV89752
Prerequisites of Flashback Database
To use the FLASHBACK DATABASE command to return your database contents to points in time within the flashback window, your database must have been previously configured for flashback logging as described in “Overview of Flashback Database, Restore Points and Guaranteed Restore Points”. To return the database to a guaranteed restore point, you must have previously defined a guaranteed restore point as described in “Using Normal and Guaranteed Restore Points”.
Flashback Database works by undoing changes to the data files that exist at the moment that you run the command. Note the following important prerequisites:
— No current data files are lost or damaged. You can only use FLASHBACK DATABASE to rewind changes to a data file made by an Oracle database, not to repair media failures.
— You are not trying to recover from accidental deletion of data files, undo a shrink data file operation, or undo a change to the database name.
— You are not trying to use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file. If the database control file is restored from backup or re-created, then all accumulated flashback log information is discarded.
— You are not trying to use FLASHBACK DATABASE to undo a compatibility change.
Passed 1Z0-067 exam few days ago!
Scored 92% (the passing score is 60% now), I got 102 questions, they were mainly on:
1. Oracle Data Protection Solutions
2. Configuring for Recoverability
3. Using the RMAN Recovery Catalog
4. Implementing Backup Strategies
5. Configuring RMAN Backup Options and Creating Backup of Non-Database Files
6. Performing Restore and Recovery Operations
7. Recovering Files Using RMAN
8. Multitenant Container and Pluggable Database Architecture
9. Installing and Upgrading to Oracle Database 12c
10. In-Database Archiving and Valid-Time Temporal
The 1Z0-067 exam was a little difficult to pass, and I used valid 1Z0-067 dumps/1Z0-067 VCE dumps/1Z0-067 PDF dumps here: https://tr.im/1h7L1 (188q VCE and PDF)
@Kurt A. Stamper: Congrats to pass the exam it looking really a tough exam.
I wanna ask u one question, that as u see that most answers in these dumps are wrongs. So what u answer in the exam, i means that u give the answers as mentioned in the dumps or give the actual right answers which normally guys are discussing here.
You reply can help us, I hope u will give a kind response.
Thanks
An intriguing discussion is worth comment. I think that you need to write more on this topic, it might not be a taboo subject but generally people do not speak about these topics. To the next! Many thanks!!|
Only D is correct!
Flashback Database cannot Be used to:
Repair media failures
Reverse dropping a tablespace
Reverse shrinking a data file
Reverse the effects of increasing the database version with COMPATIBLE
Reverse a change to the database name
Restore deleted datafiles
Flashback to a point in time before restore or re-create of the control file
Only D is correct
2. Flashback Database cannot be used to repair media failures, or to recover from accidental deletion of datafiles.
3. You cannot use Flashback Database to undo a shrink datafile operation, actually, shrinking a datafile or dropping a tablespace can prevent Flashing back the Database.
https://blogs.oracle.com/XPSONHA/entry/feature_enthusiasm_oracle_flas
I would sum up the entire discussion:
D – is correct according to docs
B- We know that practically it is possible to restore dropped tablespace (at least in some cases) BUT according to docs “Some database operations, such as dropping a tablespace or shrinking a data file, cannot be reversed with Flashback Database. ”
As question sugests that there should be only one correct answer i would choose D.
D