NBU手工恢复12c版本rac环境到rac环境

NBU恢复12c版本rac环境到rac环境

1 Oracle恢复

1.1准备环境

 

1. 目标服务器安装nbu客户端（如果以前没有按照过）
2. 准备Oracle环境（oracle软件，存储），最好和源服务器保持一致
3. 确认目标服务器与nbu网络通讯正常

 

1.2 Link Oracle

 

[oracle@node01 ~]$ /usr/openv/netbackup//bin/oracle_link

Thu Apr 16 14:03:43 CST 2020

All Oracle instances should be shutdown before running this script.

 

Please log into the Unix system as the Oracle owner for running this script

 

Do you want to continue? (y/n) [n] y

 

 

LIBOBK path: /usr/openv/netbackup/bin

ORACLE_HOME: /u01/app/oracle/product/12.1.0/db_1

Oracle version: 12.1.0.2.0

Platform type: x86_64

Linking LIBOBK:

Moving 64-bit libobk.so to libobk.so.back

ln -s /usr/openv/netbackup/bin/libobk.so64 /u01/app/oracle/product/12.1.0/db_1/lib/libobk.so

Done

 

Please check the trace file located in /tmp/make_trace.2658

to make sure the linking process was successful.

1.3新建参数文件

1.3.1 原数据库创建pfile文件

 

[root@dm01dbadm01 ~]# su - oracle

[oracle@dm01dbadm01 ~]$ export ORACLE_SID=CBSDEV1

[oracle@dm01dbadm01 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 16 14:06:50 2020

 

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

 

SQL> create pfile='/tmp/pfileCBSDEV.ora' from spfile;

 

File created.

 

SQL>

SQL>

SQL> exit

1.3.2 上传到恢复数据库目录

[oracle@dm01dbadm01 ~]$ ls -lrt /tmp/pfile*

-rw-r--r-- 1 oracle asmadmin 1825 Apr 14 16:11 /tmp/pfile.ora

-rw-r--r-- 1 oracle asmadmin 1814 Apr 16 14:07 /tmp/pfileCBSDEV.ora

[oracle@dm01dbadm01 ~]$ scp /tmp/pfileCBSDEV.ora 10.20.8.26:/tmp/

oracle@10.20.8.26's password:

pfileCBSDEV.ora                                                                                                                                                              100% 1814     1.8KB/s   00:00

[oracle@dm01dbadm01 ~]$

 

1.3.3 修改参数文件

 

CBSDEV1.__data_transfer_cache_size=0

CBSDEV2.__data_transfer_cache_size=0

CBSDEV1.__db_cache_size=301989888

CBSDEV2.__db_cache_size=369098752

CBSDEV1.__java_pool_size=33554432

CBSDEV2.__java_pool_size=33554432

CBSDEV2.__large_pool_size=1845493760

CBSDEV1.__large_pool_size=1845493760

CBSDEV1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

CBSDEV2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

CBSDEV1.__pga_aggregate_target=8388608000

CBSDEV2.__pga_aggregate_target=8388608000

CBSDEV1.__sga_target=4194304000

CBSDEV2.__sga_target=4194304000

CBSDEV2.__shared_io_pool_size=100663296

CBSDEV1.__shared_io_pool_size=100663296

CBSDEV1.__shared_pool_size=1879048192

CBSDEV2.__shared_pool_size=1811939328

CBSDEV1.__streams_pool_size=0

CBSDEV2.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/CBSDEV/adump'

*.audit_trail='db'

*.cluster_database=true

*.compatible='12.1.0.2.0'

*.control_files='+DATA/CBSDEV/CONTROLFILE/current.345.997488773','+DATA/CBSDEV/CONTROLFILE/current.333.997488773'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain=''

*.db_name='CBSDEV'

*.db_recovery_file_dest='+DATA'

*.db_recovery_file_dest_size=4785m

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=CBSDEVXDB)'

CBSDEV1.instance_number=1

CBSDEV2.instance_number=2

*.open_cursors=300

*.pga_aggregate_target=8000m

*.processes=1000

*.remote_login_passwordfile='exclusive'

CBSDEV1.sga_max_size=12582912000#internally adjusted

C2.sga_max_size=12582912000#internally adjusted

CBSDEV2.sga_max_size=12582912000#internally adjusted

*.sga_target=24000m

CBSDEV1.sga_target=4194304000#internally adjusted

CBSDEV2.sga_target=4194304000#internally adjusted

CBSDEV1.thread=1

CBSDEV2.thread=2

CBSDEV1.undo_tablespace='UNDOTBS2'

CBSDEV2.undo_tablespace='UNDOTBS1'

 

1.3.4 启动数据库到nomount状态

 

[oracle@node01 /]$ export ORACLE_SID=CBSDEV1

[oracle@node01 /]$ sqlplus / as sysdba

 

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 16 14:20:36 2020

 

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> startup pfile='/tmp/pfileCBSDEV.ora' nomount;

ORACLE instance started.

 

Total System Global Area 1.2583E+10 bytes

Fixed Size                  4511216 bytes

Variable Size            9898560016 bytes

Database Buffers         2650800128 bytes

Redo Buffers               29040640 bytes

SQL>

 

1.4恢复控制文件

1.4.1 查询数据库备份信息

[oracle@node01 ~]$ /usr/openv/netbackup/bin/bplist -C dm01db01 -S d2nbu -t 4 -k D02_exadata_dm01db01_cbsdev_db -R -l /

-rw-rw---- oracle    asmadmin     19660800 Apr 16 03:11 /cntrl_10918_1_1037848285

-rw-rw---- oracle    asmadmin       262144 Apr 16 03:11 /al_10917_1_1037848269

-rw-rw---- oracle    asmadmin      3407872 Apr 16 03:11 /al_10916_1_1037848261

-rw-rw---- oracle    asmadmin      3670016 Apr 16 03:11 /al_10915_1_1037848261

-rw-rw---- oracle    asmadmin     19660800 Apr 16 03:10 /bk_10913_1_1037848238

-rw-rw---- oracle    asmadmin       262144 Apr 16 03:10 /bk_10914_1_1037848238

-rw-rw---- oracle    asmadmin     1146112K Apr 16 03:10 /bk_10912_1_1037848223

-rw-rw---- oracle    asmadmin     1563904K Apr 16 03:10 /bk_10911_1_1037848223

-rw-rw---- oracle    asmadmin     19660800 Apr 15 03:11 /cntrl_10862_1_1037761888

-rw-rw---- oracle    asmadmin       262144 Apr 15 03:11 /al_10861_1_1037761880

-rw-rw---- oracle    asmadmin      3407872 Apr 15 03:11 /al_10860_1_1037761865

-rw-rw---- oracle    asmadmin      3932160 Apr 15 03:11 /al_10859_1_1037761865

-rw-rw---- oracle    asmadmin     19660800 Apr 15 03:10 /bk_10857_1_1037761838

-rw-rw---- oracle    asmadmin       262144 Apr 15 03:10 /bk_10858_1_1037761838

-rw-rw---- oracle    asmadmin     1146112K Apr 15 03:10 /bk_10856_1_1037761823

-rw-rw---- oracle    asmadmin     1560320K Apr 15 03:10 /bk_10855_1_1037761823

-rw-rw---- oracle    asmadmin     19660800 Apr 14 03:11 /cntrl_10806_1_1037675482

-rw-rw---- oracle    asmadmin       262144 Apr 14 03:11 /al_10805_1_1037675466

-rw-rw---- oracle    asmadmin      7077888 Apr 14 03:11 /al_10804_1_1037675466

-rw-rw---- oracle    asmadmin     19660800 Apr 14 03:10 /bk_10802_1_1037675439

-rw-rw---- oracle    asmadmin       262144 Apr 14 03:10 /bk_10803_1_1037675439

-rw-rw---- oracle    asmadmin     1145856K Apr 14 03:10 /bk_10801_1_1037675424

-rw-rw---- oracle    asmadmin     1559040K Apr 14 03:10 /bk_10800_1_1037675424

-rw-rw---- oracle    asmadmin     19660800 Apr 13 03:11 /cntrl_10750_1_1037589074

-rw-rw---- oracle    asmadmin       262144 Apr 13 03:11 /al_10749_1_1037589066

-rw-rw---- oracle    asmadmin      3407872 Apr 13 03:10 /al_10748_1_1037589059

-rw-rw---- oracle    asmadmin      3932160 Apr 13 03:10 /al_10747_1_1037589059

-rw-rw---- oracle    asmadmin     19660800 Apr 13 03:10 /bk_10745_1_1037589040

-rw-rw---- oracle    asmadmin       262144 Apr 13 03:10 /bk_10746_1_1037589040

-rw-rw---- oracle    asmadmin     1558272K Apr 13 03:10 /bk_10743_1_1037589025

-rw-rw---- oracle    asmadmin     1145856K Apr 13 03:10 /bk_10