Oracle 11g R2 RAC数据库备份通过RMAN恢复到单实例数据库实现

最新推荐文章于 2023-03-30 10:17:37 发布
最新推荐文章于 2023-03-30 10:17:37 发布
阅读量350 收藏 1
点赞数
文章标签： 数据库 网络 操作系统
下面是我的一次从Oracle 11g R2 RAC到单实例间通过RMAN恢复备份集的过程，记录在此。

有些人以此方法作为RMAN备份有效性校验，当然我不反对这个说法，但我也相信RMAN提供的备份有效性校验方法，参考我整理的博文：《Oracle RMAN(Recovery Manager) – 安全性与监控》

操作环境：

  • Source DB: 2-Node Oracle Database 11g R2 RAC On Linux(11.2.0.1 with ASM)
  • Target DB: Single Instance Database 11g R2 On Linux(11.2.0.1 with FileSystem)

目标端数据库环境介绍：
[root@luocs ~]# hostname
luocs.com

[root@luocs ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/cciss/c0d0p1     388G  9.1G  359G   3% /
/dev/cciss/c0d0p3     421G  2.6G  397G   1% /data
tmpfs                 5.9G     0  5.9G   0% /dev/shm
– 目标端磁盘空间需要充足，至少要比源端所有数据文件大小还大。

源端与目标端环境已准备好，下面开始进入操作。
1.将源端的一个FULL BACKUPSET拷贝到目标端 

我在目标端创建/data/bak目录，将备份文件放于这里 [root@luocs ~]# mkdir /data/bak [root@luocs ~]# chown -R oracle.oinstall /data/bak/ 异机拷贝使用scp或者ftp方式都可以，略。 我这里备份文件已打包，所以在目标端进行解压 [oracle@luocs bak]$ tar zxvf fulldb20121211.tgz [oracle@luocs bak]$ tar zxvf ArchFile20121211.tgz


2.从备份中恢复参数文件 

我的一贯作风，在动现场之前保留一份源文件 [oracle@luocs dbs]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/dbs [oracle@luocs dbs]$ cp -p spfilehkrt.ora spfilehkrt.ora.bak 将数据库启动到nomount状态 SQL> startup nomount
ORACLE instance started. Total System Global Area 5077495808 bytes Fixed Size 2212976 bytes Variable Size 3288337296 bytes Database Buffers 1744830464 bytes Redo Buffers 42115072 bytes 通过RMAN工具还原出参数文件，还原出初始化参数文件 RMAN> restore spfile to pfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/inithkrt.ora' from '/data/bak/full_HKRT_1mnsi77q_1_1'; Starting restore at 12-DEC-2012 00:21:03 using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK

channel ORA_DISK_1: restoring spfile from AUTOBACKUP /data/bak/full_HKRT_1mnsi77q_1_1
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete Finished restore at 12-DEC-2012 00:21:05


3.编辑初始化参数文件，相应地创建所需目录 

[oracle@luocs dbs]$ cp -p inithkrt.ora inithkrt.ora.bak 我们恢复过来的参数文件是RAC的，所以我们要改成符合单实例数据库 [oracle@luocs dbs]$ cat inithkrt.ora #hkrt1.__db_cache_size=4362076160 #hkrt2.__db_cache_size=5972688896 #hkrt1.__java_pool_size=67108864 #hkrt2.__java_pool_size=67108864 #hkrt1.__large_pool_size=67108864 #hkrt2.__large_pool_size=67108864 #hkrt1.__pga_aggregate_target=7381975040 #hkrt2.__pga_aggregate_target=6710886400 #hkrt1.__sga_target=9395240960 #hkrt2.__sga_target=10066329600 #hkrt1.__shared_io_pool_size=0 #hkrt2.__shared_io_pool_size=0 #hkrt1.__shared_pool_size=4630511616 #hkrt2.__shared_pool_size=3825205248 #hkrt2.__streams_pool_size=0 #hkrt1.__streams_pool_size=134217728 *.audit_file_dest='/u01/app/oracle/admin/hkrt/adump' *.audit_trail='db' #*.cluster_database=true *.compatible='11.2.0.0.0' *.control_files='/u01/app/oracle/oradata/hkrt/control01.dbf','/u01/app/oracle/oradata/hkrt/control02.dbf' *.db_block_size=8192 #*.db_create_file_dest='+ASMDATA' *.db_domain='' *.db_name='hkrt' #*.db_recovery_file_dest='+RECOVERY' #*.db_recovery_file_dest_size=47185920000 *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=hkrtXDB)' #hkrt2.instance_number=2 #hkrt1.instance_number=1 #hkrt1.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac01-vip.hkrt.com)(PORT=1521))))' #hkrt2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac02-vip.hkrt.com)(PORT=1521))))' *.log_archive_dest_1='LOCATION=/u01/arch' #*.log_archive_dest_2='LOCATION=+ARCH' *.log_archive_format='%t_%s_%r.dbf' *.memory_target=5034213376 *.open_cursors=300 *.processes=400 #*.remote_listener='scan-cluster:1521' *.remote_login_passwordfile='exclusive' #hkrt2.thread=2 #hkrt1.thread=1 #hkrt1.undo_tablespace='UNDOTBS1' #hkrt2.undo_tablespace='UNDOTBS2' *.undo_tablespace='UNDOTBS1' 创建相应的目录 [root@luocs ~]# mkdir /u01/arch [root@luocs ~]# chown oracle.oinstall /u01/arch -- 存放归档日志文件 [root@luocs ~]# mkdir /u01/app/oracle/admin/hkrt/adump -p [root@luocs ~]# chown -R oracle.oinstall /u01/app/oracle/admin/hkrt -- 存放审计跟踪文件 [root@luocs ~]# mkdir /u01/app/oracle/oradata/hkrt/ [root@luocs ~]# chown oracle.oinstall /u01/app/oracle/oradata/hkrt/ -- 存放数据文件


4.通过编辑好的初始化参数重启数据库到NOMOUNT 

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down. SQL> create spfile from pfile; File created. SQL> startup nomount
ORACLE instance started. Total System Global Area 5077495808 bytes Fixed Size 2212976 bytes Variable Size 3288337296 bytes Database Buffers 1744830464 bytes Redo Buffers 42115072 bytes


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

我们从备份集里还原出控制文件 RMAN> restore controlfile from '/data/bak/full_HKRT_1lnsi77o_1_1'; Starting restore at 12-DEC-2012 00:35:22 using channel ORA_DISK_1

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/hkrt/control01.dbf
output file name=/u01/app/oracle/oradata/hkrt/control02.dbf Finished restore at 12-DEC-2012 00:35:23 将数据库启动到MOUNT状态 RMAN> mount database; database mounted
released channel: ORA_DISK_1


6.将备份集注册进控制文件里 

RMAN> catalog start with '/data/bak/'; searching for all files that match the pattern /data/bak/ List of Files Unknown to the Database ===================================== File Name: /data/bak/full_HKRT_1mnsi77q_1_1 File Name: /data/bak/arch_HKRT_1onsi78l_1_1 File Name: /data/bak/ArchFile20121211.tgz File Name: /data/bak/full_HKRT_1knsi76k_1_1 File Name: /data/bak/full_HKRT_1lnsi77o_1_1 File Name: /data/bak/full_HKRT_1jnsi76k_1_1 File Name: /data/bak/arch_HKRT_1nnsi78j_1_1 File Name: /data/bak/arch_HKRT_1pnsi7ha_1_1 File Name: /data/bak/fulldb20121211.tgz Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files... cataloging done List of Cataloged Files ======================= File Name: /data/bak/full_HKRT_1mnsi77q_1_1 File Name: /data/bak/arch_HKRT_1onsi78l_1_1 File Name: /data/bak/full_HKRT_1knsi76k_1_1 File Name: /data/bak/full_HKRT_1lnsi77o_1_1 File Name: /data/bak/full_HKRT_1jnsi76k_1_1 File Name: /data/bak/arch_HKRT_1nnsi78j_1_1 File Name: /data/bak/arch_HKRT_1pnsi7ha_1_1 List of Files Which Where Not Cataloged ======================================= File Name: /data/bak/ArchFile20121211.tgz
  RMAN-07517: Reason: The file header is corrupted File Name: /data/bak/fulldb20121211.tgz
  RMAN-07517: Reason: The file header is corrupted


可以通过list backup;查看，略。

7.确认数据文件、联机日志文件、临时文件路径 

SQL> set pagesize 9999 SQL> col NAME for a65
SQL> select file#,name from v$datafile; FILE# NAME ---------- ----------------------------------------------------------------- 1 +ASMDATA/hkrt/datafile/system.260.781033387 2 +ASMDATA/hkrt/datafile/sysaux.269.781033387 3 +ASMDATA/hkrt/datafile/undotbs1.264.781033387 4 +ASMDATA/hkrt/datafile/users.268.781033387 5 +ASMDATA/hkrt/datafile/undotbs2.265.781033679 6 +ASMDATA/hkrt/datafile/sell.270.786630869 7 +ASMDATA/hkrt/datafile/proxy.271.786631115 8 +ASMDATA/hkrt/datafile/pay.272.786631367 9 +ASMDATA/hkrt/datafile/payment.273.786631689 10 +ASMDATA/hkrt/datafile/cms.274.786724997 11 +ASMDATA/hkrt/datafile/itrusradb.276.787063121 12 +ASMDATA/hkrt/datafile/itruscadb.275.787061395 13 +ASMDATA/hkrt/datafile/ob2c.277.789750069 13 rows selected. SQL> col MEMBER for a65
SQL> select member from v$logfile; MEMBER ------------------------------------------------------------------------------------------------------------------------------------------------------ +ASMDATA/hkrt/onlinelog/group_5.262.781033549 +RECOVERY/hkrt/onlinelog/group_5.259.781033555 +ASMDATA/hkrt/onlinelog/group_2.266.781033537 +RECOVERY/hkrt/onlinelog/group_2.258.781033543 +ASMDATA/hkrt/onlinelog/group_1.267.781033527 +RECOVERY/hkrt/onlinelog/group_1.257.781033533 +ASMDATA/hkrt/onlinelog/group_3.259.781033803 +RECOVERY/hkrt/onlinelog/group_3.260.781033809 +ASMDATA/hkrt/onlinelog/group_4.258.781033815 +RECOVERY/hkrt/onlinelog/group_4.261.781033821 +ASMDATA/hkrt/onlinelog/group_6.257.781033825 +RECOVERY/hkrt/onlinelog/group_6.262.781033831 12 rows selected. SQL> select name from v$tempfile; NAME -------------------------------------------------------------------------------- +ASMDATA/hkrt/tempfile/temp.261.781033565


8.通过RMAN重命名数据文件和临时文件，进行还原 

RMAN> RUN { 2> SET NEWNAME FOR DATAFILE 1 to '/u01/app/oracle/oradata/hkrt/system01.dbf'; 3> SET NEWNAME FOR DATAFILE 2 to '/u01/app/oracle/oradata/hkrt/sysaux01.dbf'; SET NEWNAME FOR DATAFILE 3 to '/u01/app/oracle/oradata/hkrt/undotbs1.dbf'; SET NEWNAME FOR DATAFILE 4 to '/u01/app/oracle/oradata/hkrt/users01.dbf'; 6> SET NEWNAME FOR DATAFILE 5 to '/u01/app/oracle/oradata/hkrt/undotbs2.dbf'; SET NEWNAME FOR DATAFILE 6 to '/u01/app/oracle/oradata/hkrt/sell01.dbf'; SET NEWNAME FOR DATAFILE 7 to '/u01/app/oracle/oradata/hkrt/proxy01.dbf'; 9> SET NEWNAME FOR DATAFILE 8 to '/u01/app/oracle/oradata/hkrt/pay01.dbf'; 10> SET NEWNAME FOR DATAFILE 9 to '/u01/app/oracle/oradata/hkrt/payment01.dbf'; SET NEWNAME FOR DATAFILE 10 to '/u01/app/oracle/oradata/hkrt/cms01.dbf'; SET NEWNAME FOR DATAFILE 11 to '/u01/app/oracle/oradata/hkrt/itrusradb01.dbf'; SET NEWNAME FOR DATAFILE 12 to '/u01/app/oracle/oradata/hkrt/itruscadb01.dbf'; 14> SET NEWNAME FOR DATAFILE 13 to '/u01/app/oracle/oradata/hkrt/ob2c01.dbf'; SET NEWNAME FOR TEMPFILE 1 to '/u01/app/oracle/oradata/hkrt/temp01.dbf'; RESTORE DATABASE; 17> SWITCH DATAFILE ALL; SWITCH TEMPFILE ALL; 19> 20> } executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

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 12-DEC-2012 00:37:38 allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 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/hkrt/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/hkrt/undotbs1.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/hkrt/sell01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/hkrt/pay01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/hkrt/cms01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/hkrt/itrusradb01.dbf
channel ORA_DISK_1: reading from backup piece /u01/bak/rman_bk/full_HKRT_1knsi76k_1_1
channel ORA_DISK_1: errors found reading piece handle=/u01/bak/rman_bk/full_HKRT_1knsi76k_1_1
channel ORA_DISK_1: failover to piece handle=/data/bak/full_HKRT_1knsi76k_1_1 tag=BACKUPDATABASE
channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:06:16 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 00002 to /u01/app/oracle/oradata/hkrt/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/hkrt/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/hkrt/undotbs2.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/hkrt/proxy01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/hkrt/payment01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/hkrt/itruscadb01.dbf
channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/hkrt/ob2c01.dbf
channel ORA_DISK_1: reading from backup piece /data/bak/full_HKRT_1jnsi76k_1_1
channel ORA_DISK_1: piece handle=/data/bak/full_HKRT_1jnsi76k_1_1 tag=BACKUPDATABASE
channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:06:05 Finished restore at 12-DEC-2012 00:50:01 datafile 1 switched to datafile copy
input datafile copy RECID=14 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=15 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=16 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/undotbs1.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=17 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=18 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/undotbs2.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=19 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/sell01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=20 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/proxy01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=21 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/pay01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=22 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/payment01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=23 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/cms01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=24 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/itrusradb01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=25 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/itruscadb01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=26 STAMP=801795002 file name=/u01/app/oracle/oradata/hkrt/ob2c01.dbf

renamed tempfile 1 to /u01/app/oracle/oradata/hkrt/temp01.dbf in control file


9.修改联机日志文件的路径 

alter database rename file '+ASMDATA/hkrt/onlinelog/group_1.267.781033527' to '/u01/app/oracle/oradata/hkrt/redo1_1.log'; alter database rename file '+RECOVERY/hkrt/onlinelog/group_1.257.781033533' to '/u01/app/oracle/oradata/hkrt/redo1_2.log'; alter database rename file '+ASMDATA/hkrt/onlinelog/group_2.266.781033537' to '/u01/app/oracle/oradata/hkrt/redo2_1.log'; alter database rename file '+RECOVERY/hkrt/onlinelog/group_2.258.781033543' to '/u01/app/oracle/oradata/hkrt/redo2_2.log'; alter database rename file '+ASMDATA/hkrt/onlinelog/group_3.259.781033803' to '/u01/app/oracle/oradata/hkrt/redo3_1.log'; alter database rename file '+RECOVERY/hkrt/onlinelog/group_3.260.781033809' to '/u01/app/oracle/oradata/hkrt/redo3_2.log'; alter database rename file '+ASMDATA/hkrt/onlinelog/group_4.258.781033815' to '/u01/app/oracle/oradata/hkrt/redo4_1.log'; alter database rename file '+RECOVERY/hkrt/onlinelog/group_4.261.781033821' to '/u01/app/oracle/oradata/hkrt/redo4_2.log'; alter database rename file '+ASMDATA/hkrt/onlinelog/group_5.262.781033549' to '/u01/app/oracle/oradata/hkrt/redo5_1.log'; alter database rename file '+RECOVERY/hkrt/onlinelog/group_5.259.781033555' to '/u01/app/oracle/oradata/hkrt/redo5_2.log'; alter database rename file '+ASMDATA/hkrt/onlinelog/group_6.257.781033825' to '/u01/app/oracle/oradata/hkrt/redo6_1.log'; alter database rename file '+RECOVERY/hkrt/onlinelog/group_6.262.781033831' to '/u01/app/oracle/oradata/hkrt/redo6_2.log'; -- 上面操作在执行的时候会报ERROR，类似如下： SQL> alter database rename file '+ASMDATA/hkrt/onlinelog/group_6.257.781033825' to '/u01/app/oracle/oradata/hkrt/redo6_1.log'; alter database rename file '+ASMDATA/hkrt/onlinelog/group_6.257.781033825' to '/u01/app/oracle/oradata/hkrt/redo6_1.log' * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 14779 Session ID: 158 Serial number: 3 -- 可见报错后session被断开，我们需要重新连接实例继续往下执行 联机日志文件修改之后查看 SQL> set pagesize 9999 SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /u01/app/oracle/oradata/hkrt/redo5_1.log /u01/app/oracle/oradata/hkrt/redo5_2.log /u01/app/oracle/oradata/hkrt/redo2_1.log /u01/app/oracle/oradata/hkrt/redo2_2.log /u01/app/oracle/oradata/hkrt/redo1_1.log /u01/app/oracle/oradata/hkrt/redo1_2.log /u01/app/oracle/oradata/hkrt/redo3_1.log /u01/app/oracle/oradata/hkrt/redo3_2.log /u01/app/oracle/oradata/hkrt/redo4_1.log /u01/app/oracle/oradata/hkrt/redo4_2.log /u01/app/oracle/oradata/hkrt/redo6_1.log /u01/app/oracle/oradata/hkrt/redo6_2.log 12 rows selected.


10.恢复数据库 

RMAN> recover database; Starting recover at 12-DEC-2012 01:07:39 using channel ORA_DISK_1

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=515 channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=506 channel ORA_DISK_1: reading from backup piece /data/bak/arch_HKRT_1onsi78l_1_1
channel ORA_DISK_1: piece handle=/data/bak/arch_HKRT_1onsi78l_1_1 tag=BACKUPARCH
channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:03:35 archived log file name=/u01/arch/1_515_781033526.dbf thread=1 sequence=515 archived log file name=/u01/arch/2_506_781033526.dbf thread=2 sequence=506 channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=516 channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=507 channel ORA_DISK_1: reading from backup piece /data/bak/arch_HKRT_1pnsi7ha_1_1
channel ORA_DISK_1: piece handle=/data/bak/arch_HKRT_1pnsi7ha_1_1 tag=BACKUPARCH
channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/arch/1_516_781033526.dbf thread=1 sequence=516 archived log file name=/u01/arch/2_507_781033526.dbf thread=2 sequence=507 unable to find archived log
archived log thread=2 sequence=508 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 12/12/2012 01:11:21 RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 508 and starting SCN of 121279435


11.RESETLOGS打开数据库 

SQL> alter database open resetlogs; Database altered. 完整输出日志内容： alter database open resetlogs Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 3 of thread 2 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 3 of thread 2 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 4 of thread 2 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 4 of thread 2 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 5 of thread 1 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 5 of thread 1 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 6 of thread 2 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 6 of thread 2 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 RESETLOGS after incomplete recovery UNTIL CHANGE 121279435 Resetting resetlogs activation ID 3199883568 (0xbeba5930) Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/hkrt/redo1_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/hkrt/redo2_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 3 of thread 2 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 3 of thread 2 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/hkrt/redo3_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Wed Dec 12 01:13:12 2012 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 4 of thread 2 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 4 of thread 2 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/hkrt/redo4_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 5 of thread 1 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 5 of thread 1 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/hkrt/redo5_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 6 of thread 2 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_ora_14794.trc: ORA-00313: open failed for members of log group 6 of thread 2 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_2.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 6 thread 2: '/u01/app/oracle/oradata/hkrt/redo6_1.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Wed Dec 12 01:13:25 2012 Setting recovery target incarnation to 3 Wed Dec 12 01:13:25 2012 Assigning activation ID 3220640364 (0xbff7126c) LGWR: STARTING ARCH PROCESSES Wed Dec 12 01:13:25 2012 ARC0 started with pid=21, OS id=14930 ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES Wed Dec 12 01:13:26 2012 ARC1 started with pid=25, OS id=14934 Wed Dec 12 01:13:26 2012 ARC2 started with pid=26, OS id=14938 Wed Dec 12 01:13:26 2012 ARC3 started with pid=27, OS id=14942 ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/hkrt/redo1_1.log Current log# 1 seq# 1 mem# 1: /u01/app/oracle/oradata/hkrt/redo1_2.log Successful open of redo thread 1 Wed Dec 12 01:13:26 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Dec 12 01:13:26 2012 SMON: enabling cache recovery
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE Redo thread 2 internally disabled at seq 1 (CKPT) ARC3: Archiving disabled thread 2 sequence 1 Archived Log entry 1974 added for thread 2 sequence 1 ID 0x0 dest 1: Successfully onlined Undo Tablespace 2. Dictionary check beginning Wed Dec 12 01:13:31 2012 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_dbw0_14440.trc: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/hkrt/temp01.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/hkrt/hkrt/trace/hkrt_dbw0_14440.trc: ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/hkrt/temp01.dbf' File 201 not verified due to error ORA-01157 Dictionary check complete Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery Re-creating tempfile /u01/app/oracle/oradata/hkrt/temp01.dbf Database Characterset is AL32UTF8 No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found) Wed Dec 12 01:13:38 2012 Starting background process QMNC Wed Dec 12 01:13:38 2012 QMNC started with pid=28, OS id=14950 LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete Completed: alter database open resetlogs Wed Dec 12 01:13:52 2012 Starting background process CJQ0 Wed Dec 12 01:13:52 2012 CJQ0 started with pid=34, OS id=14982


12.后续检查
到这里RAC到单实例备份恢复已经完毕，我们可以简单检查下 

到这里RAC到单实例备份恢复已经完毕，我们可以简单检查下 SQL> select thread#,status,enabled from v$thread; THREAD# STATUS       ENABLED ---------- ------------ ---------------- 1 OPEN         PUBLIC 2 CLOSED       PUBLIC


SQL> select group#,thread#,archived,status from v$log;  GROUP#    THREAD# ARCHIV STATUS ---------- ---------- ------ -------------------------------- 1 1 NO     CURRENT 2 1 YES    UNUSED 3 2 YES    ACTIVE 4 2 YES    UNUSED 5 1 YES    UNUSED 6 2 YES    UNUSED 6 rows selected. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/arch Oldest online log sequence 1 Next log sequence to archive 1 Current log sequence 1


最后聊一下从full backupset里如何找出参数文件和控制文件备份集的方法 

[oracle@luocs bak]$ ls -l
total 10951248 -rw-r--r-- 1 oracle oinstall 3393916104 Dec 11 08:22 ArchFile20121211.tgz -rw-r----- 1 oracle oinstall 1953459712 Dec 11 01:06 arch_HKRT_1nnsi78j_1_1 -rw-r----- 1 oracle oinstall 1887318528 Dec 11 01:06 arch_HKRT_1onsi78l_1_1 -rw-r----- 1 oracle oinstall 32256 Dec 11 01:06 arch_HKRT_1pnsi7ha_1_1 -rw-r--r-- 1 oracle oinstall 569727216 Dec 11 08:21 fulldb20121211.tgz -rw-r----- 1 oracle oinstall 1928757248 Dec 11 01:01 full_HKRT_1jnsi76k_1_1 -rw-r----- 1 oracle oinstall 1450770432 Dec 11 01:01 full_HKRT_1knsi76k_1_1 -rw-r----- 1 oracle oinstall 18972672 Dec 11 01:01 full_HKRT_1lnsi77o_1_1 -rw-r----- 1 oracle oinstall 98304 Dec 11 01:01 full_HKRT_1mnsi77q_1_1


这里以full开头的就是数据文件+参数文件+控制文件的备份集，分辨方法非常简单，看大小即可。
一般最小的为参数文件备份集，大的是数据文件备份集。
如果你难以确定，直接到RMAN里尝试下就可以。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24162410/viewspace-1810949/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24162410/viewspace-1810949/

cmg3399
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
使用RMAN恢复RAC备份到单实例
wang_san_shi的专栏
03-25 2860
本文记录了使用RAC数据库的RMAN备份，恢复到单实例数据库上的过程。 1、测试环境 目标环境：Oralce linux 6.5 + Oracle 12.1.0.1   hostname：oracletest  SID:orarac RAC环境：Oracle linux 6.5 + OGI 12.1.0.1 + Oracle 12.1.0.1 + ASM   hostname：r
Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-CSDN博客_rman备份.pdf
09-13
Oracle 11g R2 的 RMAN (Recovery Manager) 是 Oracle 数据库管理系统中的一个关键工具，主要用于数据库的备份和恢复。RMAN 提供了一种高效且灵活的方式来管理和保护数据库，确保在数据丢失或系统故障时能够快速恢复...
HowTo Restore RMAN Disk backups of RAC
crhwkrhpunow61910的博客
11-07 112
From : metalink[@more@]Subject: HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node...
安装Oracle 11g R2 RAC DataGuard
weixin_34107739的博客
03-02 439
一、准备dataguard数据库服务器1、准备操作系统注：建议安装oracle数据库使用oracle linux操作系统，本实例以oracle linux 6.8做为操作系统。#关闭iptableschkconfig iptables off#关闭selinuxvim /etc/sysconfig/selinuxSELINUX=disabled#将主机名添加到hosts文件...
rac到单实例的rman恢复
cnqc11810的博客
11-26 124
1.创建单实例pfile文件,对应db_name参数,dbs下对应sid*.audit_file_dest='/u01/app/oracle/admin/cn100db/adump'*.audit_trail='d...
RAC到单实例回复rman
2301_76957510的博客
03-30 292
恢复完成后，注释no_recovery_through_resetlogs=TRUE。此为bug，pfile添加：_ no_recovery_through_resetlogs=TRUE。restore controlfile from '控制文件备份集';RMAN下：catalog start with '备份集所在目录';修改一下控制文件中日志文件路径， 接着重建控制文件。获取datafile。
oracle11g R2 DBA操作指南@oracle.org.rar
10-11
在《Oracle 11g R2 DBA操作指导手册》中，读者将学习如何规划和执行Oracle 11g R2的安装，包括选择合适的安装类型（如单实例或RAC）、配置操作系统环境、创建数据库实例以及初始化参数设置。此外，手册还会详细讲解...
基于linux5.6的Oracle11gr2的rac安装+ADG配置
11-07
Oracle 11g R2 的 Real Application Clusters (RAC) 安装是数据库管理员进行高可用性设置的重要步骤。RAC允许多个实例同时访问同一个数据库，提供故障转移和负载均衡能力。在这个环境中，ADG (Active Data Guard) 是...
Oracle11g R2 for HP-UX11.31安装手册
07-22
通过《Oracle11g R2 for HP-UX11.31安装手册》中的详细步骤和指导，IT专业人员能够系统地掌握在HP-UX平台下构建和管理RAC集群的关键技术和流程。文档中的每一个细节都是实践经验的结晶，对于那些希望在HP-UX环境中...
Oracle Database Administrator's Guide 11g Release 2 (11.2)-1082
最新发布
06-18
Oracle Database Administrator's Guide 11g Release 2 (11.2)-1082 是一份官方文档，旨在为数据库管理员提供关于Oracle 11g R2版本的详尽指导。这份指南涵盖了管理Oracle数据库的各种方面，包括安装、配置、性能...
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复
10-08
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复 注：文档打开密码见压缩包注释
OracleRac环境Rman备份与恢复
08-22
Oracle RAC环境，归档放到本地和放到ASM存储，备份规则是不同的。
Oracle RAC集群转单实例/RMAN异机恢复/RMAN迁移/RMAN备份恢复操作概要
12-14
说明：本文为Oracle RAC集群转单实例/RMAN异机恢复/RMAN迁移/RMAN备份恢复操作概要方便用户查阅 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 步骤 –全库备份（最好停止业务，备份后从ASM中复制出来redo当前组，并记录好DBID） –转储参数文件和控制文件 –关闭集群 –重新编译Oracle软件去除集群依赖 –创建单实例目录 –修改参数文件为单实例版 –调用rman rename功能修改集群数据文件为文件系统路径，然后执行恢复 –修改并重建控制文件（redo位置等） –起库（resetlogs） –测试 –完成 ★ 实验环境 ////
Linux环境下oracle数据库Rman备份异机恢复
weixin_34240657的博客
01-08 584
备份的数据库和要恢复的数据库OS和数据库的版本均一致，恢复的目录也均一致！备份数据库：RMAN> backup format ‘/home/oracle/scripts/full_prod.%U’ database plus archivelog;备份控制文件：RMAN> backup current CONTROLFILE format '/home/oracle/scripts/c...
【DB笔试面试738】在Oracle中，将RAC备份集恢复到单实例数据库的步骤有哪些？...
小麦苗DBA宝典
01-22 485
♣题目部分在Oracle中，将RAC备份集恢复到单实例数据库的步骤有哪些？ ♣答案部分将RAC备份集恢复到单实例数据库的过程基本上就是先将备份集恢复为RAC数据库，然后再将数据...
Oracle 11g R2 RAC RMAN备份脚本示例
weixin_33709364的博客
12-26 263
一、将RAC切换成归档模式1. 修改数据库的归档模式，通常在安装RAC的时候都会配置归档并且使用闪回区，已经配置过归档下面的方式可以略过。SQL> alter system set cluster_database=false scope=spfile sid='*';2. 关闭所有实例(两边都要shutdown)SQL> shutdown immediate或直...
Oracle 11gR2中针对备份恢复功能的增强
孤城烟雨话凄凉
04-24 962
1.主要内容： (1)描述11g中RMAN的新特性; (2)duplicate数据库可以直接通过网络传输,不需要有备份; (3)可以把大文件分段备份; (4)创建长期保存的归档备份; (5)管理recovery catalog; (6)描述virtual private catalogs的使用; 2.使用SET NEWNAME子句： (1)新增加的S
RAC 之 RMAN 备份
学习笔记
08-04 477
一．     RAC 归档的设置   1.1  相关理论知识 RAC 在运行的时候，每个实例都会产生归档日志，所有实例的归档日志集中在一起，才能完整地代表数据库的操作历史，此外，只有进行介质恢复（Media Recovery）时，才会用到归档日志。 进行介质恢复时，才要求在执行恢复操作的那个节点访问所有实例的归档日志。   正是因为归档日志有这些特点，所以归档位置的设计也有两种方案：
rac环境rman备份环境配置
jiujiederoushan的博客
09-29 722
rac
Oracle 10g RAC生产数据库RMAN方式恢复到异地单机数据库全程记录.doc
06-03
通过以上步骤，成功将Oracle 10g RAC生产数据库通过RMAN方式恢复到异地单机数据库，实现了数据库的平稳迁移和恢复，确保了数据的完整性和可靠性。整个过程需要仔细操作和严格执行，同时也需要灵活应对可能出现的问题...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值