The actual examinees that study the Ucertify Oracle 1Z0-058 places are good results regarding very certified professors, dwelling a great lifestyle. Ucertify may be devoted to build your future secure and commence your Oracle 1Z0-058 Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure test formulations through the newest up to date Ucertify checks 1Z0-058 examination engine. Your dreams should come true by begin your 1Z0-058 vce regarding Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure test through Ucertify Oracle research manuals only. Youll not in a position to stand out your abilities in the first attempt regarding 1Z0-058 examination if you are using any additional path compared to Oracle. Oracle Oracle 1Z0-058 pdf will give you splendour thus making you enough certain about your whole lifestyle.
2021 Jun 1Z0-058 exam cram
Q91. Which two statements are true about instance recovery in a RAC environment?
A. Parallel instance recovery will work even if the recovery_parallelism initialization parameter set to 0 or 1.
B. Increasing the size of the default buffer cache can speed up instance recovery because instance recovery may use as much as 50 percent of the default buffer cache for recovery buffers.
C. The fast_start_mttr_target initialization parameter includes both instance startup and recovery time.
D. The fast__start_mttr_target initialization parameter specifies only the instance recovery time.
Explanation: Many sites run with too few redo logs that are too small. Small redo logs cause system checkpoints to continuously put a high load on the buffer cache and I/O system. If there are too few redo logs, then the archive cannot keep up, and the database will wait for the archive process to catch up. With the Fast-Start Fault Recovery feature, the FAST_START_MTTR_TARGET initialization parameter simplifies the configuration of recovery time from instance or system failure. FAST_START_MTTR_TARGET specifies a target for the expected mean time to recover (MTTR), that is, the time (in seconds) that it should take to start up the instance and perform cache recovery.
Oracle Database Performance Tuning Guide
Q92. The high availability services provided by Oracle Clusterware are used to protect Oracle resources, such as RAC database instances, RAC database services, and other components of the Oracle Grid Infrastructure, and non-Oracle resources as well.
Which two statements are true about the high availability capabilities of Oracle HA services?
A. RAC databases may have their instances failed over in some cases.
B. ASM instances may be failed over if fewer than three nodes remain in the cluster, so that there are always at least three ASM instances available.
C. If a node fails, then all resources that were active on that node will be failed over to a surviving node if any exists.
D. If a node fails, then cluster resources that were active on that node may be failed over to a surviving node if any exists, but local resources are not failed over.
E. HA services will only fail over a resource upon failure of the node where the resource was active.
Local resource: These are server-centric resources; the type name is local_resource.
These run locally on individual servers of the cluster and are not relevant outside of the scope of the server.
Cluster resource: Cluster-aware resource types (type name is cluster_resource) are aware of the cluster environment and are subject to cardinality and cross-server switchover and failover. The state of cluster resources is relevant in the context of the cluster.
Oracle 11g: RAC and Grid Infrastructure Administration
Q93. Which two types of files can be stored In an ASM clustered file system?
A. OCR and Voting Disk files
B. data files for external tables
C. Oracle database executable
D. Grid Infrastructure executables
E. data files for tablespaces
F. archive log files
Explanation: Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to support customer files maintained outside of Oracle Database. Oracle ACFS supports many database and application files, including executables, database trace files, database alert logs, application reports, BFILEs, and configuration files. Other supported files are video, audio, text, images, engineering drawings, and other general-purpose application file data. Notes:
. Oracle ASM is the preferred storage manager for all database files. It has been specifically designed and optimized to provide the best performance for database file types.
. Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files. . Oracle ACFS does not support any file type that can be directly stored in Oracle
ASM, except where explicitly noted in the documentation. Not supported means Oracle Support Services does not take calls and development does not fix bugs associated with storing unsupported file types in Oracle ACFS.
. Starting with Oracle Automatic Storage Management 11g Release 2 (220.127.116.11), Oracle ACFS supports RMAN backups (BACKUPSET file type), archive logs (ARCHIVELOG file type), and Data Pump dumpsets (DUMPSET file type). Note that Oracle ACFS snapshots are not supported with these files.
. Oracle ACFS does not support files for the Oracle Grid Infrastructure home.
. Oracle ACFS does not support Oracle Cluster Registry (OCR) and voting files.
Updated 1Z0-058 real exam:
Q94. Which three statements are true about using RMAN with ASM?
A. RMAN is the only supported method to back up database files stored in ASM.
B. RMAN is the only supported method to back up ACFS files.
C. RMAN can use ASM storage for backups.
D. RMAN cannot use ASM storage for backups.
E. Using RMAN, database files can be migrated to ASM from a file system.
F. Using RMAN, database files cannot be moved from ASM to a file system
. RMAN is also critical to Automatic Storage Management (ASM)..Since ASM is critical to GRID operations, RMAN is then critical for GRID based systems. In ASM, RMAN is responsible for tracking the ASM filenames and for performing the deletion of obsolete ASM files. ASM files cannot, however, be accessed through normal operating system interfaces; therefore, RMAN is the preferred means of copying ASM files. It is also possible to use FTP through XDB, but generally, RMAN will be less complex. It is important to learn to use RMAN first because RMAN is the only method for performing backups of a database containing ASM files.
. Setting Initialization Parameters for ASM The procedure for creating a duplicate database to an ASM location is similar to the procedure described in "Settings and Restrictions for OMF Initialization Parameters" on page 25-4. The difference is that you must identify the initialization parameters that control the location where files are created and set these parameters to an ASM disk group. For example, set DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_DEST_n,and CONTROL_FILES to +DISK1.
. To take advantage of Automatic Storage Management (ASM) with an existing database you must migrate that database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your primary backup and recovery strategy.
Oracle. Database Backup and Recovery Advanced User's Guide
Q95. You have an ASM cluster and you want to terminate all the ASM instances. Assume that the database Instances supported by the ASM are already shut down. What must you know to select the appropriate command for this operation?
A. Are the OCR and voting disk files stored In ASM diskgroups?
B. Are the SYSTEM and SYSAUS tablespaces stored In ASM diskgroups?
C. Is the undo tablespace stored in ASM diskgroups?
D. Are the redo log files stored in ASM diskgroups?
Explanation: Oracle strongly recommends that you shut down all database instances that use the Oracle ASM instance and dismount all file systems mounted on Oracle ASM Dynamic Volume Manager (Oracle ADVM) volumes before attempting to shut down the Oracle ASM instance. If Oracle Cluster Registry (OCR) or voting files are stored in a disk group, the disk group can only be dismounted by shutting down the Oracle ASM instance as part of shutting down the clusterware on a node. To shut down the clusterware, run crsctl stop crs.
Oracle Automatic Storage Management Administrator's Guide
Q96. As part of the preinstatlation process for adding two new nodes to your four-node UNIX cluster, you are in discussions with the OS administrators about the operating system Installation and setup for the two new nodes called RACNODE5 and RACNODE6.
The nodes have already been connected to the network infrastructure and the administrators are ready for the OS installation. Which two methods fulfill the installation requirements?
A. Install a new image of the OS, then configure SSH for the root user.
B. Install a cloned image of the OS that at least matches the existing node images for drivers, patches, and updates.
C. Install a new image of the OS, that at least matches an existing node for drivers, patches, and updates, and create the necessary OS users and groups with user and group IDs matching those on the existing nodes.
D. Install a new image of the OS that at least matches the existing node Images for drivers.
E. Install a new image of the OS, and create the necessary OS users and groups with any user and group IDs.
Prerequisite Steps for Adding Cluster Nodes
1. Make physical connections.
Connect the nodes' hardware to the network infrastructure of your cluster. This includes establishing electrical connections, configuring network interconnects, configuring shared disk subsystem connections, and so on. See your hardware vendor documentation for details about this step.
2. Install the operating system.
Install a cloned image of the operating system that matches the operating system on the other nodes in your cluster. This includes installing required service patches, updates, and drivers. See your operating system vendor documentation for details about this process. Note: Oracle recommends that you use a cloned image. However, if the installation fulfills the installation requirements, then install the operating system according to the vendor documentation.
3. Create Oracle users. You must create all Oracle users on the new node that exist on the existing nodes. For example, if you are adding a node to a cluster that has two nodes, and those two nodes have different owners for the Grid Infrastructure home and the Oracle home, then you must create those owners on the new node, even if you do not plan to install an Oracle home on the new node.
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q97. Which are the key factors that you should consider before converting a single-Instance database Oracle Real Application Cluster (RAC) database to guarantee a successful media recovery?
A. If the database is in archive log mode, the archive file format requires a thread number.
B. The archive logs from all nodes must be accessible to all nodes in the cluster database.
C. The storage option must be Automatic Storage Management (ASM).
D. All database files must be migrated to Oracle Managed Files (OMF).
Issues for Converting Single Instance Databases to Oracle RAC
Backup procedures should be available before conversion takes place.
Archiving in Oracle RAC environments requires a thread number in the archive file format.
The archived logs from all instances of an Oracle RAC database are required for media recovery.
By default, all database files are migrated to Oracle Managed Files (OMF).
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 11 - 24