rman异机恢复（单机到rac）

已于 2022-06-15 15:29:14 修改
阅读量557 收藏 2
点赞数
分类专栏： oracle 文章标签： 数据库 oracle sql
于 2022-06-15 15:24:52 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_44941776/article/details/125297956
版权 
#关闭实例，切换为nomount状态：
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 2471931904 bytes
Fixed Size		    2255752 bytes
Variable Size		  671089784 bytes
Database Buffers	 1795162112 bytes
Redo Buffers		    3424256 bytes

#进入rman：
[oracle@node1 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri May 6 16:10:59 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ZLHISCS (not mounted)


#恢复控制文件：
RMAN> restore controlfile from '/backup/rmanbak/cntrl_33_1_33';

Starting restore at 06-MAY-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=33 instance=ZLHISCS1 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/zlhiscs/controlfile/current.272.1103216865
output file name=+ARCH/zlhiscs/controlfile/current.256.1103216865
Finished restore at 06-MAY-22


#启动到mount状态：
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1

#删除原备份
RMAN> delete noprompt expired backup;

Starting implicit crosscheck backup at 07-MAY-22
allocated channel: ORA_DISK_1
Crosschecked 33 objects
Finished implicit crosscheck backup at 07-MAY-22

#分类编目
RMAN> catalog start with '/backup/rmanbak/';

searching for all files that match the pattern /backup/rmanbak

List of Files Unknown to the Database
=====================================
File Name: /backup/rmanbak/db_ZLHISCS_20210408_0ovrq9e5_1_1
File Name: /backup/rmanbak/db_ZLHISCS_20210408_0rvrq9e5_1_1
File Name: /backup/rmanbak/db_ZLHISCS_20210408_0pvrq9e5_1_1
File Name: /backup/rmanbak/arc_1069360622_32
File Name: /backup/rmanbak/db_ZLHISCS_20210408_0qvrq9e5_1_1
File Name: /backup/rmanbak/cntrl_33_1_33
File Name: /backup/rmanbak/arc_1069360622_31

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/rmanbak/db_ZLHISCS_20210408_0ovrq9e5_1_1
File Name: /backup/rmanbak/db_ZLHISCS_20210408_0rvrq9e5_1_1
File Name: /backup/rmanbak/db_ZLHISCS_20210408_0pvrq9e5_1_1
File Name: /backup/rmanbak/arc_1069360622_32
File Name: /backup/rmanbak/db_ZLHISCS_20210408_0qvrq9e5_1_1
File Name: /backup/rmanbak/cntrl_33_1_33
File Name: /backup/rmanbak/arc_1069360622_31


#恢复数据文件：
RMAN> run 
{
allocate channel c1 type disk; 
allocate channel c2 type disk; 
allocate channel c3 type disk; 
allocate channel c4 type disk; 
set newname for database to '+DATA';         
restore database;
switch datafile all; 
switch tempfile all; 
release channel c1; 
release channel c2; 
release channel c3; 
release channel c4; 
}

datafile 23 switched to datafile copy
input datafile copy RECID=96 STAMP=1103996423 file name=+DATA/zlhiscs/datafile/zlbak2019.297.1103996287
datafile 24 switched to datafile copy
input datafile copy RECID=97 STAMP=1103996423 file name=+DATA/zlhiscs/datafile/zlmsgdata.287.1103996289

renamed tempfile 1 to +DATA in control file
renamed tempfile 2 to +DATA in control file

released channel: c1

released channel: c2

released channel: c3

released channel: c4

#redo重命名
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ZLHISCS/redo04.log
/u01/app/oracle/oradata/ZLHISCS/redo05.log
/u01/app/oracle/oradata/ZLHISCS/redo06.log

SQL> alter database rename file '/u01/app/oracle/oradata/ZLHISCS/redo04.log' to '+DATA/ZLHISCS/ONLINELOG/group_4';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ZLHISCS/redo05.log' to '+DATA/ZLHISCS/ONLINELOG/group_5';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ZLHISCS/redo06.log' to '+DATA/ZLHISCS/ONLINELOG/group_6';

Database altered.
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/zlhiscs/onlinelog/group_4
+DATA/zlhiscs/onlinelog/group_5
+DATA/zlhiscs/onlinelog/group_6

#恢复数据库：
RMAN> recover database;
unable to find archived log
archived log thread=1 sequence=12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/06/2022 17:42:50
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 12 and starting SCN of 2998774

#不完全恢复：
RMAN> recover database until scn 2998774;

Starting recover at 06-MAY-22
using channel ORA_DISK_1

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

Finished recover at 06-MAY-22


#启动数据库到open状态
SQL> alter database open resetlogs;

Database altered.
--------------------
Mon May 09 11:12:12 2022
Completed: alter database open resetlogs
[root@node1 trace]# pwd
/u01/app/oracle/diag/rdbms/zlhiscs/ZLHISCS1/trace


#添加临时表空间
SQL> alter tablespace ZLTOOLSTMP add tempfile '+DATA' SIZE 50m;
Tablespace altered.

SQL> select status,enabled, name, bytes/1024/1024 file_size from v_$tempfile;
STATUS	ENABLED
------- ----------
NAME
--------------------------------------------------------------------------------
 FILE_SIZE
----------
ONLINE	READ WRITE
+DATA/zlhiscs/tempfile/zltoolstmp.297.1104234219
	50
ONLINE	READ WRITE
+DATA/zlhiscs/tempfile/temp.295.1104232319
	20
STATUS	ENABLED
------- ----------
NAME
--------------------------------------------------------------------------------
 FILE_SIZE
----------
ONLINE	READ WRITE
+DATA/zlhiscs/tempfile/zltoolstmp.296.1104232319
	50


#添加thred2的redo
 SQL> alter database add logfile thread 2 group 7 '+DATA' size 50M;
Database altered.

SQL> alter database add logfile thread 2 group 8 '+DATA' size 50M;
Database altered.

SQL> alter database add logfile thread 2 group 9 '+DATA' size 50m;
Database altered.


#修改rac参数
SQL> alter system set thread=1 scope=spfile sid='ZLHISCS1';
System altered.

SQL> alter system set thread=2 scope=spfile sid='ZLHISCS2';
System altered.

SQL> alter system set instance_number=1 scope=spfile sid='ZLHISCS1';
System altered.

SQL> alter system set instance_number=2 scope=spfile sid='ZLHISCS2';
System altered.

SQL> alter system set cluster_database_instances=2 scope=spfile;
System altered.

SQL> alter system set cluster_database=true scope=spfile;
System altered.


#创建undo表空间
SQL> create undo tablespace undotbs2 datafile '+DATA/ZLHISCS/datafile/undotbs2.dbf' size 50m;
Tablespace created.

SQL> alter system set undo_tablespace='undotbs2' scope=spfile sid='ZLHISCS2';
System altered.

#启动thread 2
SQL> select THREAD#,STATUS,ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
	 1 OPEN   PUBLIC
	 2 CLOSED DISABLED
SQL> alter database enable thread 2;
Database altered.
SQL> select THREAD#,STATUS,ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
	 1 OPEN   PUBLIC
	 2 CLOSED PRIVATE

#查看实例状态
[oracle@node1 ~]$ srvctl status database -d ZLHISCS
实例 ZLHISCS1 正在节点 node1 上运行
实例 ZLHISCS2 正在节点 node2 上运行

#重启数据库
[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 9 14:11:38 2022

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

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> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup open;
ORACLE instance started.

Total System Global Area 5311328256 bytes
Fixed Size		    2262568 bytes
Variable Size		 1073744344 bytes
Database Buffers	 4227858432 bytes
Redo Buffers		    7462912 bytes
Database mounted.
Database opened.
SQL> 

[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 9 11:52:13 2022

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

Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 5311328256 bytes
Fixed Size		    2262568 bytes
Variable Size		 1073744344 bytes
Database Buffers	 4227858432 bytes
Redo Buffers		    7462912 bytes
Database mounted.
Database opened.
上冬二十二
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Oracle单机通过rman迁移到RAC集群.docx
10-26
Oracle单机通过rman迁移到RAC集群
RMAN异机恢复数据库详解
不专业的专业人士
06-08 1536
通过RMAN完成数据库异机恢复，保姆级教程
【Oracle篇】rman全库异机恢复：从单机环境到RAC测试环境的转移（第五篇，总共八篇）
最新发布
奈斯DBA的博客
06-04 1368
使用RMAN从单机环境的备份片中恢复数据到RAC环境。包括恢复控制文件、数据文件、参数文件、归档等关键组件
RMAN迁移（单机到RAC）
喝醉酒的小白
11-14 3300
1 源端全备 主库备份 查看备份 2 源端创建pfile参数文件&修改参数文件 create pfile='/data/backup/recover.ora' from spfile; vi recover.ora bpxtest2.__db_cache_size=3355443200 bpxtest2.__java_pool_size=16777216 bpxtest2.__large_pool_size=50331648 bpxtest2.__oracle_base='/opt/ora
rman备份异机恢复
weixin_52188141的博客
07-16 4003
前提条件：两台机器数据库版本相同，备份路径相同，文件路径相同。目标库可以将数据文件，控制文件，闪回区，参数文件等清空，以方便后期恢复。（不删除也行，我习惯的是删除） ps:注意目录权限 第一步：rman整库备份 run { allocate channel ch1 type disk; allocate channel ch2 type disk; sql 'alter system archive log current'; backup as compressed backupset da..
使用rman把单机的备份集恢复到RAC的方法
姚远OracleACE的博客
12-26 961
文章目录环境准备在ASM磁盘组里面创建相应的目录创建对应文件系统的目录恢复spfile名字转换配置文件/etc/oratab :恢复第一节点启动到nomount状态恢复controlfile启动到mount状态并恢复recover数据库打开数据库配置第一个数据库实例修改sys的密码创建口令文件如果必要，增加redo配置监听在crs中增加数据库配置第二个节点拷贝文件：配置undo创建redo 环境准备 在ASM磁盘组里面创建相应的目录 [oracle@db01 ~]$ . oraenv ORACLE_SID
rac rman异机恢复
10-31
最详细的单机坏境恢复rac备份集，只要按步骤一步一步操作，绝对成功
oracle10g rac环境Rman备份恢复至单机方案
09-18
Oracle 10g RAC 环境下的RMAN（Recovery Manager）备份恢复至单机环境是一项复杂但重要的任务，特别是在灾难恢复或系统迁移的场景中。以下将详细阐述这个过程的关键步骤和注意事项。 首先，RMAN是Oracle数据库管理...
Oracle单机通过rman迁移到RAC集群.zip
11-01
2. 使用RMAN恢复数据库到RAC环境，首先恢复控制文件： ``` run { restore controlfile from autobackup; } ``` 3. 恢复数据文件和归档日志： ``` run { recover database noprompt; restore database; switch ...
异机迁移oracle 11.2.0.4单机至12cR2 RAC
12-14
异机迁移Oracle数据库是一个复杂的过程，特别是从Oracle 11.2.0.4单机环境迁移到12c Release 2 (12.2.0.1)的Real Application Clusters (RAC)环境。这个过程涉及到多个步骤，包括备份、恢复、参数配置以及系统升级。...
Oracle使用rman从单实例迁移导RAC
qq_58568577的博客
09-20 706
Oracle使用rman从单实例迁移导RAC
单实例备份集恢复到RAC
congmao4272的博客
09-10 131
//********************************************************************1、恢复为单实例普通文件系统1)rman 备份原数据库（在mount状态下做）RMAN&...
rman异机恢复
whn1977的博客
07-12 438
rman 异机恢复
Oracle 11g使用rman从单实例迁移到RAC
驰兔的博客
06-15 3142
一、准备环境 1、单实例配置 数据库版本：Oracle 11.2.0.4 操作系统：CentOS 6.5 2、RAC配置（数据库实例未装载） 服务器主机名 rac1 rac2 公共IP地址(eth0) 192.168.91.140 192.168.91.142 虚拟IP地址(eth0) 192.168.91.152 192.168.91.153 私有IP地址(eth1) 192.168.1.130 192.168.1.131 名称 说明 SCAN IP 192.1
数据库rman备份异机恢复
11-29 759
在源库执行sql，得到run{……}，rman时使用，确认异机环境存在目录：/data/app/oracle/oradata/orcl/ 可以修改。需要修改参数 enable_pluggable_database 为TRUE，同时新建spfile切换为spfile启动。修改/tmp/pfile1.ora：*.db_block_size=32768。c-xxxxxxxx-xxxx 为控制文件名。PDB切换(PDB模式下需要)再次执行重新执行rman。
Oracle数据库集群管理-19c集群RMAN异机恢复总结
oradbm的博客
07-15 863
总结：rman在对ASM存储的文件进行恢复的时，不是按照原来文件的名字进行重新创建的，而是修改了按照对应的磁盘组，修改了数据文件name。我们发现在还原数据库时，最后报错磁盘组ORADATA1空间不足，就很差异，因为原来欢迎。合计大小也就才3T，而新环境的ORADATA1配置的5T为啥还会不足？于是在pfile中将参数修改为空，重启数据库，重新进行restore，正常了。发现大部分的文件原来是ORADATA2也创建在了ORADATA1就很差异。1 拷贝参数文件并将集群的一些参数进行修改。
Oracle 单实例 迁移到 RAC 实例 -- 使用RMAN 异机恢复
小宝老豆的专栏
09-29 1120
Oracle 官网有关单实例迁移到RAC的一个步骤说明：        How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure [ID 747457.1]        http://blog.csdn.net/xujinyang/article/details/68333
Rman单实例数据库整库恢复到RAC集群里，并添加至集群
az65381973的博客
02-14 930
环境介绍： RAC集群环境Oracle11g IP：192.168.20.11 IP：192.168.20.12 Rac1、rac2的grid软件，数据库软件都已建好，不建库   2.单实例，从开始建库到结束，一直开着归档,归档模式 目标 目的是单实例做全备，恢复到RAC单节点1环境启库，单节点1恢复完启库，单节点2再启库，把两节点加入集群 全库备份见上一篇文章“Rman单机备份到...
oracle rman 异机恢复单个PDB详细步骤
03-28
以下是Oracle RMAN 异机恢复单个PDB的详细步骤： 1. 确认备份文件及目标数据库的情况。 首先，需要确认备份文件的位置、备份类型、备份时间等信息。同时，也需要确认目标数据库的情况，比如数据库版本、PDB名称等...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值