Oracle 11g R2 rac通过rman 恢复到单实例数据库

怼烎@ 2022-08-06 12:17 403阅读 0赞

生产环境是2个节点的rac + dataguard（物理备库也是两个节点的rac），通过rman每天进行备份，现在需要定期对生产库进行恢复操作

**恢复步骤如下：**

1.      把生产库的备份拷贝到目标端

mkdir /oracle/backup

chown oracle:oinstall /oracle/backup

2.      拷贝备份到目标端

scp -P 22 incremental\_level\*  [oracle@ip:/oracle/backup][oracle_ip_oracle_backup]

scp -P 22 ctrl\_ORCL\_1381360903 \*  [oracle@ip:/oracle/backup][oracle_ip_oracle_backup]

scp -P 22 arch\_ORCL\_ \*  [oracle@ip:/oracle/backup][oracle_ip_oracle_backup]

3.      构造参数文件

在rac环境上生产pfile文件，然后修改pfile文件如下：

把rac相关的参数注释掉，修改相应的参数为单实例数据库上的路径

\*.\_ash\_size=104857600

\*.audit\_file\_dest='/oracle/oracle/admin/orcl/adump'

\*.audit\_trail='NONE'

\#\*.cluster\_database=true

\*.compatible='11.2.0.4.0'

\*.control\_files='/oracle/oracle/oradata/orcl/control1.ctl','/oracle/oracle/oradata/control2.ctl'

\*.db\_block\_size=8192

\#\*.db\_create\_file\_dest='+DATADG'

\*.db\_domain=''

\#\*.db\_file\_name\_convert='+DATADG','+DATADG'

\*.db\_name='orcl'

\*.db\_recovery\_file\_dest='/oracle/oracle/fast\_recovery\_area'

\*.db\_recovery\_file\_dest\_size=107374182400

\*.db\_unique\_name='orcl'

\*.diagnostic\_dest='/oracle/oracle'

\#\*.fal\_client='primaryorcl'

\#\*.fal\_server='standbyorcl'

\#orcl1.instance\_number=1

\#orcl2.instance\_number=2

\#orcl1.large\_pool\_size=0

\#orcl2.large\_pool\_size=0

\#\*.log\_archive\_config='dg\_config=(orcl,orcldg)'

\*.log\_archive\_dest\_1='LOCATION=/oracle/oracle/oradata/archive'

\#\*.log\_archive\_dest\_2='service=STANDBYORCLvalid\_for=(ALL\_LOGFILES,ALL\_ROLES) db\_unique\_name=orcldg'

\#\*.log\_archive\_dest\_state\_2='ENABLE'

\#\*.log\_file\_name\_convert='+SYSTEMDG','+SYSTEMDG'

\*.memory\_max\_target=16548578304

\*.memory\_target=16548578304

\*.open\_cursors=1000

\*.pga\_aggregate\_target=5242880000

\*.processes=4000

\#\*.remote\_listener='172.19.0.107:1521'

\*.remote\_login\_passwordfile='exclusive'

\*.session\_cached\_cursors=800

\*.sessions=3305

\*.sga\_target=10777216000

\#orcl1.shared\_pool\_size=1073741824

\#shared\_pool\_size=1073741824

\#orcl2.shared\_pool\_size=1073741824

\#\*.standby\_file\_management='auto'

\#orcl2.thread=2

\#orcl1.thread=1

\*.undo\_retention=10800

\#orcl2.undo\_tablespace='UNDOTBS2'

\#orcl1.undo\_tablespace='UNDOTBS1'

undo\_tablespace='UNDOTBS1'

文件修改好后放到$ORACLE\_HOME/dbs下并命名为initorcl.ora

4.      创建相关的目录

mkdir –p /oracle/oracle/oradata/archive    --归档目录

mkdir –p /oracle/oracle/admin/orcl/adump  --跟踪审计目录

mkdir –p /oracle/oracle/oradata/orcl       --数据文件存放目录

chown oracle:oinstall /oracle/oracle/oradata/archive

chown oracle:oinstall /oracle/oracle/admin/orcl/adump

chown oracle:oinstall /oracle/oracle/oradata/orcl

5.      设置oracle\_sid环境变量用编辑的好参数启动数据库到nomount状态

\[oracle@database orcl\]$ sqlplus "/assysdba"

SQL\*Plus: Release 11.2.0.4.0Production on Fri Jan 23 12:14:27 2015

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1.6502E+10 bytes

Fixed Size                  2269632 bytes

Variable Size            7516196416 bytes

Database Buffers         8959033344 bytes

Redo Buffers               24379392 bytes

SQL>

6.      从备份集还原控制文件

restore controlfile from 'name';

RMAN>restore controlfile from '/oracle/backup/ctrl\_ORCL\_1381360903\_20150121\_485\_1';

Startingrestore at 23-JAN-15

usingchannel ORA\_DISK\_1

channelORA\_DISK\_1: restoring control file

channelORA\_DISK\_1: restore complete, elapsed time: 00:00:01

outputfile name=/oracle/oracle/oradata/orcl/control1.ctl

outputfile name=/oracle/oracle/oradata/control2.ctl

Finishedrestore at 23-JAN-15

RMAN>mount database;  --打开数据库到mount状态

databasemounted

releasedchannel: ORA\_DISK\_1

RMAN>

7.      将备份信息注册到控制文件中

catalog start with '/oracle/backup/'

RMAN> catalog start with'/oracle/backup/';

Starting implicit crosscheck backup at23-JAN-15

allocated channel: ORA\_DISK\_1

channel ORA\_DISK\_1: SID=1887 devicetype=DISK

Crosschecked 19 objects

Finished implicit crosscheck backup at23-JAN-15

Starting implicit crosscheck copy at23-JAN-15

using channel ORA\_DISK\_1

Finished implicit crosscheck copy at23-JAN-15

searching for all files in the recoveryarea

cataloging files...

no files cataloged

searching for all files that match thepattern /oracle/backup/

List of Files Unknown to the Database

=====================================

File Name:/oracle/backup/ctrl\_ORCL\_1381360903\_20150121\_485\_1

File Name:/oracle/backup/incremental\_level1\_eppt2p9m\_20150119

File Name:/oracle/backup/incremental\_level1\_f3pt81qe\_20150121

File Name:/oracle/backup/ctrl\_ORCL\_1381360903\_20150118\_469\_1

File Name:/oracle/backup/incremental\_level1\_eopt2p54\_20150119

File Name:/oracle/backup/ctrl\_ORCL\_1381360903\_20150119\_475\_1

File Name:/oracle/backup/ctrl\_ORCL\_1381360903\_20150120\_480\_1

File Name:/oracle/backup/incremental\_level2\_etpt5dce\_20150120

File Name:/oracle/backup/incremental\_level2\_eupt5dha\_20150120

File Name:/oracle/backup/incremental\_level1\_f2pt81ka\_20150121

File Name:/oracle/backup/incremental\_level0\_ORCL\_20150118\_466\_1

File Name:/oracle/backup/incremental\_level0\_ORCL\_20150118\_467\_1

Do you really want to catalog the abovefiles (enter YES or NO)? YES

cataloging files...

cataloging done

List of Cataloged Files

=======================