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

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 15 discussion

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

You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination.
The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set, so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

  • A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
  • B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
  • C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
  • D. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
  • E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
You can change this default deletion policy using the following RMAN command:
CONFIGURE ARCHIVELOG DELETION POLICY TO [CLEAR | NONE | APPLIED ON STANDBY];
Use the APPLIED ON STANDBY clause so that archived redo log files that have been applied on all mandatory standby destinations will be deleted.
Incorrect Answers:
A: APPLIED ON ALL STANDBY is not valid.
C, D: SHIPPED TO is not valid.
E: Use the NONE clause so that archived redo logs in flash recovery area that were backed up or obsolete as per the RMAN retention policy are eligible for deletion. This is the default configuration. Archived redo log files that are backed up or obsolete are deleted to make space if the disk space in the flash recovery area becomes full.
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14239/rman.htm#i1031870
by Kamaelk at Oct. 14, 2019, 10:59 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
kemsalim
1 year, 1 month ago
A is correct, https://support.oracle.com/knowledge/Oracle%20Database%20Products/1324759_1.html
upvoted 1 times
...
hilaire
1 year, 2 months ago
A is correct http://blog.data-alchemy.org/tips/oracle-rman-deletion/
upvoted 1 times
...
ucdongmo
1 year, 7 months ago
I think C is correct. We do not need to apply archived logs. Redo apply read directly from standby redo and apply. In this case archived logs are not applied by standby are in sync. I think if archived logs are shipped to all standby, they can be deleted from Primary.
upvoted 1 times
...
JESUSBB
2 years, 5 months ago
Answer: A
upvoted 1 times
...
Sugar
3 years, 3 months ago
i agree A is correct
upvoted 1 times
Sugar
3 years, 3 months ago
regardless of whether only one standby is mandatory or not, it should still be APPLIED to all standby databases
upvoted 1 times
...
...
SaguSe7en
5 years, 2 months ago
Correct. Agreed with Kamaelk
upvoted 1 times
Kamaelk
5 years ago
I was wrong, key word is "mandatory destination". If make standby db mandatory destination, set deletion policy work well: RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; old RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters are successfully stored RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; old RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters are successfully stored
upvoted 2 times
ra2020
4 years, 8 months ago
I'm agree, the keyword is "mandatory"
upvoted 1 times
...
...
...
Kamaelk
5 years, 3 months ago
B is wrong. Right answer is A. RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters are successfully stored RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; old RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters are successfully stored RMAN-08591: warning: invalid archived log deletion policy
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago