Shulou(Shulou.com)06/01 Report--

In Oracle 10g, the information of the ASM disk group can only be queried through the internal view after Mount. If the disk group cannot be loaded normally because of a fault, the information will not be available, which brings a lot of inconvenience to the diagnosis of ASM related faults.

Oracle provides AMDU in 11g to assist in diagnostics, and before the ASM disk is loaded, ASM metadata can be extracted from the disk for database diagnostics. This tool is backward compatible and introduced to 10g.

How to use it:

[grid@dbhost01 ~] $amdu-diskstring'/ dev/asmdisk*'

Amdu_2019_08_09_11_04_26/

[grid@dbhost01 ~] $cd amdu_2019_08_09_11_04_26/

[grid@dbhost01 amdu_2019_08_09_11_04_26] $ls-l

Total 8

-rw-r--r-- 1 grid oinstall 5367 Aug 9 11:04 report.txt

[grid@dbhost01 amdu_2019_08_09_11_04_26] $more report.txt

-*-amdu-*-

* * AMDU Settings * *

ORACLE_HOME = / u01/app/11.2.0/grid

System name: Linux

Node name: dbhost01

Release: 3.10.0-862.el7.x86_64

Version: # 1 SMP Wed Mar 21 18:14:51 EDT 2018

Machine: x86_64

Amdu run: 09-AUG-19 11:04:26

Endianess: 1

The process of extracting the entire database file is as follows:

1. Locate the number of the control file in the ASM file system in the alarm log

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

And Real Application Testing options.

ORACLE_HOME = / u01/app/oracle/product/11.2.0/db_1

System name: Linux

Node name: dbhost01

Release: 3.10.0-862.el7.x86_64

Version: # 1 SMP Wed Mar 21 18:14:51 EDT 2018

Machine: x86_64

VM name: VMWare Version: 6

Using parameter settings in server-side pfile / u01/app/oracle/product/11.2.0/db_1/dbs/initorcl1.ora

System parameters with non-default values:

Processes = 150

Spfile = "+ DATA/orcl/spfileorcl.ora"

Memory_target = 1584m

Control_files = "+ DATA/orcl/controlfile/current.260.1008261229"

Db_block_size = 8192

Compatible = "11.2.0.4.0"

Cluster_database = TRUE

Db_create_file_dest = "+ DATA"

Thread = 1

Undo_tablespace = "UNDOTBS1"

Instance_number = 1

Remote_login_passwordfile= "EXCLUSIVE"

Db_domain = ""

Dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"

Remote_listener = "myrac-cluster-scan:1521"

Audit_file_dest = "/ u01/app/oracle/admin/orcl/adump"

Audit_trail = "DB"

Db_name = "orcl"

Open_cursors = 300

Diagnostic_dest = "/ u01/app/oracle"

two。 Extraction control file

[grid@dbhost01 amdu_2019_08_09_11_04_26] $amdu-extract + DATA.260

AMDU-00108: file name invalid [+ DATA.260]

[grid@dbhost01 amdu_2019_08_09_11_04_26] $amdu-extract DATA.260

Amdu_2019_08_09_14_20_11/

AMDU-00210: No disks found in diskgroup DATA

AMDU-00210: No disks found in diskgroup DATA

[grid@dbhost01 amdu_2019_08_09_11_04_26] $amdu-diskstring "/ dev/asmdisk*"-extract DATA.260

Amdu_2019_08_09_14_20_42/

[grid@dbhost01 amdu_2019_08_09_11_04_26] $ls-l amdu_2019_08_09_14_20_42

Total 18072

-rw-r--r-- 1 grid oinstall 18497536 Aug 9 14:20 DATA_260.f

-rw-r--r-- 1 grid oinstall 7306 Aug 9 14:20 report.txt

[grid@dbhost01 amdu_2019_08_09_11_04_26] $

[grid@dbhost01 amdu_2019_08_09_11_04_26] $

[grid@dbhost01 amdu_2019_08_09_11_04_26] $

3. Get data files, logs and other information from control files

[grid@dbhost01 amdu_2019_08_09_14_20_42] $strings DATA_260.f | grep + DATA > DATAFILE_ORCL.txt

[grid@dbhost01 amdu_2019_08_09_14_20_42] $

[grid@dbhost01 amdu_2019_08_09_14_20_42] $ls-l

Total 18076

-rw-r--r-- 1 grid oinstall 18497536 Aug 9 14:20 DATA_260.f

-rw-r--r-- 1 grid oinstall 987 Aug 9 14:23 DATAFILE_ORCL.txt

-rw-r--r-- 1 grid oinstall 7306 Aug 9 14:20 report.txt

[grid@dbhost01 amdu_2019_08_09_14_20_42] $more DATAFILE_ORCL.txt

+ DATA/orcl/onlinelog/group_2.262.1008261231

+ DATA/orcl/onlinelog/group_1.261.1008261231

4. According to the output of step 3, extract log files, data files, etc.

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.259

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.258

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.257

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.256

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.263

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.264

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.265

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.266

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.267

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.262

Amdu-diskstring "/ dev/asmdisk*"-extract DATA.261

5. Create a new instance, use the extracted control files, and launch to mount

And start the database using alter database rename file renaming and so on.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.