Oracle Linux环境单实例异机手动恢复

最新推荐文章于 2021-04-04 03:09:21 发布
最新推荐文章于 2021-04-04 03:09:21 发布
阅读量545 收藏 2
点赞数 2
分类专栏： 迁移 Oracle数据库多环境迁移 文章标签： linux 单实例异机
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kiral07/article/details/87254082
版权

Oracle Linux环境单实例异机手动恢复

一、场景：数据库名、目录结构完全相同

源主机：CentOS 7.4 单实例orcl
目标主机：RHEL 6.9 新实例orcl
数据库目录结构：目标主机数据库名、数据文件目录与源主机相同。
适用场景：
1.1 还原步骤

1、源主机进行完全备份以及归档日志

RMAN> backup database format '/u01/arch/full_06_20.bak' plus archivelog;

2、源主机生成pfile

SQL>create pfile from spfile;

3、在目标主机建立文件夹用于存放RMAN备份集

[oracle@gs dbs]$mkdir /u01/rman

4、在源主机拷贝RMAN备份集（数据文件、归档日志、控制文件）以及pfile文件到目标主机

[oracle@gs dbs]$scp /u01/arch/ORCL/backupset/2018_06_20/o1_mf_annnn_TAG20180620T164606_fln52gwc_.bkp oracle@192.168.149.129:/u01/rman（归档日志）

[oracle@gs dbs]$scp /u01/arch/full_6_20.bak oracle@192.168.149.129:/u01/rman （数据文件）

[oracle@gs dbs]$scp /u01/arch/ORCL/backupset/2018_06_20/o1_mf_annnn_TAG20180620T164615_fln52q4g_.bkp oracle@192.168.149.129:/u01/rman （归档日志）

[oracle@gs dbs]$scp /u01/app/oracle/product/11.2.0/db_1/dbs/control_c-1494212616-20180620-04.ctl oracle@192.168.149.129:/u01/rman （控制文件)

拷贝pfile到目标主机dbs目录

[oracle@ dbs]$scp initorcl.ora oracle@192.168.149.129:/u01/app/oracle/product/11.2.0/db_1/dbs/

5、在目标主机dbs目录，编辑pfile文件
修改参数保留如下：

[oracle@gs dbs]$ vi initorcl.ora 
control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl'
db_block_size=8192
db_name='orcl'
log_archive_dest_1='location=/u01/arch'
processes=1000
remote_login_passwordfile='EXCLUSIVE'
compatible='11.2.0.4.0'
sga_target=700m
pga_aggregate_target=300m
open_cursors=300

6、在目标主机创建数据文件以及归档目录

[oracle@gs dbs]$mkdir -p /u01/app/oracle/oradata/orcl/
[oracle@gs dbs]$mkdir -p /u01/arch
[oracle@gs dbs]$mkdir -p /u01/app/oracle/admin/orcl/adump
备注：此目录结构与源主机相同

7、在目标主机用RMAN将数据库启动到nomount

RMAN>rman target /
RMAN>startup nomount;

8、在目标主机还原控制文件

RMAN>restore controlfile from '/u01/rman/control_c-1494212616-20180620-04.ctl';
备注：控制文件需要通过RMAN恢复之后，才能启动mount

9、目标主机启动到mount状态

RMAN>alter database mount;

10、检验还原的控制文件在RMAN中是否可以查看备份集

RMAN>crosscheck backup；

11、将目标主机RMAN备份目录更新（前步骤用来放RMAN备份集目录）

RMAN> catalog start with '/u01/rman';
备注：将新备份目录的元数据添加到RMAN

searching for all files that match the pattern /u01/rman

List of Files Unknown to the Database
=====================================
File Name: /u01/rman2/full_20180621_02t605s9_1_1.bak
File Name: /u01/rman2/control_c-1499390015-20180621-00.ctl
File Name: /u01/rman2/03t605so_1_1
File Name: /u01/rman2/01t605s5_1_1
File Name: /u01/rman2/arch_full.bak

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

List of Cataloged Files
=======================
File Name: /u01/rman/full_20180621_02t605s9_1_1.bak
File Name: /u01/rman/control_c-1499390015-20180621-00.ctl
File Name: /u01/rman/03t605so_1_1
File Name: /u01/rman/01t605s5_1_1
File Name: /u01/rman/arch_full.bak

12、目标主机内用命令检查备份集

RMAN> list backup;

13、还原数据文件

RMAN> restore database;
备注：源主机目标主机，文件目录结构相同，可直接还原

14、查看数据文件是否正常生成

RMAN> report schema；

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    750      SYSTEM               ***     /u01/app/oracle/oradata/orcl2/system01.dbf
2    1140     SYSAUX               ***     /u01/app/oracle/oradata/orcl2/sysaux01.dbf
3    880      UNDOTBS1             ***     /u01/app/oracle/oradata/orcl2/undotbs01.dbf
4    5        USERS                ***     /u01/app/oracle/oradata/orcl2/users01.dbf
5    10       CS1                  ***     /u01/app/oracle/oradata/orcl2/cs1.dbf
6    10       CS2                  ***     /u01/app/oracle/oradata/orcl2/cs2.dbf
7    100      CS                   ***     /u01/app/oracle/oradata/orcl2/cs.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/orcl/temp01.dbf

检查下对应文件目录是否真的生成数据文件以及临时文件

15、目标主机应用归档日志

RMAN> recover database;

Starting recover at 2018/06/21 14:32:40
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5 device type=DISK

starting media recovery

archived log file name=/u01/arch/1_193_971609279.dbf thread=1 sequence=193
archived log file name=/u01/arch/1_194_971609279.dbf thread=1 sequence=194
unable to find archived log
archived log thread=1 sequence=195
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/21/2018 14:32:41
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 195 and starting SCN of 6049382

备注：RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 12 and starting SCN of 1119977
此行并没有问题，RMAN会不断寻找合适的日志进行恢复。

16、打开目标主机数据库

RMAN> alter database open resetlogs;

17、目标数据库创建spfile

SQL> create spfile from pfile;

18、重启数据库

SQL> shutdown immediate;
SQL> startup;

19、目标主机建立监听
直接编辑listener.ora文件(可选，如不建立，启动监听会使用默认监听)

[oracle@gs ~]$ vi /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = orcl)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = gs)(PORT = 1521))
    )
  )

20、启动监听

[oracle@gs ~]$ lsnrctl start

21、在oratab中增加实例名

[oracle@gs ~]$ vi ／etc/oratab
orcl:/u01/app/oracle/product/11.2.0/db_1:N

二、场景：数据库名、目录结构均不同

源主机：CentOS 7.4 单实例sid:orcl
目标主机：RHEL 6.9 已存在1个单实例sid:orcl，拟创建另一个新实例orcl2
数据库目录结构：在目标主机创建的数据文件，归档目录与源主机不同
适用场景：源主机已经存在实例、目标主机，文件结构，数据库名均不同

2.1 还原步骤

1、源主机进行完全备份以及归档日志

RMAN> backup database format '/u01/arch/full_06_21.bak' plus archivelog;

2、源主机生成pfile

SQL>create pfile from spfile;

3、在目标主机建立文件夹用于存放RMAN备份集

[oracle@gs dbs]$mkdir /u01/rman2

4、在源主机拷贝RMAN备份集（数据文件、归档日志、控制文件）以及pfile文件到目标主机

[oracle@gs dbs]$scp /u01/arch/ORCL/backupset/2018_06_21/o1_mf_annnn_TAG20180620T164606_fln52gwc_.bkp oracle@192.168.149.129:/u01/rman（归档日志）
[oracle@gs dbs]$scp /u01/arch/full_6_21.bak oracle@192.168.149.129:/u01/rman （数据文件）
[oracle@gs dbs]$scp /u01/arch/ORCL/backupset/2018_06_21/o1_mf_annnn_TAG20180620T164615_fln52q4g_.bkp oracle@192.168.149.129:/u01/rman （归档日志）
[oracle@gs dbs]$scp /u01/app/oracle/product/11.2.0/db_1/dbs/control_c-1494212616-20180620-04.ctl oracle@192.168.149.129:/u01/rman （控制文件)

拷贝源主机pfile到目标主机dbs目录
scp initorcl.ora oracle@192.168.149.129:/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl2.ora

5、在目标主机dbs目录，编辑pfile文件

修改参数保留如下：
[oracle@gs dbs]$ vi initorcl2.ora 
control_files='/u01/app/oracle/oradata/orcl2/control01.ctl','/u01/app/oracle/oradata/orcl2/control02.ctl'
db_block_size=8192
db_name='orcl'  （此时先不改数据库名，需要还原数据文件之后重建控制文件再改）
log_archive_dest_1='location=/u01/arch2'
processes=1000
remote_login_passwordfile='EXCLUSIVE'
compatible='11.2.0.4.0'
sga_target=700m
pga_aggregate_target=300m
open_cursors=300

6、对目标主机现有实例orcl停库

shutdown immediate;

---备注：本实验环境已存在与源数据库相同实例，需要停库。新环境无需理会

7、修改目标主机环境变量ORACLE_SID

export ORACLE_SID=orcl2

8、在目标主机创建数据文件以及归档目录

[oracle@gs dbs]$mkdir -p /u01/app/oracle/oradata/orcl2/
[oracle@gs dbs]$mkdir -p /u01/arch2
[oracle@gs dbs]$mkdir -p /u01/app/oracle/admin/orcl2/adump

9、在目标主机用RMAN将数据库启动到nomount

RMAN>rman target /
RMAN>startup nomount;
RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area     730714112 bytes

Fixed Size                     2256832 bytes
Variable Size                239075392 bytes
Database Buffers             482344960 bytes
Redo Buffers                   7036928 bytes

10、在目标主机还原控制文件

RMAN>restore controlfile from '/u01/rman2/control_c-1499390015-20180621-00.ctl';

--RMAN> restore controlfile from '/u01/rman/ORCL_04thndhk_1_1.bak';用rman备份还原--


Starting restore at 2018/06/23 20:32:53
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1149 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/orcl2/control01.ctl
output file name=/u01/app/oracle/oradata/orcl2/control02.ctl
Finished restore at 2018/06/23 20:32:54

11、目标主机启动到mount状态

RMAN>alter database mount;


database mounted
released channel: ORA_DISK_1

12、检验还原的控制文件在RMAN中是否可以查看备份集

RMAN>crosscheck backup；

13、将目标主机RMAN备份目录更新（前步骤用来放RMAN备份集目录）

RMAN> catalog start with '/u01/rman2';

searching for all files that match the pattern /u01/rman2

List of Files Unknown to the Database
=====================================
File Name: /u01/rman2/full_arch_20180623_5jt66knn_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5rt66ko0_1_1.bak
File Name: /u01/rman2/full_20180621_02t605s9_1_1.bak
File Name: /u01/rman2/control_c-1499390015-20180621-00.ctl
File Name: /u01/rman2/full_arch_20180623_5ot66kns_1_1.bak
File Name: /u01/rman2/full_db_20180623_5tt66ko2_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5ut66ko9_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5mt66knq_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5nt66knr_1_1.bak
File Name: /u01/rman2/control_c-1494212616-20180623-00.ctl
File Name: /u01/rman2/full_arch_20180623_5pt66knu_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5qt66knv_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5lt66knp_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5it66knm_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5kt66kno_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5st66ko1_1_1.bak

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

List of Cataloged Files
=======================
File Name: /u01/rman2/full_arch_20180623_5jt66knn_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5rt66ko0_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5ot66kns_1_1.bak
File Name: /u01/rman2/full_db_20180623_5tt66ko2_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5ut66ko9_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5mt66knq_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5nt66knr_1_1.bak
File Name: /u01/rman2/control_c-1494212616-20180623-00.ctl
File Name: /u01/rman2/full_arch_20180623_5pt66knu_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5qt66knv_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5lt66knp_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5it66knm_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5kt66kno_1_1.bak
File Name: /u01/rman2/full_arch_20180623_5st66ko1_1_1.bak

List of Files Which Where Not Cataloged
=======================================
File Name: /u01/rman2/full_20180621_02t605s9_1_1.bak
  RMAN-07518: Reason: Foreign database file DBID: 1499390015  Database Name: ORCL
File Name: /u01/rman2/control_c-1499390015-20180621-00.ctl
  RMAN-07518: Reason: Foreign database file DBID: 1499390015  Database Name: ORCL

14、在目标主机内用命令检查备份集

RMAN> list backup;

15、还原数据文件
因目标主机与源主机数据结构不同，需要使用如下查询语句，拼凑出RMAN还原新路径的语句，如下：
拼凑语句

set head off feed off verify off echo off pages 0 trimspool on
set line 132 pagesize 0
spo newname.sql
--
select 'run{' from dual;
--
select
'set newname for datafile ' || file# || ' to ' || '''' || name || '''' || ';'
from v$datafile;
--
select
'restore database;' || chr(10)||
'switch datafile all;' || chr(10) ||
'}'
from dual;
--
spo off;



用上面生成的脚本在RMAN执行，如下：

RMAN> run
{
set newname for datafile 1 to '/u01/app/oracle/oradata/orcl2/system01.dbf';
set newname for datafile 2 to '/u01/app/oracle/oradata/orcl2/sysaux01.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/orcl2/undotbs01.dbf';
set newname for datafile 4 to '/u01/app/oracle/oradata/orcl2/users01.dbf';
set newname for datafile 5 to '/u01/app/oracle/oradata/orcl2/cs1.dbf';
set newname for datafile 6 to '/u01/app/oracle/oradata/orcl2/cs2.dbf';
set newname for datafile 7 to '/u01/app/oracle/oradata/orcl2/cs.dbf';
restore database;
switch datafile all;
}


executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 2018/06/23 20:37:33
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5 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 /u01/app/oracle/oradata/orcl2/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/orcl2/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl2/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl2/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/orcl2/secure.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/orcl2/cs.dbf
channel ORA_DISK_1: reading from backup piece /u01/rman/full_db_20180623_5tt66ko2_1_1.bak
channel ORA_DISK_1: piece handle=/u01/rman/full_db_20180623_5tt66ko2_1_1.bak tag=TAG20180623T194402
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 2018/06/23 20:37:40

datafile 1 switched to datafile copy
input datafile copy RECID=19 STAMP=979591061 file name=/u01/app/oracle/oradata/orcl2/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=20 STAMP=979591061 file name=/u01/app/oracle/oradata/orcl2/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=21 STAMP=979591061 file name=/u01/app/oracle/oradata/orcl2/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=22 STAMP=979591061 file name=/u01/app/oracle/oradata/orcl2/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=23 STAMP=979591061 file name=/u01/app/oracle/oradata/orcl2/secure.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=24 STAMP=979591061 file name=/u01/app/oracle/oradata/orcl2/cs.dbf

16、查看数据文件是否正常生成

RMAN> report schema;
检查下对应文件目录是否真的生成数据文件以及临时文件
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    740      SYSTEM               ***     /u01/app/oracle/oradata/orcl2/system01.dbf
2    600      SYSAUX               ***     /u01/app/oracle/oradata/orcl2/sysaux01.dbf
3    780      UNDOTBS1             ***     /u01/app/oracle/oradata/orcl2/undotbs01.dbf
4    5        USERS                ***     /u01/app/oracle/oradata/orcl2/users01.dbf
5    20       SECURESPACE          ***     /u01/app/oracle/oradata/orcl2/secure.dbf
6    100      CS                   ***     /u01/app/oracle/oradata/orcl2/cs.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/orcl/temp01.dbf

17、修改pfile更改新的数据库名（此后续步骤是为了更改新实例名称orcl2以及文件目录）

[oracle@gs ~]$vi /u01/app/oracle/product/11.2.0/db_1/dbs/initorcl2.ora
修改数据库名为新名称
db_name='orcl2'

18、生成新实例的控制文件

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area     730714112 bytes

Fixed Size                     2256832 bytes
Variable Size                239075392 bytes
Database Buffers             482344960 bytes
Redo Buffers                   7036928 bytes

RMAN> exit


Recovery Manager complete.
[oracle@gs ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jun 23 20:40:10 2018

Copyright © 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL2 (not mounted)



（重建控制文件，如下一定要使用SET DATABASE参数）

SQL> CREATE CONTROLFILE REUSE SET DATABASE "ORCL2" RESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
    LOGFILE
    GROUP 1 '/u01/app/oracle/oradata/orcl2/redo01.log' SIZE 50M BLOCKSIZE 512,
    GROUP 2 '/u01/app/oracle/oradata/orcl2/redo02.log' SIZE 50M BLOCKSIZE 512,
   GROUP 3 '/u01/app/oracle/oradata/orcl2/redo03.log' SIZE 50M BLOCKSIZE 512,
   GROUP 4 '/u01/app/oracle/oradata/orcl2/redo04.log' SIZE 50M BLOCKSIZE 512,
   GROUP 5 '/u01/app/oracle/oradata/orcl2/redo05.log' SIZE 50M BLOCKSIZE 512
   DATAFILE
   '/u01/app/oracle/oradata/orcl2/system01.dbf',
   '/u01/app/oracle/oradata/orcl2/sysaux01.dbf',
   '/u01/app/oracle/oradata/orcl2/undotbs01.dbf',
   '/u01/app/oracle/oradata/orcl2/users01.dbf',
   '/u01/app/oracle/oradata/orcl2/secure.dbf',
   '/u01/app/oracle/oradata/orcl2/cs.dbf'
   CHARACTER SET ZHS16GBK
   ;

Control file created.

19、启动到mount便于RMAN还原数据文件

SQL>alter database mount;

20、在新实例生成新的redo日志组

sql>alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter database clear logfile group 5;
Database altered.
如果生成不了可用alter database clear unarchived logfile group #;

21、新实例恢复数据库

RMAN> recover database;
Starting recover at 2018/06/23 20:54:54
using channel ORA_DISK_1

starting media recovery

unable to find archived log
archived log thread=1 sequence=4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/23/2018 20:54:55
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 4 and starting SCN of 1225132

备注：RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 12 and starting SCN of 1119977
此行并没有问题，RMAN会不断寻找合适的日志进行恢复。

22、open新实例数据库

RMAN> alter database open resetlogs;
Database altered.

23、新实例创建临时文件

SQL> select * from v$tempfile;
SQL> alter tablespace temp add tempfile '/u01/app/oracle/oradata/orcl2/temp01.dbf' size 200m autoextend on next 10m maxsize 10g;

Tablespace altered.

24、为新实例数据库创建spfile

SQL> create spfile from pfile;
File created.

25、重启数据库

SQL> shutdown immediate;
SQL> startup;

26、更改新实例数据库DBID

将数据库启动到mount状态

[oracle@gs rman2]$ nid target=sys/oracle

DBNEWID: Release 11.2.0.4.0 - Production on Sat Jun 23 21:17:35 2018

Copyright © 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to database ORCL2 (DBID=1494212616)

Connected to server version 11.2.0

Control Files in database:
    /u01/app/oracle/oradata/orcl2/control01.ctl
    /u01/app/oracle/oradata/orcl2/control02.ctl

Change database ID of database ORCL2? (Y/[N]) => y

Proceeding with operation
Changing database ID from 1494212616 to 960427375
    Control File /u01/app/oracle/oradata/orcl2/control01.ctl - modified
    Control File /u01/app/oracle/oradata/orcl2/control02.ctl - modified
    Datafile /u01/app/oracle/oradata/orcl2/system01.db - dbid changed
    Datafile /u01/app/oracle/oradata/orcl2/sysaux01.db - dbid changed
    Datafile /u01/app/oracle/oradata/orcl2/undotbs01.db - dbid changed
    Datafile /u01/app/oracle/oradata/orcl2/users01.db - dbid changed
    Datafile /u01/app/oracle/oradata/orcl2/secure.db - dbid changed
    Datafile /u01/app/oracle/oradata/orcl2/cs.db - dbid changed
    Datafile /u01/app/oracle/oradata/orcl2/temp01.db - dbid changed
    Control File /u01/app/oracle/oradata/orcl2/control01.ctl - dbid changed
    Control File /u01/app/oracle/oradata/orcl2/control02.ctl - dbid changed
    Instance shut down

Database ID for database ORCL2 changed to 960427375.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.


打开数据库
SQL> startup;
ORACLE instance started.

Total System Global Area  730714112 bytes
Fixed Size                  2256832 bytes
Variable Size             239075392 bytes
Database Buffers          482344960 bytes
Redo Buffers                7036928 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;

Database altered.

SQL> select dbid from v$database;

      DBID
----------
 960427375
 
 DBID已修改完毕

27、目标主机建立监听(可选，如不建立，启动监听会使用默认监听)

直接编辑listener.ora文件
[oracle@gs ~]$ vi /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = orcl)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = gs)(PORT = 1521))
    )
  )

28、启动监听

[oracle@gs ~]$ lsnrctl start

29、在oratab底部增加新的实例名

[oracle@gs ~]$ vi ／etc/oratab
orcl2:/u01/app/oracle/product/11.2.0/db_1:N
iverycd
关注
专栏目录
Oracle 11G RMAN 单实例异机恢复
pimg2005的专栏
04-28 86
数据备份当然是为数据恢复准备，新环境的oracle一直在进行备份，但都没有测试验证备份的有效性，所以本次测试的重要性不言而喻了！以下为WIN平台下RMAN异机恢复实例。源库目标库操作系统WIN SVR 2008 R2WIN SVR 2008 R2主机名OraORATESTIP192.168.18.20192.168.18.25数据库版本11.2.0.1.011.2.0.1.0存储方式单实例单实...
【在Oracle Linux 7 上安装Oracle 19c - 基于ASM存储的单实例数据库】
最新发布
AllanHwang的博客
11-13 2473
基于ASM存储，安装Oracle19c
linux下oracle11g 数据库备份异机还原
11-09
inux下oracle11g 数据库冷备份异机还原，适用于可以停机备份的数据库，方便数据库文件过大还原，本人测试的数据库文件有一百多G
ORACLE10G 在 LINUX环境下日志损坏后修复并重新处理数据(TEST5实例)
jiayue's BLOG
02-19 1842
TEST5服务器由有一些原因 出现问题 启动不了数据库 ORA-00600 [2662]错误解决过程数据库版本：7.3.2 背景：客户那边数据库突然出现一个current日志文件坏了，导致数据库crash了，然后现场工程师使用_ALLOW_RESETLOGS_CORRUPTION = TRUE这个隐含参数，做了不完全恢复后强行将数据库打开。可是打开数据库后发现只能用intern
oracle异机热备,基于用户控制的oracle热备文件的异机恢复
weixin_42236063的博客
04-04 99
测试目的：检测windows下oracle热备文件(含spfile，控制文件，数据文件，归档日志，非rman方式)异机恢复,非原路径下的恢复可用性。测试环境：windows 2003 R2，ORACLE 11G R2测试步骤：1，将原实例的热备文件拷贝到待测试环境中2，将spfile备份文件拷贝到$ORACLE_HOME/dbs/中，通过该参数文件在sqlplus下创建一份静态参数文件：3，编辑生...
ORACLE 异机恢复
weixin_30391339的博客
10-06 175
有时候需要将大的数据库发布到客户现场或转移机器时，不得不考虑在异机上恢复已经调整、测试好的库。 dumpdp 全备的方法虽然易用，但在处理对象、索引、空间的时候异常的出错,比如:见有些公司，建表、索引、对象...都是指定了 nologging,dumpdp恢复是默认是指定logging,dumpdp 也没有那么神说还要帮你去检测这些事情，结果一大堆的错误创建失败，几十个动动手改改无所谓，上百个伤...
Oracle异机恢复
weixin_30732825的博客
07-25 164
RMAN异机恢复注意事项：1、RMAN 异机恢复的时候，db_name必须相同。 如果说要想改成其他的实例名，可以在恢复成功后，用nid 命令修改。 实例名的信息会记录到控制文件里，所以如果在恢复的时候，如果实例名不一致，恢复的时候会报错。2、如果恢复的路径和源库不一致，就需要在restore时用set 命令指定新位置。 并且使用switch datafile all将信息更新的到控制文件。在做d...
linux下oracle手动建实例
06-25
在Linux环境中手动构建Oracle实例是一项高级且复杂的任务，通常适用于需要定制化配置或特殊需求的场景。本文档将根据给定的信息，详细介绍如何在Linux环境下手动创建Oracle实例的过程，并深入解释每个步骤中的关键...
linux下oracle创建实例总结
08-13
在 Linux 环境中，为了正确运行 Oracle，首先需要设置一系列环境变量，这些变量用于指定 Oracle 的安装目录、实例名等关键信息。具体操作如下： ```bash export ORACLE_BASE=/oracle export ORACLE_HOME=/oracle/...
networker for ORACLE备份与异机恢复
07-21
### Oracle备份与异机恢复知识点详解 #### 一、Oracle安装 ##### 1.1 Windows 2003 下 Oracle 安装 1. **运行安装文件**：启动Oracle安装程序，选择“基本安装”选项。 2. **指定安装目录**：按照需求选择安装路径...
Oracle数据恢复之异机恢复
03-06
今天在操作数据库的时候，发现数据操作错误，想要恢复，但是没有用事务，按理说，设置成不默认提交事务，此时所做的各种操作都没有反应到数据库中。这时，你可以rollback事务，撤销所有未提交的修改。不过，一旦commit了的话，就真没办法撤销了。好在oracle还有时间戳方法
Oracle 11g RMAN备份异机恢复 迁移数据 案例.
10-03
大牛总结的文档，全是干货！ Rman的异机恢复的作用很多，比如数据库迁移，数据库恢复，基于数据库架构调整的还原恢复(比如从RAC-->>单实例，ASM-->>文件系统)，有时候搭建测试环境也会用到，不过，这种情况下相信选择数据库复制方式比较方便。 文档打开密码见压缩包注释。
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复
10-08
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复 注：文档打开密码见压缩包注释
oracle备份恢复之rman恢复到异机
weixin_34199335的博客
12-11 382
  注意事项： 1 此处实验环境为同平台，同字节序，同版本，源机器和目标机器相同的目录结构。 2 目标机器只需要安装oracle数据库软件即可。 3 第一次利用备份恢复测试环境，之后从源机器拷贝备份到目标机器并在控制文件中注册，再见行恢复测试。   一 拷贝参数文件备份、控制文件备份、数据文件备份、以及归档备份到新主机上   1 rman 连接到源数据库   [oracle@o...
oracle异机恢复参考官方文档
weixin_34258078的博客
04-08 169
How to use Rman Duplicate on ASM/RAC/OMF/Single Instance (Doc ID 840647.1) How to perform Rman duplicate on ASM in Rac/Single instance on different host. Refer the following Article. Note.382669.1...
linux环境oracle冷备份,Oracle 冷备份以及恢复——异机备份恢复
weixin_42523975的博客
04-03 264
一、标记数据使用scott用户登录，并设置标记数据SQL>select table_name from user_tables;TABLE_NAME------------------------------DEPTEMPBONUSSALGRADEEMP_BAK创建了emp表的一个备份表emp_bak。二、备份数据库1 干净的关闭数据库SQL> shutdownimmediateDat...
ORACLE恢复简单实例
qq_19782697的博客
04-09 398
数据库的备份主要分为三种类型：冷备份;热备份;逻辑备份; 数据库的备份不是本文讨论的重点，在这里只作一个概要的介绍，Oracle数据库备份主要有： Cold?Backup(冷备份) 主要指在关闭数据库的状态下进行的数据库完全备份，备份内容包括所有数据文件、控制文件、联机日志文件、ini文件。 Hot Backup(热备份) 指在数据库处于运行状态下，对数据文件和控制文件进行备份，要使用热备份必须将...
Linux环境下Oracle10g手动创建实例教程
总结来说，Oracle10g在Linux上的手动创建实例是一个涉及多步骤的过程，要求对操作系统、Oracle数据库架构以及相关的命令行工具有深入的理解。遵循正确的步骤，确保权限设置正确，指定合适的字符集，将有助于顺利完成...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值