1Z0-058 | Down to date Oracle 1Z0-058 dumps
Q11. You decide to create a snapshot of your ACFS for backup and recovery purposes. Which two tools are available to do this?
A. ASMCMD
B. SQL*Plus
C. ACFSUTIL
D. ADVMUTIL
E. Enterprise Manager
Answer: C,E
Explanation:
About Oracle ACFS Snapshots Oracle ACFS snapshots are administered with the acfsutil snap commands. For information about the acfsutil snap commands, refer to "acfsutil snap create", "acfsutil snap delete", and "acfsutil snap info".
You can also manage Oracle ACFS snapshots with Oracle Enterprise Manager. For information about using Oracle Enterprise Manager, see "Managing Oracle ACFS Snapshots with Oracle Enterprise Manager".
Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)
Q12. Your Apache-based application resource called MyApp has a VIP application resource definition and an application resource definition.
The application is administrator managed and is currently active on nodeRACNODE3.
You want to move it to host RACNODE4, which is one of the HOSTING_MEMBERS in the resource definition.
What is the most efficient method to move the application and the VIP?
A. Run crsctl relocate resource MyApp - n RACNODE4 - f.
B. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl start MyApp -n RACNODE4 -f.
C. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl relocate resource MyApp –n RACNODE4.
D. Run crsctl relocate resource MyApp -n RACNODE4.
Answer: A
Explanation:
Relocating Applications and Application Resources
Use the crsctl relocate resource command to relocate applications and application resources. For example, to relocate the Apache Web server application to a server named rac2, run the following command: # crsctl relocate resource myApache -n rac2 Each time that the action program is called, the crsctl relocate resource command waits for the duration specified by the value of the SCRIPT_TIMEOUT resource attribute to receive notification of success or failure from the action program. A relocation attempt fails if: The application has required resources that run on the initial server Applications that require the specified resource run on the initial server To relocate an application and its required resources, use the -f option with the crsctl relocate resource command. Oracle Clusterware relocates or starts all resources that are required by the application regardless of their state. Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q13. Which two Cluster ware stack administration actions must be performed as the root user?
A. checking the health of the Clusterware on one node
B. starting the Clusterware manually on one node
C. disabling the Clusterware from automatic start at node reboot
D. checking the health and viability of the Clusterware on all nodes
E. listing the location of the voting disks
Answer: B,C
Explanation:
Controlling Oracle Clusterware The crsctl utility can be used to control Oracle Clusterware. To start or stop Oracle Clusterware on a specific node: # crsctl start crs # crsctl stop crs To enable or disable Oracle Clusterware on a specific node: # crsctl enable crs # crsctl disable crs
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 - 5
Q14. The original cluster on RACNODE1, RACNODE 2, RACNODE 3, and RACNODE4 had the Oracle Grid Infrastructure installed to support Grid Naming Service (GNS).
What should be done to verify that the two new nodes called RACNODE5, RACNODE6 are physically connected?
A. cluvfy stage -post crsinst -n RACNODE5,RACNODE6 -verbose
B. cluvfy stage -post nodeadd -n RACNODE5,RACNODE6 -verbose
C. cluvfy stage -post hacfg -verbose
D. cluvfy stage -post nodeadd -n all –verbose
Answer: B
Explanation:
Completing OUI Silent Node Addition Perform integrity checks on the cluster. [grid@host01]$ cluvfy stage –post nodeadd –n host03 -verbose D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 4 - 8
Q15. You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?
A. advmutil
B. asmcmd
C. fsck
D. acfsutil
E. fdisk
Answer: C
Explanation:
Dismounting an Oracle ACFS File System You can dismount a file system without deregistering the file system or disabling the volume on which the file system is mounted. For example, you can dismount a file system and run fsck to check the file system. # /bin/umount /u01/app/acfsmounts/myacfs # /sbin/fsck -a -v -y -t acfs /dev/asm/volume1-123 After you dismount a file system, you must explicitly mount the file system.
1. Use umount on Linux systems or acfsdismount on Windows systems. For information about the commands to dismount a file system, see "umount" or "acfsdismount".
2. Use fsck on Linux systems or acfschkdsk on Windows systems to check a file system. For information about the commands to check a file system, see "fsck" or "acfschkdsk".
Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)
Q16. You installed the Oracle Grid Infrastructure on a four-node cluster before discussing the network requirements with the network administrator who was on holiday.
You created a single scan named mydb-scan.myclust.example.com by adding this name to the /etc/hosts file. As a result, the Grid Infrastructure has four node listeners and node VIP but only a single SCAN listener and SCAN VIP.
The network administrator has returned and modified the corporate DNS server to associate three IP addresses with the mydb-scan.myclust.example.com scan name. The SCAN VIPs are on the same network as the node VIPs.
You now must replace the single SCAN VIP and listener with three of each for high availability purposes and make certain that the SCANs and listeners are active. Which procedure will do this properly if run as the root user?
A. srvctl stop scan_listener srvctl stop scan srvctl start scan srvctl start scan_listener
B. srvctl stop scan_listener srvctl stop scan srvctl remove scan srvctl add scan -n MYDB-SCAN.MYCLUST.EXAMPLE.COM srvctl start scan srvctl start scan_listener
C. srvctl add scan -n MYDB-SCAN.MYCLUST.EXAMPLE.COM srvctl start scan srvctl start scan_listener
D. srvctl stop scan_listener srvctl stop scan srvctl remove scan srvctl add scan srvctl start scan srvctl start scan listener
Answer: B
Explanation:
How to update the IP address of the SCAN VIP resources (ora.scan.vip) [ID 952903.1]
Modified 03-JAN-2012 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.1 - Release: 11.2 to 11.2
Information in this document applies to any platform.
Goal
The purpose of this document is to explain how to change the IP addresses associated with the SCAN VIPs in a 11gR2 Grid (CRS) environment.
The IP addresses associated with the SCAN VIP resources are initially set when the SCAN resources are created.
Any changes to the DNS entry for the SCAN are not automatically propagated to the clusterware and need to be done manually.
This applies only to installations that are not using GNS.
The information in this note can also be helpful in cases where SCAN was originally configured with just one address and is now being expanded to accommodate three IP addresses.
Solution
Before the SCAN VIPs can be changed, the entry for the SCAN name on the Domain
Name Server (DNS) needs to be updated with the new IP addresses. This usually will be done by a network administrator. To check the current setting, the following command can be used:
nslookup <scan_name>
To check the current IP address(es) of the SCAN VIPs, run the following commands as the root user:
$GRID_HOME/bin/srvctl config scan
Next refresh the SCAN VIPs with the new IP addresses from the DNS entry:
$GRID_HOME/bin/srvctl modify scan -n <scan_name>
To check if the SCAN VIPs have been changed, run the following command, it should now show the new IP addresses.
$GRID_HOME/bin/srvctl config scan
Below is an example using the following configuration:
The name of the SCAN is sales-scan.example.com
subnet of the public network is 10.100.10.0
netmask for the public network is 255.255.255.0
name of the public interface is eth1
old IP addresses: 10.100.10.81, 10.100.10.82 & 10.100.10.83
new IP addresses: 10.100.10.121, 10.100.10.122 & 10.100.10.123
A lookup of the SCAN on the DNS server shows that the entry has already been updated
with the new IP addresses:
$ nslookup sales-scan.example.com Server: dns1.example.com Address: 10.100.10.70#53 Name: sales-scan.example.com Address: 10.100.10.123 Name: sales-scan.example.com Address: 10.100.10.122 Name: sales-scan.example.com Address: 10.100.10.121
Stop the SCAN listener and the SCAN VIP resources: # $GRID_HOME/bin/srvctl stop scan_listener # $GRID_HOME/bin/srvctl stop scan # $GRID_HOME/bin/srvctl status scan SCAN VIP scan1 is enabled SCAN VIP scan1 is not running SCAN VIP scan2 is enabled SCAN VIP scan2 is not running SCAN VIP scan3 is enabled SCAN VIP scan3 is not running # $GRID_HOME/bin/srvctl status scan_listener SCAN Listener LISTENER_SCAN1 is enabled SCAN listener LISTENER_SCAN1 is not running SCAN Listener LISTENER_SCAN2 is enabled SCAN listener LISTENER_SCAN2 is not running SCAN Listener LISTENER_SCAN3 is enabled SCAN listener LISTENER_SCAN3 is not running
The SCAN VIP resources still show the old IP addresses: # $GRID_HOME/bin/srvctl config scan SCAN name: sales-scan, Network: 1/10.100.10.0/255.255.255.0/eth1 SCAN VIP name: scan1, IP: /sales-scan.example.com/10.100.10.81 SCAN VIP name: scan2, IP: /sales-scan.example.com/10.100.10.82 SCAN VIP name: scan3, IP: /sales-scan.example.com/10.100.10.83
Now tell CRS to update the SCAN VIP resources: # $GRID_HOME/bin/srvctl modify scan -n sales-scan.example.com
To verify that the change was successful, check the SCAN configuration again: # $GRID_HOME/bin/srvctl config scan SCAN name: sales-scan, Network: 1/10.100.10.0/255.255.255.0/eth1 SCAN VIP name: scan1, IP: /sales-scan.example.com/10.100.10.121 SCAN VIP name: scan2, IP: /sales-scan.example.com/10.100.10.122 SCAN VIP name: scan3, IP: /sales-scan.example.com/10.100.10.123
Start SCAN and the SCAN listener: # $GRID_HOME/bin/srvctl start scan # $GRID_HOME/bin/srvctl start scan_listener
Please note that if the SCAN VIPs are being changed because of a change of the subnet of the public network additional changes may be required , e.g. the node VIPs and the network resource (ora.net1.network). For more information please refer to Document 276434.1 and the 11.2 documentation. My Oracle Support
Q17. Which three statements are true about ASM performance and scalability?
A. Disks in a diskgroup may be of varying speed and capacity without affecting performance.
B. Disks in a diskgroup should match in speed and capacity for best performance.
C. A database seldom needs more than two diskgroups: one for data and the other for a fast recovery area.
D. A database needs a separate diskgroup for each major tablespace, redo logs, and fast recovery area.
E. Multiple databases that use the same diskgroup make the best use of space.
F. Multiple databases that use a separate diskgroup for each database make the best use of space.
Answer: B,C,E
Explanation: Section: (none)
Performance, Scalability, and Manageability Considerations for Disk Groups
Create separate disk groups for database files and fast recovery area.
Disks in a disk group should have the same size and performance characteristics.
– Allows the disk group to deliver consistent performance
– Allows ASM to use disk space most effectively
– Allows operations with different storage requirements to be matched with different disk groups effectively
Using separate disk groups for each database as opposed to having multiple databases in a disk group has various benefits and drawbacks. Housing multiple databases in a single disk group affords the most efficient use of space. However, any faults or maintenance that affects the disk group may affect many databases. Separate disk groups provide greater isolation from the effects of a fault or maintenance operation. However, to achieve this may consume more disk space and may require more disk group maintenance to balance disk resources.
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 8 - 37
Q18. The Oracle Grid Infrastructure administrator decides to make more copies of the voting disks that are currently stored in the ASM disk group +VOTE. How can this be done?
A. by running crsctl add css votedisk <path_to_new_voting_disk> to make a copy to a shared location on a shared device or file system
B. by running crsctl add css votedisk +VOTE, thereby adding another copy of the voting disk to the +VOTE disk group
C. by running srvctl replace votedisk +asm_disk_group on another disk group that has greater redundancy, thereby causing additional copies to be created
D. by running crsctl replace votedisk +asm_disk_group on another disk group that has greater redundancy, thereby causing additional copies to be created
Answer: D
Explanation:
Storing Voting Disks on Oracle ASM Using the crsctl replace votedisk command, you can move a given set of voting disks from one Oracle ASM disk group into another, or onto a certified file system. If you move voting disks from one Oracle ASM disk group to another, then you can change the number of voting disks by placing them in a disk group of a different redundancy level as the former disk group. Notes: You cannot directly influence the number of voting disks in one disk group. You cannot use the crsctl add | delete votedisk commands on voting disks stored in Oracle ASM disk groups because Oracle ASM manages the number of voting disks according to the redundancy level of the disk group. You cannot add a voting disk to a cluster file system if the voting disks are stored in an Oracle ASM disk group. Oracle does not support having voting disks in Oracle ASM and directly on a cluster file system for the same cluster at the same time.
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q19. You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations.
Which two recommendation would you make to reduce this problem?
A. shorter transactions
B. using hash partitioned global indexes
C. uniform and large extent sizes
D. automatic segment space management
E. smaller extent sizes
F. increasing sequence cache sizes
Answer: D,F
Q20. Which two statements are true regarding undo management in the RAC environment?
A. You can use Automatic Undo Management (AUM) in some of the instances and manual undo management in the rest of the instances in a RAC database.
B. In a policy-managed RAC database, Oracle automatically allocates the undo tablespace even the Oracle Managed Files (OMF) is disabled in a database.
C. In a policy-managed RAC database, Oracle automatically allocates the undo tablespace if the database is OMF enabled.
D. You can dynamically switch undo tablespace assignments by executing the ALTER SYSTEM SET UNDO_TABLESPACE statement from any instance in a administrator managed database.
Answer: C,D
Explanation: You assign undo tablespaces in your Oracle RAC administrator-managed database by specifying a different value for the UNDO_TABLESPACE parameter for each instance in your SPFILE or individual PFILEs. For policy-managed databases, Oracle automatically allocates the undo tablespace when the instance starts if you have Oracle Managed Files enabled. You can switch from using one undo tablespace to another. Because the UNDO_TABLESPACE initialization parameter is a dynamic parameter, the ALTER SYSTEM SET statement can be used to assign a new undo tablespace.