自己造成的一个案例：
场景：ocr磁盘组被我dd掉了，dbfile磁盘组也被我dd掉了。Rac起不来。之前ocr的DATA磁盘组被替换到了ABC磁盘。所幸的是有备份。
重新加载OCR磁盘
[root@rhel1 ~]# /u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose
defined(@array) is deprecated at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1702.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1702.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1780.
(Maybe you should just omit the defined()?)
2019-05-22 10:31:57: Checking for super user privileges
2019-05-22 10:31:57: User has super user privileges
2019-05-22 10:31:57: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Stop failed, or completed with errors.
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Delete failed, or completed with errors.
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Stop failed, or completed with errors.
You must kill ohasd processes or reboot the system to properly
cleanup the processes started by Oracle clusterware
ADVM/ACFS is not supported on redhat-release-server-7.1-1.el7.x86_64
ACFS-9201: Not Supported
Either /etc/oracle/olr.loc does not exist or is not readable
Make sure the file exists and it has read and execute access
/bin/dd: failed to open ‘’: No such file or directory
Successfully deconfigured Oracle Restart stack
[root@rhel1 ~]# less /etc/oracle/olr.loc
/etc/oracle/olr.loc: No such file or directory
[root@rhel1 ~]# cd /u01/app/11.2.0/grid/
[root@rhel1 grid]# ./root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2019-05-22 10:33:37: Parsing the host name
2019-05-22 10:33:37: Checking for super user privileges
2019-05-22 10:33:37: User has super user privileges
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params --->root.sh执行的是这个脚本
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Adding daemon to inittab ---->（11.2.0.1需要执行dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1）
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
ADVM/ACFS is not supported on redhat-release-server-7.1-1.el7.x86_64
CRS-2672: Attempting to start 'ora.gipcd' on 'rhel1'
CRS-2672: Attempting to start 'ora.mdnsd' on 'rhel1'
CRS-2676: Start of 'ora.gipcd' on 'rhel1' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rhel1'
CRS-2676: Start of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rhel1'
CRS-2676: Start of 'ora.cssdmonitor' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rhel1'
CRS-2672: Attempting to start 'ora.diskmon' on 'rhel1'
CRS-2676: Start of 'ora.diskmon' on 'rhel1' succeeded
CRS-2676: Start of 'ora.cssd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rhel1'
CRS-2676: Start of 'ora.ctssd' on 'rhel1' succeeded
Disk Group DATA already exists. Cannot be created again --->这个磁盘组之前替换后并没有被我dd，所以asm加载失败。
Configuration of ASM failed, see logs for details
Did not succssfully configure and start ASM
CRS-2500: Cannot stop resource 'ora.crsd' as it is not running
CRS-4000: Command Stop failed, or completed with errors.
Command return code of 1 (256) from command: /u01/app/11.2.0/grid/bin/crsctl stop resource ora.crsd -init
Stop of resource "ora.crsd -init" failed
Failed to stop CRSD
CRS-2500: Cannot stop resource 'ora.asm' as it is not running
CRS-4000: Command Stop failed, or completed with errors.
Command return code of 1 (256) from command: /u01/app/11.2.0/grid/bin/crsctl stop resource ora.asm -init
Stop of resource "ora.asm -init" failed
Failed to stop ASM
CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel1'
CRS-2677: Stop of 'ora.ctssd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rhel1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rhel1'
CRS-2677: Stop of 'ora.cssd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel1'
CRS-2677: Stop of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2679: Attempting to clean 'ora.gpnpd' on 'rhel1'
CRS-2681: Clean of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel1'
CRS-2677: Stop of 'ora.gipcd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel1'
CRS-2677: Stop of 'ora.mdnsd' on 'rhel1' succeeded
Initial cluster configuration failed. See /u01/app/11.2.0/grid/cfgtoollogs/crsconfig/rootcrs_rhel1.log for details
[root@rhel1 grid]# /u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force –verbose
defined(@array) is deprecated at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1702.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1702.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1780.
(Maybe you should just omit the defined()?)
2019-05-22 10:38:55: Checking for super user privileges
2019-05-22 10:38:55: User has super user privileges
2019-05-22 10:38:55: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Stop failed, or completed with errors.
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Delete failed, or completed with errors.
CRS-4133: Oracle High Availability Services has been stopped.
ADVM/ACFS is not supported on redhat-release-server-7.1-1.el7.x86_64
ACFS-9201: Not Supported
Successfully deconfigured Oracle Restart stack
[root@rhel1 ~]# vi /u01/app/11.2.0/grid/crs/install/crsconfig_params ----->更改root.sh执行的脚本，在此我修改了asm的组
(
ASM_DISK_GROUP=ABC
ASM_DISCOVERY_STRING=
ASM_DISKS=ORCL:AAA,ORCL:BBB,ORCL:CCC
)
[root@rhel1 grid]# ./root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2019-05-22 10:40:41: Parsing the host name
2019-05-22 10:40:41: Checking for super user privileges
2019-05-22 10:40:41: User has super user privileges
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
ADVM/ACFS is not supported on redhat-release-server-7.1-1.el7.x86_64
CRS-2672: Attempting to start 'ora.gipcd' on 'rhel1'
CRS-2672: Attempting to start 'ora.mdnsd' on 'rhel1'
CRS-2676: Start of 'ora.gipcd' on 'rhel1' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rhel1'
CRS-2676: Start of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rhel1'
CRS-2676: Start of 'ora.cssdmonitor' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rhel1'
CRS-2672: Attempting to start 'ora.diskmon' on 'rhel1'
CRS-2676: Start of 'ora.diskmon' on 'rhel1' succeeded
CRS-2676: Start of 'ora.cssd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rhel1'
CRS-2676: Start of 'ora.ctssd' on 'rhel1' succeeded
ASM created and started successfully.
DiskGroup ABC created successfully.
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-2672: Attempting to start 'ora.crsd' on 'rhel1'
CRS-2676: Start of 'ora.crsd' on 'rhel1' succeeded
Successful addition of voting disk 5967fa6e88834f56bf236d0128957259.
Successful addition of voting disk 49c2405c6c6e4f96bf7a417022905afb.
Successful addition of voting disk 9f7ea2d3d0fc4f94bf9e7fd81a2228d2.
Successfully replaced voting disk group with +ABC.
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 5967fa6e88834f56bf236d0128957259 (ORCL:AAA) [ABC]
2. ONLINE 49c2405c6c6e4f96bf7a417022905afb (ORCL:BBB) [ABC]
3. ONLINE 9f7ea2d3d0fc4f94bf9e7fd81a2228d2 (ORCL:CCC) [ABC]
Located 3 voting disk(s).
CRS-2673: Attempting to stop 'ora.crsd' on 'rhel1'
CRS-2677: Stop of 'ora.crsd' on 'rhel1' succeeded
CRS-2679: Attempting to clean 'ora.crsd' on 'rhel1'
CRS-2681: Clean of 'ora.crsd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rhel1'
CRS-2677: Stop of 'ora.asm' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel1'
CRS-2677: Stop of 'ora.ctssd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rhel1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rhel1'
CRS-2677: Stop of 'ora.cssd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel1'
CRS-2677: Stop of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2679: Attempting to clean 'ora.gpnpd' on 'rhel1'
CRS-2681: Clean of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel1'
CRS-2677: Stop of 'ora.gipcd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel1'
CRS-2677: Stop of 'ora.mdnsd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.mdnsd' on 'rhel1'
CRS-2676: Start of 'ora.mdnsd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'rhel1'
CRS-2676: Start of 'ora.gipcd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rhel1'
CRS-2676: Start of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rhel1'
CRS-2676: Start of 'ora.cssdmonitor' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rhel1'
CRS-2672: Attempting to start 'ora.diskmon' on 'rhel1'
CRS-2676: Start of 'ora.diskmon' on 'rhel1' succeeded
CRS-2676: Start of 'ora.cssd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rhel1'
CRS-2676: Start of 'ora.ctssd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rhel1'
CRS-2676: Start of 'ora.asm' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rhel1'
CRS-2676: Start of 'ora.crsd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'rhel1'
CRS-2676: Start of 'ora.evmd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rhel1'
CRS-2676: Start of 'ora.asm' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.ABC.dg' on 'rhel1'
CRS-2676: Start of 'ora.ABC.dg' on 'rhel1' succeeded
rhel1 2019/05/22 10:46:57 /u01/app/11.2.0/grid/cdata/rhel1/backup_20190522_104657.olr
Preparing packages...
cvuqdisk-1.0.7-1.x86_64
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3054 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
[root@rhel1 grid]#
节点二执行相同步骤。
可是查看asm磁盘组的时候，之前的dbfile与FRA磁盘的信息却不在了。
[grid@rhel2 ~]$ asmcmd
ASMCMD> ls
ABC/
ASMCMD> exit
两个节点分别执行前面的操作
还原OCR磁盘
[root@rhel2 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
[root@rhel1 grid]# ll /u1/ocrdisk/ ---->查看自动备份ocr的信息，其中/u1/ocrdisk/备份路径是我之前定义的，
backup00.ocr day.ocr
backup01.ocr ocr
backup02.ocr week_.ocr
backup_20190507_111618.ocr week.ocr
backup_20190521_161536.ocr
[root@rhel1 grid]# ./bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2032
Available space (kbytes) : 260088
ID : 849232275
Device/File Name : +ABC
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@rhel1 grid]# ./bin/ocrconfig -showbackup
PROT-24: Auto backups for the Oracle Cluster Registry are not available
PROT-25: Manual backups for the Oracle Cluster Registry are not available
[root@rhel1 grid]# ./bin/crsctl start crs -excl
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.gipcd' on 'rhel1'
CRS-2672: Attempting to start 'ora.mdnsd' on 'rhel1'
CRS-2676: Start of 'ora.mdnsd' on 'rhel1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rhel1'
CRS-2676: Start of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rhel1'
CRS-2676: Start of 'ora.cssdmonitor' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rhel1'
CRS-2679: Attempting to clean 'ora.diskmon' on 'rhel1'
CRS-2681: Clean of 'ora.diskmon' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'rhel1'
CRS-2676: Start of 'ora.diskmon' on 'rhel1' succeeded
CRS-2676: Start of 'ora.cssd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'rhel1'
CRS-2676: Start of 'ora.ctssd' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'rhel1'
CRS-2676: Start of 'ora.asm' on 'rhel1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'rhel1'
CRS-2676: Start of 'ora.crsd' on 'rhel1' succeeded
[root@rhel1 grid]# ll /u1/ocrdisk/ ---->这是之前的ocr备份，通过该备份还原
backup00.ocr day.ocr
backup01.ocr ocr
backup02.ocr week_.ocr
backup_20190507_111618.ocr week.ocr
backup_20190521_161536.ocr
[root@rhel1 grid]# ll /u1/ocrdisk/backup00.ocr
-rw------- 1 root root 7012352 May 20 16:37 /u1/ocrdisk/backup00.ocr
[root@rhel1 grid]# ./bin/ocrconfig -restore /u1/ocrdisk/backup00.ocr
PROT-19: Cannot proceed while the Cluster Ready Service is running
[root@rhel1 grid]# ./bin/crsctl stop resource ora.crsd –init
CRS-2673: Attempting to stop 'ora.crsd' on 'rhel1'
CRS-2677: Stop of 'ora.crsd' on 'rhel1' succeeded
CRS-2679: Attempting to clean 'ora.crsd' on 'rhel1'
CRS-2681: Clean of 'ora.crsd' on 'rhel1' succeeded
[root@rhel1 grid]# ./bin/ocrconfig -restore /u1/ocrdisk/backup00.ocr
[root@rhel1 grid]# ./bin/crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rhel1'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rhel1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rhel1'
CRS-2673: Attempting to stop 'ora.asm' on 'rhel1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rhel1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'rhel1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rhel1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rhel1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rhel1'
CRS-2677: Stop of 'ora.cssd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rhel1'
CRS-2673: Attempting to stop 'ora.diskmon' on 'rhel1'
CRS-2677: Stop of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2679: Attempting to clean 'ora.gpnpd' on 'rhel1'
CRS-2681: Clean of 'ora.gpnpd' on 'rhel1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rhel1'
CRS-2677: Stop of 'ora.gipcd' on 'rhel1' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'rhel1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rhel1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rhel1 grid]# ./bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rhel1 grid]# su - grid
Last login: Wed May 22 10:46:59 CST 2019 on pts/0
[grid@rhel1 ~]$ asmcmd --->如下存在FRA磁盘组。
ASMCMD> ls
ABC/
DATA/
FRA/
ASMCMD>
ocr磁盘组还原成功，之后就是还原数据库。
还原数据库
[grid@rhel1 ~]$ srvctl start database -d ORCL -o nomount
PRCR-1079 : Failed to start resource ora.orcl.db
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DBFILE" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DBFILE"
CRS-2674: Start of 'ora.DBFILE.dg' on 'rhel1' failed
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DBFILE" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DBFILE"
CRS-2674: Start of 'ora.DBFILE.dg' on 'rhel2' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
[grid@rhel1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 22 11:25:00 2019
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create diskgroup DBFILE external redundancy disk 'ORCL:DBFILE' name DBFILE;
Diskgroup created.
[oracle@rhel1 ~]$ cat /u01/app/oracle/product/11.2.0/db_1/dbs/initORCL1.ora --->查看pfile参数文件，调用的是dbfile磁盘组下面的spfile文件。
SPFILE='+DBFILE/ORCL/spfileORCL.ora'
[oracle@rhel1 ~]$ cat /u01/app/oracle/admin/ORCL/pfile/init.ora.3182019191943 --->该目录下会有最开始的参数文件，通过这个打开至nomount状态
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# Cluster Database
###########################################
remote_listener=rhel-cluster-scan.grid.example.com:1521
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_domain=""
db_name=ORCL
###########################################
# File Configuration
###########################################
db_create_file_dest=+DBFILE
db_recovery_file_dest=+FRA
db_recovery_file_dest_size=5218762752
###########################################
# Miscellaneous
###########################################
compatible=11.2.0.0.0
diagnostic_dest=/u01/app/oracle
memory_target=764411904
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Security and Auditing
###########################################
audit_file_dest=/u01/app/oracle/admin/ORCL/adump
audit_trail=db
remote_login_passwordfile=exclusive
###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
control_files=("+DBFILE/orcl/controlfile/current.256.1005931173", "+FRA/orcl/controlfile/current.256.1005931177")
cluster_database=true
ORCL1.instance_number=1
ORCL2.instance_number=2
ORCL2.thread=2
ORCL1.undo_tablespace=UNDOTBS1
ORCL2.undo_tablespace=UNDOTBS2
ORCL1.thread=1
[oracle@rhel1 ~]$ sqlplus "/as sysdba"
SQL > startup nomount pfile='/u01/app/oracle/admin/ORCL/pfile/init.ora.3182019191943'; --->可以将创建成spfile,再复制到asm磁盘文件中。
ORACLE instance started.
Total System Global Area 764121088 bytes
Fixed Size 2217264 bytes
Variable Size 511707856 bytes
Database Buffers 247463936 bytes
Redo Buffers 2732032 bytes
[oracle@rhel1 ~]$ rman target /
RMAN> restore controlfile from '+FRA/orcl/controlfile/current.256.1005931177'; --->因为fra盘并未被我删除。所以控制文件，归档日志文件还存在里面
Starting restore at 22-MAY-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 instance=ORCL1 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=+DBFILE/orcl/controlfile/current.256.1008936907
output file name=+FRA/orcl/controlfile/current.256.1005931177
Finished restore at 22-MAY-19
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 947.01M DISK 00:02:47 14-MAY-19
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20190514T170446
Piece Name: /home/oracle/03u1hntf_1_1.bak
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1240032 14-MAY-19 +DBFILE/orcl/datafile/system.259.1005931193
2 Full 1240032 14-MAY-19 +DBFILE/orcl/datafile/sysaux.260.1005931273
3 Full 1240032 14-MAY-19 +DBFILE/orcl/datafile/undotbs1.261.1005931315
4 Full 1240032 14-MAY-19 +DBFILE/orcl/datafile/undotbs2.263.1005931371
5 Full 1240032 14-MAY-19 +DBFILE/orcl/datafile/users.264.1005931391
6 Full 1240032 14-MAY-19 +DBFILE/orcl/datafile/tbs1.269.1008256827
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 17.70M DISK 00:00:15 14-MAY-19
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20190514T170446
Piece Name: /home/oracle/04u1ho2o_1_1.bak --->刚好在路径下面有备份。
SPFILE Included: Modification time: 14-MAY-19
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1240638 Ckp time: 14-MAY-19
RMAN> restore database;
Starting restore at 22-MAY-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 instance=ORCL1 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DBFILE/orcl/datafile/system.259.1005931193
channel ORA_DISK_1: restoring datafile 00002 to +DBFILE/orcl/datafile/sysaux.260.1005931273
channel ORA_DISK_1: restoring datafile 00003 to +DBFILE/orcl/datafile/undotbs1.261.1005931315
channel ORA_DISK_1: restoring datafile 00004 to +DBFILE/orcl/datafile/undotbs2.263.1005931371
channel ORA_DISK_1: restoring datafile 00005 to +DBFILE/orcl/datafile/users.264.1005931391
channel ORA_DISK_1: restoring datafile 00006 to +DBFILE/orcl/datafile/tbs1.269.1008256827
channel ORA_DISK_1: reading from backup piece /home/oracle/03u1hntf_1_1.bak
channel ORA_DISK_1: piece handle=/home/oracle/03u1hntf_1_1.bak tag=TAG20190514T170446
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:30
Finished restore at 22-MAY-19
RMAN> recover database;
Starting recover at 22-MAY-19
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 66 is already on disk as file +FRA/orcl/archivelog/2019_05_14/thread_1_seq_66.263.1008264651
archived log for thread 1 with sequence 67 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_1_seq_67.262.1008754305
archived log for thread 1 with sequence 68 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_1_seq_68.269.1008756045
archived log for thread 1 with sequence 69 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_1_seq_69.270.1008757911
archived log for thread 1 with sequence 70 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_1_seq_70.272.1008757951
archived log for thread 1 with sequence 71 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_1_seq_71.273.1008762899
archived log for thread 1 with sequence 72 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_1_seq_72.276.1008764651
archived log for thread 1 with sequence 73 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_1_seq_73.277.1008774719
archived log for thread 1 with sequence 74 is already on disk as file +FRA/orcl/archivelog/2019_05_21/thread_1_seq_74.278.1008858631
archived log for thread 1 with sequence 75 is already on disk as file +FRA/orcl/archivelog/2019_05_21/thread_1_seq_75.282.1008863235
archived log for thread 1 with sequence 76 is already on disk as file +FRA/orcl/archivelog/2019_05_21/thread_1_seq_76.283.1008864805
archived log for thread 2 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_2_seq_13.267.1008754309
archived log for thread 2 with sequence 14 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_2_seq_14.268.1008754309
archived log for thread 2 with sequence 15 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_2_seq_15.271.1008757919
archived log for thread 2 with sequence 16 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_2_seq_16.274.1008762921
archived log for thread 2 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2019_05_20/thread_2_seq_17.275.1008762923
archived log for thread 2 with sequence 18 is already on disk as file +FRA/orcl/archivelog/2019_05_21/thread_2_seq_18.279.1008863229
archived log for thread 2 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2019_05_21/thread_2_seq_19.280.1008863233
archived log for thread 2 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2019_05_21/thread_2_seq_20.281.1008863233
archived log file name=+FRA/orcl/archivelog/2019_05_14/thread_1_seq_66.263.1008264651 thread=1 sequence=66
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_2_seq_13.267.1008754309 thread=2 sequence=13
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_1_seq_67.262.1008754305 thread=1 sequence=67
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_2_seq_14.268.1008754309 thread=2 sequence=14
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_1_seq_68.269.1008756045 thread=1 sequence=68
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_2_seq_15.271.1008757919 thread=2 sequence=15
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_1_seq_69.270.1008757911 thread=1 sequence=69
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_1_seq_70.272.1008757951 thread=1 sequence=70
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_2_seq_16.274.1008762921 thread=2 sequence=16
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_1_seq_71.273.1008762899 thread=1 sequence=71
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_2_seq_17.275.1008762923 thread=2 sequence=17
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_1_seq_72.276.1008764651 thread=1 sequence=72
archived log file name=+FRA/orcl/archivelog/2019_05_20/thread_1_seq_73.277.1008774719 thread=1 sequence=73
archived log file name=+FRA/orcl/archivelog/2019_05_21/thread_2_seq_18.279.1008863229 thread=2 sequence=18
archived log file name=+FRA/orcl/archivelog/2019_05_21/thread_1_seq_74.278.1008858631 thread=1 sequence=74
archived log file name=+FRA/orcl/archivelog/2019_05_21/thread_2_seq_19.280.1008863233 thread=2 sequence=19
media recovery complete, elapsed time: 00:00:42
Finished recover at 22-MAY-19
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/22/2019 12:48:55
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file: '+DBFILE/orcl/changetracking/ctf.268.1008159369'
ORA-17502: ksfdcre:4 Failed to create file +DBFILE/orcl/changetracking/ctf.268.1008159369
ORA-15046: ASM file name '+DBFILE/orcl/changetracking/ctf.268.1008159369' is not in single-file creation form
tracking file是优化增量备份的
连接oracle
SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;----->可以先关闭
Database altered.
SQL> alter database open resetlogs;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 2
Next log sequence to archive 3
Current log sequence 3
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
Database altered.
SQL> SELECT STATUS, FILENAME FROM V$BLOCK_CHANGE_TRACKING;---->因为是OMF管理的，可以不用using file来创建
STATUS
--------------------
FILENAME
--------------------------------------------------------------------------------
ENABLED
+DBFILE/orcl/changetracking/ctf.277.1008949385
[grid@rhel1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ABC.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.DATA.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.DBFILE.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.FRA.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.LISTENER.lsnr
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.asm
ONLINE ONLINE rhel1 Started
ONLINE ONLINE rhel2 Started
ora.eons
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.gsd
OFFLINE OFFLINE rhel1
OFFLINE OFFLINE rhel2
ora.net1.network
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.ons
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rhel2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rhel1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rhel1
ora.oc4j
1 OFFLINE OFFLINE
ora.orcl.db
1 ONLINE ONLINE rhel1 Open
2 ONLINE ONLINE rhel2 Open
ora.rhel1.vip
1 ONLINE ONLINE rhel1
ora.rhel2.vip
1 ONLINE ONLINE rhel2
ora.scan1.vip
1 ONLINE ONLINE rhel2
ora.scan2.vip
1 ONLINE ONLINE rhel1
ora.scan3.vip
1 ONLINE ONLINE rhel1