Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Database Administration for Microsoft SQL Server DBAs part 33 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 302 Oracle Database Administration for Microsoft SQL Server DBAs Deleting here might be useful for backups but definitely not something you would want to do with database files. These are the options that are available with the asmcmd utility. Viewing ASM Information When connected to the ASM instance some v views give information about the instances connected disks that might not be part of a disk group and files. For example the v asm_disk view shows the disks that are being used by that database instance and when viewed from the ASM instance it will show all of the disks that are discovered. Table 10-2 lists some of the ASM v views. View Logged in to ASM Instance Logged in to Database Instance v asm client Shows a row for each database instance using ASM Shows a row for the ASM instance for the database v asm disk Shows all of the disks that are discovered Shows only the disks in the disk groups being used by this instance v asm diskgroup Shows all of the disk groups that are discovered Shows the disk groups that are available in the ASM v asm file Shows the files for each disk group mounted Shows the files for the instance v asm _operation Shows the file for each long-running operation executing in the ASM instance Shows no rows TABLE 10-2. Some ASM v Views Chapter 10 High-Availability Architecture 303 Here are some examples of using SQL Plus to take a look at the views in ASM making sure the environment is set up to log in export ORACLE_SID ASM export ORACLE_HOME u01 oracle 11.2.0 grid SQLPLUS select name state total_mb from v asm_disgroup NAME STATE TOTALMB DGDATA01 MOUNTED 349962 DGDATA02 MOUNTED 349942 SQLPLUS select name from v asm_disk NAME ORADATA01 ORADATA02 ORADATA03 ORADATA04 SQLPLUS select instance_name db_name status from v ASM_CLIENT SQL select group_number instance_name db_name status from v ASM_CLIENT GROUP_NUMBER INSTANCE_NAME DB_NAME STATUS 1 DBDEV DBDEV CONNECTED 2 DB01 DB01 CONNECTED 1 ASM ASM CONNECTED 2 ASM ASM CONNECTED 4 rows selected. .
