Testking 1Z0-058 Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure exercise test would be the best option that you should get ready for the Oracle exam. If you want to be considered a preeminent Testking technicians, you cannot pass by the Testking 1Z0-058 Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure materials preventative measure. One can learn not just the real 1Z0-058 test questions but the in depth description. Transferring Oracle 1Z0-058 accreditation is the initial most essential thing, in addition, one can learn several specific information and experiences that can found in the way forward for exercise perform.
2021 Jun 1Z0-058 exam prep
Q91. Various clients can access and manipulate ASM files. Which two statements are true?
A. The DBMS_FILE_TRANSFER.COPY_FILE procedure can move a database file from one ASM to another ASM, but not to an operating system file system.
B. The ASMCMD cp command can move database files from a file system to ASM, but not from ASM to ASM.
C. The SQL*Plus command ALTER DISKGROUP orcl MOVE '+DATA/orcl/example01.dbf' to '+OLDDATA/orcl/example01.dbf' can move the example01 data file to a different diskgroup.
D. The DBMS_FILE_TRANSFER.GET_FILE procedure reads an ASM file from a remote machine and makes a local copy on an ASM or a file system.
E. The ASMCMD rm command will delete ASM files and directories, but not database files on an operating system file system.
Answer: D,E
Explanation:
DBMS_FILE_TRANSFER
COPY_FILE Procedure
This procedure reads a file from a source directory and creates a copy of it in a destination directory. The source and destination directories can both be in a local file system, or both be in an Automatic Storage Management (ASM) disk group, or between local file system and ASM with copying in either direction. You can copy any type of file to and from a local file system. However, you can copy only database files (such as datafiles, tempfiles, controlfiles, and so on) to and from an ASM disk group.
GET_FILE Procedure
This procedure contacts a remote database to read a remote file and then creates a copy of the file in the local file system or ASM. The file that is copied is the source file, and the new file that results from the copy is the destination file. The destination file is not closed until the procedure completes successfully.
Examples
CREATE OR REPLACE DIRECTORY df AS '+datafile' ;
GRANT WRITE ON DIRECTORY df TO "user";
CREATE DIRECTORY DSK_FILES AS ''^t_work^''
GRANT WRITE ON DIRECTORY dsk_files TO "user";
-- asumes that dbs2 link has been created and we are connected to the instance.
-- dbs2 could be a loopback or point to another instance.
BEGIN -- asm file to an os file -- get an asm file from dbs1.asm/a1 to dbs2.^t_work^/oa5.dat DBMS_FILE_TRANSFER.GET_FILE ( 'df' , 'a1' , 'dbs1', 'dsk_files' , 'oa5.dat' ); -- os file to an os file -- get an os file from dbs1.^t_work^/a2.dat to dbs2.^t_work^/a2back.dat DBMS_FILE_TRANSFER.GET_FILE ( 'dsk_files' , 'a2.dat' , 'dbs1', 'dsk_files' , 'a2back.dat' ); END ; / Oracle. Database PL/SQL Packages and Types Reference 11g Release 2 (11.2) ASMCMD cp Purpose Enables you to copy files between Oracle ASM disk groups and between a disk group and the operating system. You can use the cp command to: Copy files from a disk group to the operating system Copy files from a disk group to a disk group Copy files from the operating system to a disk group rm Purpose Deletes the specified Oracle ASM files and directories. Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)
Q92. What does a high “gc current block busy” event value indicate?
A. Access to cached data blocks was delayed because they were busy either in the remote or the local cache.
B. A large number of requested blocks were not cached In any instance.
C. Asynchronous input/output (I/O) is disabled.
D. Delay in processing has occurred In the GCS, caused by CPU saturation and would have to be solved by additional CPUs and load-balancing.
Answer: A
Explanation: The gc current block busy wait event indicates that the access to cached data blocks was delayed because they were busy either in the remote or the local cache. This could be caused by any of the following:
.The blocks were pinned
The blocks were held up by sessions The blocks were delayed by a log write on a remote instance A session on the same instance was already accessing a block which was in transition between instances and the current session needed to wait behind it (for example, gc current block busy)
Oracle Real Application Clusters Administration and Deployment Guide
Q93. You are managing a single-instance database and your company wants to convert the single instance database to an Oracle RAC database. You plan to use the rconfig utility to accomplish this task.
What are the prerequisites for converting the single-instance database to an Oracle RAC database?
A. Oracle Clusterware and Oracle Database software are installed on all target nodes.
B. The Oracle Database binary is enabled for Oracle RAC on all target nodes.
C. The database being converted has been backed up successfully.
D. Oracle Clusterware is stopped.
E. Automatic Storage Management (ASM) must be enabled and the ASM disk should be available on all nodes.
Answer: C
Explanation:
C.3.1 Prerequisites for Converting to Oracle RAC Databases Before you convert a single-instance database to an Oracle RAC database, ensure that the following conditions are met for each cluster node that you intend to make an Oracle RAC database node:
Oracle Clusterware 11g release 2 (11.2) is installed, configured, and running.
Oracle RAC 11g release 2 (11.2) software is installed.
The Oracle binary is enabled for Oracle RAC.
Shared storage, either Oracle Cluster File System or Oracle ASM, is available and accessible from all nodes.
User equivalence exists for the oracle account.
If you intend to use Oracle Enterprise Manager, then all Oracle Enterprise Manager agents are configured and running, and are configured with cluster and host information.
You have backed up your existing database.
Oracle. Real Application Clusters Installation Guide
11g Release 2 (11.2) for Linux and UNIX
Replace 1Z0-058 braindumps:
Q94. You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to your cluster nodes.
You have already been prompted for the first set of nodes and you replied with node names RACNODE1 RACNODE2, and RACNODE3.
Which two statements are true about the procedure for minimizing down time?
A. The patch must be propagated to, applied, and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
B. When the first set of nodes has been patched, the instances on the remaining nodes are shut down automatically by opatch.
C. The instances must be started on the first set of nodes and then stopped on the remaining set to make certain that some nodes are always available.
D. When the first set of nodes has been patched, the administrator is prompted to shut down the instances on the remaining nodes.
E. The patch must be propagated to and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
Answer: D,E
Explanation:
Installing a Patch with Minimum Down Time with OPatch In minimum down-time patching, the nodes are divided into two sets. One set of nodes is shut down and the patch is applied to those nodes. After the first set of nodes has been patched, the second set of nodes is shut down. The first set of nodes is then restarted and the patch is applied to the second set of nodes. After the patch has been applied to the second set of nodes, those nodes are restarted. This method leads to less down time for Oracle RAC, compared to having all the nodes shut down at the same time. When you use the minimum down-time patching method, the following actions occur: The local node is always patched first. The local node is used as a base to patch the other nodes. The user is prompted for the first set of nodes to patch. For each node in this first set, the user is asked to stop the instance and then the patch is propagated and applied to that node before continuing to the next node. When the first set of nodes has been patched, the user is asked to shut down Clusterware on the remaining nodes. The instances are stopped on the last set of remote nodes. The patch is propagated to the last set of nodes and the inventory is updated. You can then start up the patched nodes (the first set of nodes) before patching the remaining nodes.
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 4 – 44
Q95. Which four statements about mounting ASM cluster file systems are true?
A. An ACFS volume can be mounted by using ASMCA.
B. The standard Linux/UNIX mount command can be used to mount an ACFS volume, provided the ACFS type is specified; (mount -t acfs).
C. ACFS volumes can be mounted by using the ASMCMD utility.
D. The acfsmountvol command can be used to mount ACFS volumes on Windows platforms.
E. Oracle Enterprise Manager can be used to mount ACFS volumes.
Answer: A,B,D,E
Explanation: . Oracle ASM Configuration Assistant enables you to create or configure an Oracle ACFS file system. Some commands require root privileges, such as mounting a file system. Oracle ASM Configuration Assistant generates the command for you to run manually as root or as a privileged user.
There are buttons for Create, Show Mount All, and Show Dismount All commands . mount attaches a file system to the Oracle ACFS hierarchy at the mount point that is the name of a directory. The mount happens on the node where the mount command was issued. The mount command returns an error if the file system is not in a dismounted state on this node root privilege is required to run mount. . acfsmountvol attaches an Oracle ACFS to the file system hierarchy at the specified path name or drive letter. dir must be an empty directory. Oracle ACFS mount points can be created on any empty directory and they can be hierarchical (nested).
Windows Administrator privileges are required to mount an Oracle ACFS . ASM Cluster File System tab in Oracle Enterprise Manager. This tab lists all of the Oracle ACFS associated with the Oracle ASM instance.
On this page, you can choose to mount, dismount, delete, create snapshot, view content, register, and deregister a selected file system. In addition, you can create a file system, mount all file systems, or dismount all file systems.
Oracle. Automatic Storage Management Administrator's Guide
Q96. Examine the following output:
[oracle@gr5153~]$srvctl add service -d RACDB -s erp -g pool1 -c uniform -y manual [oracle0gr5153~]$srvctl start service -d RACDB -s ERP [oracle@gr5153~]$crsctl stat res ora.racdb.erp.svc NAME=ora.racdb.erp.svc
TYPE=ora.service.type
TARGET=ONLINE, ONLINE, ONLINE STATE=ONLINE on gr5118, ONLINE on gr5152,
ONLINE on gr5153
[oracle@gr5153~]$ srvctl config database -d RACDB
Database unique name: RACDB
Database name: RACDB
Oracle home:/u01/app/oracle/product/11.2.0/dbhome_1
Oracle user:oracle
Spfile:+DATA/RACDB/spfileRACDB.ora
Domain:
Start options:open
Stop options:immediate
Database role:PRIMARY
Management policy:AUTOMATIC
Server pools:POOL 1 Database instances:
Disk Groups:DATA, FRA
Services:ERP
Database is policy managed
$srvctl stop database -d RACDB -o immediate
Which two statements are true regarding the srvctl stop command?
A. It will shut down all the instances of the RACDB database.
B. It will shut down only the RACDB instance and the ERP service on the node on which the Command is executed.
C. It will shut down only the database instance on the node on which the command is executed.
D. It will stop the ERP service related to the RACDB database on all the nodes.
Answer: A,D
Explanation: Shut down all Oracle RAC instances on all nodes. To shut down all Oracle RAC instances for a database, enter the following command, where db_name is the name of the database: srvctl stop database -d db_name Stops a database, its instances, and its services. When the database later restarts, services with AUTOMATIC management start automatically but services with MANUAL management policy must be started manually.
Oracle Real Application Clusters Administration and Deployment Guide
Q97. Which four statements are true about services and connection load balancing?
A. Services provide the ability to balance client connections across the instances in an Oracle RAC configuration.
B. There are two types of load balancing that you can implement; load balancing decisions can be made by the client and by the listener.
C. In a RAC database environment, you should select only one load balancing method.
D. With server-side load balancing, the listener directs a connection request to the best instance that is currently providing the service based on the load-balancing options selected by the DBA.
E. Client-side load balancing balances the connection requests across the listeners.
Answer: A,B,D,E
Explanation:
Services and Connection Load Balancing
The two load balancing methods that you can implement are:
– Client-side load balancing: Balances the connection requests across the listeners
– Server-side load balancing: The listener directs a connection request to the best instance currently providing the service by using the load balancing advisory (LBA).
FAN, Fast Connection Failover, and LBA depend on a connection load balancing configuration that includes setting the connection load balancing goal for the service.
The load balancing goal for the service can be either:
– LONG: For applications having long-lived connections. This is typical for connection pools and SQL*Forms sessions.
– SHORT: For applications that have short-lived connection
Oracle Net Services provides the ability to balance client connections across the instances in an Oracle RAC configuration. You can implement two types of load balancing: client-side and server-side.
Client-side load balancing balances the connection requests across the listeners.
With server-side load balancing, the listener directs a connection request to the best instance currently providing the service by using the load balancing advisory.
In a RAC database, client connections should use both types of connection load balancing.
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 – 12