Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?
A. It checks that supplemental logging is turned on if there is a logical standby database in the configuration.
B. It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.
C. It checks that the current data protection level is consistent with the broker’s configured data protection mode.
D. It modifies the database configurable parameters to match the values set for the broker configuration.
E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.
Answer: ABC
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN.
Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?
A. The standby database must have supplemental logging enabled.
B. The primary database must have FORCE LOGGING enabled.
C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
D. The primary database must have supplemental logging enabled.
E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.
Answer: BC
Monday, 17 February 2020
Tuesday, 1 October 2019
Oracle 1z0-066 Question Answer
A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary?
A. The upgrade requires downtime until the upgrade of the standby is completed.
B. The broker must be disabled during the upgrade.
C. With manual upgrade, catupgrd.sq1 can be executed on the primary and standby databases simultaneously.
D. The upgrade requires downtime until the upgrade of the primary is completed.
E. The new release of the Oracle Software must be installed on both the primary and standby database hosts.
F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
G. Fast-Start Failover can be used to protect the primary database during the upgrade.
Answer: BDE
You are licensed to use Oracle Active Data Guard.
Which two statements are true after enabling block change tracking on a physical standby database?
A. It allows fast incremental backups to be offloaded to the physical standby database.
B. It starts the CTWR process on the physical standby database instance.
C. It allows fast incremental backups to be taken on the primary database.
D. It starts the RVWR process on the physical standby database instance.
E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
F. It starts the CTWR process on the primary database instance.
Answer: AB
As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary?
A. The upgrade requires downtime until the upgrade of the standby is completed.
B. The broker must be disabled during the upgrade.
C. With manual upgrade, catupgrd.sq1 can be executed on the primary and standby databases simultaneously.
D. The upgrade requires downtime until the upgrade of the primary is completed.
E. The new release of the Oracle Software must be installed on both the primary and standby database hosts.
F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
G. Fast-Start Failover can be used to protect the primary database during the upgrade.
Answer: BDE
You are licensed to use Oracle Active Data Guard.
Which two statements are true after enabling block change tracking on a physical standby database?
A. It allows fast incremental backups to be offloaded to the physical standby database.
B. It starts the CTWR process on the physical standby database instance.
C. It allows fast incremental backups to be taken on the primary database.
D. It starts the RVWR process on the physical standby database instance.
E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
F. It starts the CTWR process on the primary database instance.
Answer: AB
Tuesday, 31 July 2018
Oracle 1z0-066 Question Answer
After converting your physical standby database to a logical database, you get an error:
DGMGRL> show configuration
Configuration- proddg
Protection Mode: MaxPerformance
Databases:
prod-Primary datatabse
prodsby-Physical standby database
Error: ORA-16810 multiple errors or warnings detected for database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
How can you rectify the error?
A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
D. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata.
Answer: D
Which four requirements can be met by deploying a logical standby database?
A. Support for workloads requiring additional indexes.
B. It can be used to create additional schemas.
C. It can be used to create additional tables.
D. It must have the same physical structure as the primary database.
E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
F. Support for workloads requiring additional materialized views.
G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.
Answer: ACEG
DGMGRL> show configuration
Configuration- proddg
Protection Mode: MaxPerformance
Databases:
prod-Primary datatabse
prodsby-Physical standby database
Error: ORA-16810 multiple errors or warnings detected for database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
How can you rectify the error?
A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
D. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata.
Answer: D
Which four requirements can be met by deploying a logical standby database?
A. Support for workloads requiring additional indexes.
B. It can be used to create additional schemas.
C. It can be used to create additional tables.
D. It must have the same physical structure as the primary database.
E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
F. Support for workloads requiring additional materialized views.
G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.
Answer: ACEG
Tuesday, 27 February 2018
Oracle 1z0-066 Question Answer
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION
Configuration – DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by-Primary database
FS_inst- Far Sync
Far_away –Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?
A. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.
D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.
E. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.
Answer: A 1z0-066 Questions Dumps
DGMGRL> SHOW CONFIGURATION
Configuration – DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by-Primary database
FS_inst- Far Sync
Far_away –Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?
A. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.
D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.
E. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.
Answer: A 1z0-066 Questions Dumps
Wednesday, 27 December 2017
How Kalani Ware Became Oracle Arena's Go-To Painter
In November, pop superstar Bruno Mars played at the Oracle Arena in Oakland. The morning of the show, he sent an excited tweet to his 38 million followers, accompanied by a picture of a painting of the singer. The artwork, which was hung in a backstage hallway, was made by a little-known Oakland artist, Jon Kalani Ware (who goes by the name of Kalani Ware).
Chances are you've never heard of Ware, but in the last six months, he seems to have become the recurring artist of Oracle Arena. Since July, he has been commissioned to produce paintings for J. Cole, Kendrick Lamar and The Weeknd. Oracle Arena also commissioned it to make an art piece for Tour 444 from Jay-Z, who stopped at the arena on December 16th. Ware said he is the first visual artist to produce concert pieces at the Oakland location. (Oracle representatives did not respond to requests for comments). The first piece commissioned for the J. Cole show was painted on the corridor walls, apart from the photos, nothing remains because it was painted due to the rapid turnover of events in the place. Each piece has been made on canvas, conserving the work for future use. "Kendrick's crew ended up taking the piece after the show," Ware said proudly during an interview.
Ware, an Oakland native whose grandmother is from Hawaii, began to draw as a child. He attended the University of Hawaii at Manoa, where he studied graphic design. It was a trip to the prisoner of war! WOOHOO! Festival in Hawaii that unleashed his desire to take advantage of his creative side more. "We are all born creative," Ware said. "I took art classes when I was a teenager, and I decided to try it and use it as my zen."
Although Ware's work continues to evolve, it now combines elements of abstraction and realism. His paintings contain black and white, brightly colored lines and graphic patterns. "Abstract work is subjective and open to interpretation, and certain colors attract people," Ware explained a few weeks ago, while showing some of his latest work at the Good Mother Gallery in downtown Oakland, where he had an individual exhibition in November.
Shades of blue, red and purple dominate most of his canvases. These colors represent their time in Hawaii: blue represents the ocean, while shades of red, orange and purple symbolize the sunrises and sunsets of Hawaii. The use of black and white, meanwhile, reflects the concrete jungle that is Oakland. Most of his paintings are made with oil, acrylic or spray paint.
Ware said Hawaiian artist Solomon Enos once challenged him to think deeply about his work and question its meaning. "He aha ka mana'o," said Ware, who told Enos. "When I paint something, I think about what I can give back to my community, my friends, my family, my society."
Ware also paints people, but these are not common portraits. One includes the silhouette of a woman, while another juxtaposes half of a face with color waves and a pattern block. "I'm very strategic about how I paint certain pieces," he said. "I do not want money to direct what I believe, but I have to be aware of what I think is nice and can also be sold here in the Bay Area and in other parts of the world."
Ware spreads the word about what he does to build relationships. "For every piece I create, I post it on Instagram and label art curators, art galleries and music festivals," he said. "I probably annoyed them because I tagged them all the time, but at least I got their attention."
So far, your efforts seem to be paying off. In 2016, her work was presented within the VIP area of the Outside Lands Music Festival in San Francisco. The work of art was printed on lanterns that hung next to the VIP tents. The same work was also shown at the Life is Beautiful Festival in Las Vegas and at the Kaaboo music festival in San Diego.
It was that hurried mentality that gave him the concert at the Oracle. As a promising artist living in the expensive Bay Area, Ware works full time to help fund his passion. His installation signs for 9 to 5 jobs took him to Oracle. While touring the space, Ware casually mentioned that he is an artist. "I knew it was a possible conflict of interest to say that, but I'm an artist struggling," he said. "I'm trying to strive to achieve my greatness, I'm building a brand."
Ware hopes to one day hold art workshops for young aspiring artists and follow in the footsteps of other local artists such as Jet Martinez and members of the Illuminaries and TDK crews by plastering murals on the walls of The Town. "I want the murals to bring a conversation about diversity," he said.
Meanwhile, he is still perfecting his style. "Artists have a specific signature that can be recognized anywhere in the world," Ware said. "I know I have a long way to go and I am enjoying the process."
Monday, 30 October 2017
Oracle 1z0-066 Question Answer
Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration-Animals
Protection Mode: MaxAvailability
Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration
Dogs – (*) Physical standby database (disabled)
ORA- 16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
And the fast-start failover configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: dogs
Observer : 017.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 10 seconds
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Offline YES
Oracle error Conditions:
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.
A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
B. MOUNT DOGS and issue “reinstate database dogs:” at the DGMGRL prompt while connected to Dogs.
C. MOUNT DOGS and issue “reinstate database dogs:” at the DGMGRL prompt while connected to Sheep.
D. Open Dogs and let the broker reinstate Dogs automatically.
Answer: C
DGMGRL> show configuration:
Configuration-Animals
Protection Mode: MaxAvailability
Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration
Dogs – (*) Physical standby database (disabled)
ORA- 16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
And the fast-start failover configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: dogs
Observer : 017.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 10 seconds
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Offline YES
Oracle error Conditions:
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.
A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
B. MOUNT DOGS and issue “reinstate database dogs:” at the DGMGRL prompt while connected to Dogs.
C. MOUNT DOGS and issue “reinstate database dogs:” at the DGMGRL prompt while connected to Sheep.
D. Open Dogs and let the broker reinstate Dogs automatically.
Answer: C
Thursday, 7 September 2017
Oracle 1z0-066 Question Answer
A customer has these requirements for their potential Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
Which Data Guard broker commands are needed to implement these requirements?
A. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: physt1, FASTSYNC)’;
EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1 SYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt2 SYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
B. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1 ASYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt FASTSYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
C. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1 SYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt ASYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
D. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: physt1, FASTSYNC)’;
EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1, FASTSYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt2 ASYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Answer: A
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
A. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: physt1, FASTSYNC)’;
EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1 SYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt2 SYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
B. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1 ASYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt FASTSYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
C. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1 SYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt ASYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
D. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: physt1, FASTSYNC)’;
EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1, FASTSYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt2 ASYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Answer: A
Subscribe to:
Posts (Atom)