## page was renamed from désert/Oracle/Collectioin
<<TableOfContents()>>

= 本文目的 =
在执行迁移之前, 收集Oracle RAC环境相关信息, 主要为ASM存储和数据库方面的内容.

在开始之前请打开putty或其它ssh远程工具的日志记录, 以便保存相关输出, 并把结果文件拷贝出来.

= RHEL6 Linux =
Linux Login as '''root''' user

== 检查多路径状态 ==

{{{
# multipath -ll
}}}
或者(如果使用EMC存储的PowerPath则使用如下命令)
{{{
# powermt display dev=all

查看 powerpath 版本
# powermt version
}}}

== 查看磁盘的分区和挂载情况 ==

{{{
# blkid; lsblk -o +fstype,label,uuid
# df -hT
}}}

== 查看hosts文件 ==
{{{
# cat /etc/hosts
}}}

== 查看操作系统版本等信息 ==
{{{
# cat /etc/*release; free -m; uname -a
}}}

== 收集sosreport(如果可能) ==
收集完之后的日志文件将打包在/tmp目录
{{{
# sosreport
}}}
示例文件 ''/tmp/sosreport-rac01-20231121153948.tar.xz''

= GRID =
Linux Login as '''grid''' user

== 查看Cluster相关状态 ==
{{{
crsctl status resource -t
ocrcheck
crsctl query css votedisk
}}}

{{{
srvctl config database -a -d 数据库名字(替换为相应的数据库名)
}}}

== 查看ASM磁盘组信息 ==
{{{
$ asmcmd lsdg
}}}
== 查看ASM 磁盘空间使用情况 ==
Linux Login as '''grid''' user
{{{
$ asmcmd lsdsk -k
}}}

== 确认ASM磁盘相关属性 ==
{{{
$ sqlplus / as sysasm
}}}
以下为SQL代码

SQL> 
{{{ 
set linesize 300
column PATH format a60
column NAME format a16

SELECT group_number,disk_number,header_status,mode_status,mount_status,state,total_mb,free_mb,name,path 
FROM v$asm_disk;
}}}


= ORACLE =
Linux Login as '''oracle''' user


== 查看数据库补丁 ==
{{{
$  ''$ORACLE_HOME''/OPatch/opatch lsinventory
}}}

== 查看数据库状态 ==

{{{
$ sqlplus / as sysdba
}}}
以下为SQL代码
SQL> 

{{{
SET linesize 200
COLUMN HOST_NAME FORMAT a30

SELECT name DB_NAME,INSTANCE_NAME,HOST_NAME,OPEN_MODE,version DB_VERSION,DATABASE_STATUS,DATABASE_ROLE,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME"
FROM v$database,gv$instance;
}}}


== 获取数据库文件信息 ==
{{{
SELECT * FROM (
Select name FROM v$datafile UNION ALL
Select name FROM v$tempfile UNION ALL
Select member FROM v$logfile)
ORDER BY name
/
}}}

== 统计外部表数量 ==
{{{
SELECT owner,table_name,default_directory_owner,default_directory_name 
FROM dba_external_tables 
WHERE owner not in ('sys','system','outln','dip','oracle_ocm','dbsnmp','appqossys','wmsys','sysman','mgmt_view');
}}}

== 检查dblink ==

{{{
SELECT * FROM dba_db_links;
}}}


== 复制一份pfile配置文件 ==
{{{
SQL> create pfile='/tmp/pfile.ora' from spfile
}}}
最后将/tmp/pfile.ora文件与sosreport文件(如有)一起打包。