1960.ORACLE RAC 异机rman恢复

张鹏 2024-01-10

169

1960.ORACLE RAC 异机rman恢复
原创代杰2020-07-07

预备知识1：
提示：如果源库、目标库都是RAC，OMF配置，且源库手工添加数据文件，需要更改数据文件名

SET NEWNAME FOR
原创 Oracle 作者：lusklusklusk 时间：2017-07-31 14:11:53 1452 0
SET NEWNAME FOR后面必须带SWITCH DATAFILE ALL或SWITCH TEMPFILE ALL
RUN {
SET NEWNAME FOR DATAFILE 1 to ‘/oracle/ora11g/oradata/system01.dbf’;
SET NEWNAME FOR DATAFILE 2 to ‘/oracle/ora11g/oradata/sysaux01.dbf’;
SET NEWNAME FOR DATAFILE 3 to ‘/oracle/ora11g/oradata/undotbs01.dbf’;
SET NEWNAME FOR DATAFILE 4 to ‘/oracle/ora11g/oradata/users01.dbf’;
SET NEWNAME FOR DATAFILE 5 to ‘/oracle/ora11g/oradata/undotbs02.dbf’;
SET NEWNAME FOR DATAFILE 6 to ‘/oracle/ora11g/oradata/test01.dbf’;
SET NEWNAME FOR TEMPFILE 1 to ‘/oracle/ora11g/oradata/temp01.dbf’;
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
}

run{
set newname for datafile ‘/MM/DataYY.dbf’ to ‘/NN/DataYY.dbf’;
set newname for tempfile ‘/MM/TempYY.dbf’ to ‘/NN/TempYY.dbf’;
restore database;
switch datafile all;
switch tempfile all;
}
MM是原路径，NN是新路径

只转换DATAFILE时如下
run{
set newname for datafile ‘/MM/DataYY.dbf’ to ‘/NN/DataYY.dbf’;
restore database;
switch datafile all;
}

switch datafile all、switch tempfile all的作用就是在控制文件里面把数据文件路径改过了
If you need to restore a data file to a new location, then use the RMAN SET NEWNAME command within a RUN command to specify the new file name. Afterward, use a SWITCH DATAFILE ALL command, which is equivalent to using the SQL statement ALTER DATABASE RENAME FILE, to update the control file to reflect the new names for all data files for which a SET NEWNAME has been issued in the RUN command.

预备知识2:

SET NEWNAME FOR 命令

在做数据恢复时，偶尔会碰到需要对数据文件位置调整的案例，在这种情况下，可以在RMAN中使用SET NEWNAME命令。

在Oracle 11g之前，RMAN只支持SET NEWNAME FOR DATAFILE，在Oracle 11g中增加了SET NEWNAME FOR TEMPFILE/SET NEWNAME FOR TABLESPACE/SET NEWNAME FOR DATABASE的命令。

优先顺序如下：

1.SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE

2.SET NEWNAME FOR TABLESPACE

3.SET NEWNAME FOR DATABASE

当使用SET NEWNAME FOR DATAFILE/TEMPFILE的时候，可以使用下面的SQL生成所有的SET NEWNAME命令：

select ‘set newname for datafile ‘’’ || name ||
‘’’ to ‘’/’ ||
substr(name, instr(name, ‘/’, -1) + 1) || ‘’’;’
from v$datafile order by file#;

当使用FOR TABLESPACE/DATABASE命令的时候，可以指定下面的变量格式：

%b Specifies the file name stripped of directory paths.对应的文件名称

%f Specifies the absolute file number of the data file for which the new name is generated. 数据文件的绝对文件号

%U Specifies the following format: data-D-%d_id-%I_TS-%N_FNO-%f

%I Specifies the DBID 对应的DBID

%N Specifies the tablespace name 对应的表空间名称

其中前面三个变量必须指定一个，后面2个是可选的。

常见的，我们需要保持数据文件一直，值使用%b即可。

eg：

1：SET NEWNAME FOR TABLESPACE

RMAN> sql ‘alter tablespace users offline’;

sql statement: alter tablespace users offline

RMAN> run {
2> set newname for tablespace users to ‘/arch/bentest/oradata/newloc/%b’;
3> restore tablespace users;
4> switch datafile all;
5> }

executing command: SET NEWNAME

Starting restore at 09/30/2013 14:12:27
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1657 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 00004 to /arch/bentest/oradata/newloc/users01.dbf
channel ORA_DISK_1: reading from backup piece /u/ora11g/fast_recovery_area/BENTEST/backupset/2013_09_30/o1_mf_nnndf_TAG20130930T140748_94l59o8x_.bkp
channel ORA_DISK_1: piece handle=/u/ora11g/fast_recovery_area/BENTEST/backupset/2013_09_30/o1_mf_nnndf_TAG20130930T140748_94l59o8x_.bkp tag=TAG20130930T140748
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 09/30/2013 14:12:35

datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=827503955 file name=/arch/bentest/oradata/newloc/users01.dbf

RMAN> recover tablespace users;

Starting recover at 09/30/2013 14:12:48
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 09/30/2013 14:12:48

RMAN> sql ‘alter tablespace users online’;

sql statement: alter tablespace users online

RMAN> report schema;

Report of database schema for database with db_unique_name BENTEST

List of Permanent Datafiles

File Size(MB) Tablespace RB segs Datafile Name

1 325 SYSTEM *** /arch/bentest/oradata/system01.dbf
2 325 SYSAUX *** /arch/bentest/oradata/sysaux01.dbf
3 200 UNDOTBS1 *** /arch/bentest/oradata/undotbs01.dbf
4 500 USERS *** /arch/bentest/oradata/newloc/users01.dbf
5 200 BIGTBS *** /arch/bentest/oradata/bigtbs01.dbf
6 20 WE_WILL_LOST_IT *** /arch/bentest/oradata/wwli.dbf

List of Temporary Files

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

1 20 TEMP 20 /arch/bentest/oradata/temp01.dbf

2：SET NEWNAME FOR DATABASE

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 4175568896 bytes

Fixed Size 2233088 bytes
Variable Size 1224740096 bytes
Database Buffers 2902458368 bytes
Redo Buffers 46137344 bytes

RMAN> run {
2> set newname for database to ‘/arch/bentest/oradata/newloc/%b’;
3> restore database;
4> recover database;
5> }

executing command: SET NEWNAME

Starting restore at 09/30/2013 14:16:15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1081 device type=DISK

skipping datafile 4; already restored to file /arch/bentest/oradata/newloc/users01.dbf
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 /arch/bentest/oradata/newloc/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /arch/bentest/oradata/newloc/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /arch/bentest/oradata/newloc/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /arch/bentest/oradata/newloc/bigtbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /arch/bentest/oradata/newloc/wwli.dbf
channel ORA_DISK_1: reading from backup piece /u/ora11g/fast_recovery_area/BENTEST/backupset/2013_09_30/o1_mf_nnndf_TAG20130930T140748_94l59o8x_.bkp
channel ORA_DISK_1: piece handle=/u/ora11g/fast_recovery_area/BENTEST/backupset/2013_09_30/o1_mf_nnndf_TAG20130930T140748_94l59o8x_.bkp tag=TAG20130930T140748
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 09/30/2013 14:16:31

Starting recover at 09/30/2013 14:16:31
using channel ORA_DISK_1
datafile 4 not processed because file is read-only
datafile 5 not processed because file is read-only

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 09/30/2013 14:16:33

RMAN> report schema;

Report of database schema for database with db_unique_name BENTEST

List of Permanent Datafiles

File Size(MB) Tablespace RB segs Datafile Name

List of Temporary Files

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

1 20 TEMP 20 /arch/bentest/oradata/temp01.dbf

RMAN> run {
2> set newname for database to ‘/arch/bentest/oradata/newloc/%b’;
3> switch datafile all;
4> }

executing command: SET NEWNAME

datafile 1 switched to datafile copy
input datafile copy RECID=7 STAMP=827504182 file name=/arch/bentest/oradata/newloc/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=8 STAMP=827504185 file name=/arch/bentest/oradata/newloc/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=6 STAMP=827504179 file name=/arch/bentest/oradata/newloc/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=827504177 file name=/arch/bentest/oradata/newloc/bigtbs01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=827504178 file name=/arch/bentest/oradata/newloc/wwli.dbf

RMAN> recover database;

Starting recover at 09/30/2013 14:17:59
using channel ORA_DISK_1
datafile 4 not processed because file is read-only
datafile 5 not processed because file is read-only

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 09/30/2013 14:18:01

RMAN> alter database open;

database opened

异机恢复过程
1、源端数据库全备
export DBNAME=orcl
export ORACLE_SID=orcl1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME= $ORACLE_BASE/product/11.2.0.4/db_1 export PATH=$ ORACLE_HOME/bin: $HOME/bin:$ PATH
export BACPATH=/backup/
export LGNAME=rman_backup_date "+%Y-%m-%d".log
rman target / > ${BACPATH}/$ {LGNAME} << EOF
run{
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘ ${BACPATH}/$ {DBNAME}ful%U’;
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
BACKUP FUll DATABASE format ‘ ${BACPATH}/$ {DBNAME}ful_data_file%d_%T_%s_%p_%u’;
sql ‘alter system archive log current’;
backup archivelog all format ‘ ${BACPATH}/$ {DBNAME}arc%U’;
backup current controlfile format ‘ ${BACPATH}/$ {DBNAME}ctl%U’;
backup spfile format ‘ ${BACPATH}/$ {DBNAME}spf%U’;
release channel c1;
}
quit
EOF
2、源端根据spfile创建pfile文件

sqlplus / as sysdba
SQL> create pfile=’/home/oracle/init0703.ora’ from spfile=’+DATA/orcl/spfileorcl.ora’;
File created.

cat pfile=’/home/oracle/init0703.ora’

orcl2.__db_cache_size=507879882752
orcl1.__db_cache_size=498216206336
…
orcl2.undo_tablespace=‘UNDOTBS2’
orcl1.undo_tablespace=‘UNDOTBS1’

目标创建必要的目录
– 在 oracle 用户下创建(所有节点执行)
$ su - oracle
$ mkdir -p /u01/app/oracle/admin/orcl/adump

– 在目标端 grid 用户下在共享设备创建必要的目录（单节点执行即可）
[grid@adg2 ~]$ asmcmd
ASMCMD> ls
DATA/
FRA/
OCR/
ASMCMD> cd DATA
ASMCMD>ls
ASMCMD> mkdir orcl
ASMCMD> cd orcl
ASMCMD> ls
ASMCMD> mkdir CONTROLFILE
ASMCMD> mkdir DATAFILE
ASMCMD> mkdir ONLINELOG
ASMCMD> mkdir PARAMETERFILE

ASMCMD> cd FRA
ASMCMD> ls
ASMCMD> mkdir orcl
ASMCMD> cd orcl
ASMCMD> ls
ASMCMD> mkdir ARCHIVELOG
ASMCMD

参数文件修改
将源端参数文件传到在目标端并编辑 /home/oracle/init0703.ora (参数根据实际情况进行配置)
$ vi /home/oracle/init0703.ora
orcl2.__db_cache_size=507879882752
orcl1.__db_cache_size=498216206336
…
orcl2.undo_tablespace=‘UNDOTBS2’
orcl1.undo_tablespace=‘UNDOTBS1’

这里增加时间格式，按照时间点进行还原时会用到

*.nls_date_format=‘yyyymmddhh24:mi:ss’

创建spfile
在目标端用上述编辑的 pfile.ora 在共享设备上创建spfile
$ sqlplus / as sysdba
SQL> create spfile=’+DATA/orcl/spfileorcl.ora’ from pfile=’/home/oracle/pfile_0702.ora’;

File created.

– 在所有节点上创建 pfile 内容指向共享设备上的spfile文件
节点1：
$[oracle@adg1 ~]$ echo "SPFILE=’+DATA/orcl/spfileorcl.ora’ " > /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl1.ora
[oracle@adg1 ~]$ cat /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl1.ora
SPFILE=’+DATA/orcl/spfileorcl.ora’

节点2：
$[oracle@adg1 ~]$ echo "SPFILE=’+DATA/orcl/spfileorcl.ora’ " > /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl2.ora
[oracle@adg2 ~]$ cat /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl2.ora
SPFILE=’+DATA/orcl/spfileorcl.ora’

创建口令文件
节点1：
$ orapwd file=ORACLE_HOME/dbs/orapworcl1 password=oracle 节点2 orapwd file=$ORACLE_HOME/dbs/orapworcl2 password=oracle
还原控制文件
（在一个节点上执行）
– 数据库启动到 nomount
$ sqlplus / as sysdba
SQL> startup nomount
ORACLE instance started.
Total System Global Area 6062931968 bytes
Fixed Size 2264376 bytes
Variable Size 3305112264 bytes
Database Buffers 2734686208 bytes
Redo Buffers 20869120 bytes
查看监听状态
[oracle@adg1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-JUL-2020 01:43:39

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 03-JUL-2020 08:21:08
Uptime 0 days 17 hr. 22 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/adg1/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.29.143)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.29.145)(PORT=1521)))
Services Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM1”, status READY, has 1 handler(s) for this service…
Service “orcl” has 1 instance(s).
Instance “orcl1”, status BLOCKED, has 1 handler(s) for this service…
The command completed successfully
[oracle@adg1 ~]$

nomount监听状态为BLOCKED

恢复控制文件
[oracle@adg1 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 4 01:44:09 2020

connected to target database: ORCL (not mounted)

RMAN> restore controlfile from ‘/backup/orcl_ctl_07v4c9kn_1_1’;

Starting restore at 04-JUL-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 instance=orcl1 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA/orcl/controlfile/current.257.1044841499
Finished restore at 04-JUL-20

RMAN>

注：不知道哪个文件还原控制文件，可以在源数据库中查看 list backup of controlfile;

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

CATALOG 备份集
– 指定备份集所在的文件目录，进行CATALOG
RMAN> catalog start with ‘/backup/’;

searching for all files that match the pattern /backup/

List of Files Unknown to the Database

File Name: /backup/orcl_ctl_07v4c9kn_1_1
File Name: /backup/orcl_spf_08v4c9ks_1_1

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files…
cataloging done

List of Cataloged Files

File Name: /backup/orcl_ctl_07v4c9kn_1_1
File Name: /backup/orcl_spf_08v4c9ks_1_1

RMAN>

– 如不能正常CATALOG 备份集，按照如下方式手工CATALOG
RMAN> catalog backuppiece ‘/backup/orcl_arc_06v4c9jt_1_1’;

cataloged backup piece
backup piece handle=/backup/orcl_arc_06v4c9jt_1_1 RECID=6 STAMP=1044841679

RMAN> catalog backuppiece ‘/backup/orcl_ctl_07v4c9kn_1_1’;

cataloged backup piece
backup piece handle=/backup/orcl_ctl_07v4c9kn_1_1 RECID=7 STAMP=1044841685

RMAN> catalog backuppiece ‘/backup/orcl_ful_data_file_ORCL_20200703_4_1_04v4c9h8’;

cataloged backup piece
backup piece handle=/backup/orcl_ful_data_file_ORCL_20200703_4_1_04v4c9h8 RECID=8 STAMP=1044841744

RMAN> catalog backuppiece ‘/backup/orcl_spf_08v4c9ks_1_1’;

cataloged backup piece
backup piece handle=/backup/orcl_spf_08v4c9ks_1_1 RECID=9 STAMP=1044841756

RMAN>

11.恢复数据文件

RMAN> restore database;

Starting restore at 04-JUL-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 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 +DATA/orcl/datafile/system.257.1038822139
channel ORA_DISK_1: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.256.1038822141
channel ORA_DISK_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.260.1038822141
channel ORA_DISK_1: restoring datafile 00004 to +DATA/orcl/datafile/users.261.1038822141
channel ORA_DISK_1: restoring datafile 00005 to +DATA/orcl/datafile/undotbs2.266.1038822341
channel ORA_DISK_1: restoring datafile 00006 to +DATA/orcl/datafile/xttstest1.dbf
channel ORA_DISK_1: reading from backup piece /backup/orcl_ful_data_file_ORCL_20200703_4_1_04v4c9h8
channel ORA_DISK_1: piece handle=/backup/orcl_ful_data_file_ORCL_20200703_4_1_04v4c9h8 tag=TAG20200703T095800
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 04-JUL-20

RMAN> recover database;

Starting recover at 04-JUL-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 instance=orcl1 device type=DISK

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=38
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=17
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=18
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=39
channel ORA_DISK_1: reading from backup piece /backup/orcl_arc_06v4c9jt_1_1
channel ORA_DISK_1: piece handle=/backup/orcl_arc_06v4c9jt_1_1 tag=TAG20200703T095924
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=+FRA/orcl/archivelog/2020_07_04/thread_1_seq_38.268.1044842597 thread=1 sequence=38
archived log file name=+FRA/orcl/archivelog/2020_07_04/thread_2_seq_17.267.1044842597 thread=2 sequence=17
archived log file name=+FRA/orcl/archivelog/2020_07_04/thread_2_seq_18.266.1044842599 thread=2 sequence=18
archived log file name=+FRA/orcl/archivelog/2020_07_04/thread_1_seq_39.265.1044842599 thread=1 sequence=39
unable to find archived log
archived log thread=1 sequence=40
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/04/2020 02:03:24
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 40 and starting SCN of 2836216

RMAN> recover database until scn 2836216;

Starting recover at 04-JUL-20
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 04-JUL-20

12.打开数据库

[oracle@adg1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 4 02:04:59 2020

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace ‘UNDOTBS2i’ does not exist or of wrong type
Process ID: 25160
Session ID: 576 Serial number: 21
（参数错误，修改参数）

[oracle@adg1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 4 02:11:51 2020

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size 2253544 bytes
Variable Size 1392512280 bytes
Database Buffers 150994944 bytes
Redo Buffers 7544832 bytes
Database mounted.
SQL> create pfile=’/home/oracle/pfile0707.ora’ from spfile;

File created.

[oracle@adg1 ~]$ vim pfile0707.ora
[oracle@adg1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 4 02:14:07 2020

Connected to an idle instance.

SQL> startup pfile=’/home/oracle/pfile0707.ora’;
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size 2253544 bytes
Variable Size 1392512280 bytes
Database Buffers 150994944 bytes
Redo Buffers 7544832 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile=’/home/oracle/pfile0707.ora’;

File created.

SQL>

13.节点2的恢复
把pfile从节点1 scp到节点二，然后通过pfile启动至nomount，创建spfile，打开数据库。
[oracle@adg1 ~]$ scp pfile0707.ora adg2:/home/oracle/
pfile0707.ora 100% 1312 1.3KB/s 00:00
[oracle@adg2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 4 02:22:13 2020

Connected to an idle instance.

SQL> startup nomount pfile=’/home/oracle/pfile0707.ora’;
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size 2253544 bytes
Variable Size 1392512280 bytes
Database Buffers 150994944 bytes
Redo Buffers 7544832 bytes
SQL> create spfile from pfile=’/home/oracle/pfile0707.ora’;

File created.

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size 2253544 bytes
Variable Size 1392512280 bytes
Database Buffers 150994944 bytes
Redo Buffers 7544832 bytes
Database mounted.
Database opened.
SQL>

14.添加注册信息

[oracle@adg2 ~]$ srvctl add database -d orcladg -o /u01/app/oracle/product/11.2.0.4/db_1/ -p /u01/app/oracle/product/11.2.0.4/db_1/dbs/spfileorcl2.ora
[oracle@adg2 ~]$ srvctl add instance -d orcladg -i orcl1 -n adg1
[oracle@adg2 ~]$ srvctl add instance -d orcladg -i orcl2 -n adg2
[oracle@adg2 ~]$
其中，各项参数代表
-d db_unique_name
-o oracle_home;
-p spfile_path
-i instance_name
-n node_name
如果要删除一个实例或数据库
srvctl remove instance -d racdb -i racdb1
srvctl remove database -d racdb -i racdb1
查看数据库配置
[oracle@adg2 ~]$ srvctl config database -d orcladg
Database unique name: orcladg
Database name:
Oracle home: /u01/app/oracle/product/11.2.0.4/db_1/
Oracle user: oracle
Spfile: /u01/app/oracle/product/11.2.0.4/db_1/dbs/spfileorcl2.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcladg
Database instances: orcl1,orcl2
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is administrator managed

15.启动两个节点的数据库

[grid@adg2 ~]$ crsctl status res -t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

ora.DATA.dg
ONLINE ONLINE adg1
ONLINE ONLINE adg2
ora.FRA.dg
ONLINE ONLINE adg1
ONLINE ONLINE adg2
ora.LISTENER.lsnr
ONLINE ONLINE adg1
ONLINE ONLINE adg2
ora.OCR.dg
ONLINE ONLINE adg1
ONLINE ONLINE adg2
ora.asm
ONLINE ONLINE adg1 Started
ONLINE ONLINE adg2 Started
ora.gsd
OFFLINE OFFLINE adg1
OFFLINE OFFLINE adg2
ora.net1.network
ONLINE ONLINE adg1
ONLINE ONLINE adg2

ora.registry.acfs
ONLINE ONLINE adg1
ONLINE ONLINE adg2

Cluster Resources

ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE adg1
ora.adg1.vip
1 ONLINE ONLINE adg1
ora.adg2.vip
1 ONLINE ONLINE adg2
ora.cvu
1 ONLINE ONLINE adg1
ora.oc4j
1 ONLINE ONLINE adg1
ora.orcladg.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE adg1
[grid@adg2 ~]$ srvctl status database -d orcladg
Instance orcl1 is not running on node adg1
Instance orcl2 is not running on node adg2

虽然添加了database信息，但是database的状态是错误的

集群显示db没有online，实际db是启动的

重新启动

[grid@adg2 ~]$ srvctl start database -d orcladg
[grid@adg2 ~]$ srvctl status database -d orcladg
Instance orcl1 is running on node adg1
Instance orcl2 is running on node adg2
[grid@adg2 ~]$ crsctl status res -t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

ora.registry.acfs
ONLINE ONLINE adg1
ONLINE ONLINE adg2

Cluster Resources

墨力计划

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

1960.ORACLE RAC 异机rman恢复

List of Permanent Datafiles

List of Temporary Files

List of Permanent Datafiles

List of Temporary Files

这里增加时间格式，按照时间点进行还原时会用到

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER

List of Files Unknown to the Database

List of Cataloged Files

[grid@adg2 ~]$ crsctl status res -t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

ora.registry.acfs ONLINE ONLINE adg1 ONLINE ONLINE adg2

Cluster Resources

虽然添加了database信息，但是database的状态是错误的

集群显示db没有online，实际db是启动的

重新启动

[grid@adg2 ~]$ srvctl start database -d orcladg [grid@adg2 ~]$ srvctl status database -d orcladg Instance orcl1 is running on node adg1 Instance orcl2 is running on node adg2 [grid@adg2 ~]$ crsctl status res -t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

ora.registry.acfs ONLINE ONLINE adg1 ONLINE ONLINE adg2

Cluster Resources

评论

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER

ora.registry.acfs
ONLINE ONLINE adg1
ONLINE ONLINE adg2

[grid@adg2 ~]$ srvctl start database -d orcladg
[grid@adg2 ~]$ srvctl status database -d orcladg
Instance orcl1 is running on node adg1
Instance orcl2 is running on node adg2
[grid@adg2 ~]$ crsctl status res -t

ora.registry.acfs
ONLINE ONLINE adg1
ONLINE ONLINE adg2