共計(jì) 4610 個(gè)字符，預(yù)計(jì)需要花費(fèi) 12 分鐘才能閱讀完成。

這期內(nèi)容當(dāng)中丸趣 TV 小編將會(huì)給大家?guī)碛嘘P(guān) ORACLE11G RMAN 備份如何恢復(fù)到異機(jī)數(shù)據(jù)庫，文章內(nèi)容豐富且以專業(yè)的角度為大家分析和敘述，閱讀完這篇文章希望大家可以有所收獲。

scp /u01/prb/rmanbk/*  oracle@prd-db2:/u01/prb/rmanbk/

恢復(fù)參數(shù)文件及控制文件

scp /u01/app/oracle/oradata/prb/control01.ctlprd-db2:/u01/app/oracle/oradata/prb/

啟動(dòng)到 mount 狀態(tài)正常

ORACLE instance started.

Total System Global Area  584568832 bytes

Variable Size    226493880 bytes

Redo Buffers    3497984 bytes

三   在新控制文件中注冊數(shù)據(jù)文件備份和歸檔備份

prd-db2- rman target /

Recovery Manager: Release 11.2.0.4.0 – Production on Wed Aug 1718:52:34 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRB (DBID=1906641159, not open)

RMAN catalog start with /u01/prb/rmanbk/

using target database control file instead of recovery catalog

searching for all files that match the pattern /u01/prb/rmanbk/

no files found to be unknown to the database

恢復(fù)整個(gè)庫

RMAN restore database;

Starting restore at 2016/08/17 18:53:42

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore frombackup set

channel ORA_DISK_1: restoring datafile 00001 to/u01/app/oracle/oradata/prb/system01.dbf

channel ORA_DISK_1: restoring datafile 00002 to/u01/app/oracle/oradata/prb/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00003 to/u01/app/oracle/oradata/prb/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00004 to/u01/app/oracle/oradata/prb/users01.dbf

channel ORA_DISK_1: reading from backup piece/u01/prb/rmanbk/fulldb_PRB_03rdg8cm_1_1

channel ORA_DISK_1: piecehandle=/u01/prb/rmanbk/fulldb_PRB_03rdg8cm_1_1 tag=TAG20160817T164718

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

Finished restore at 2016/08/17 18:53:57

RMAN recover database;

Starting recover at 2016/08/17 18:54:12

using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to defaultdestination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=7

channel ORA_DISK_1: reading from backup piece/u01/prb/rmanbk/fulldb_PRB_05rdg8d7_1_1

channel ORA_DISK_1: piecehandle=/u01/prb/rmanbk/fulldb_PRB_05rdg8d7_1_1 tag=TAG20160817T164735

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/u01/app/oracle/fast_recovery_area/PRB/archivelog/2016_08_17/o1_mf_1_7_cv8jlo4y_.arcthread=1 sequence=7

RMAN-00571:===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 08/17/2016 18:54:14

ORA-00283: recovery session canceled due to errors

RMAN-11003: failure during parse/execution of SQL statement:alter database recover logfile /u01/app/oracle/fast_recovery_area/PRB/archivelog/2016_08_17/o1_mf_1_7_cv8jlo4y_.arc

ORA-00283: recovery session canceled due to errors

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: /u01/app/oracle/oradata/prb/redo02.log

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

缺失歸檔日志情況下的恢復(fù)

prd-db2- export ORACLE_SID=prb

prd-db2- sqlplus  /as  sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 17 19:03:522016

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, OLAP, Data Mining and Real ApplicationTesting options

SQL shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL startup mount;

ORACLE instance started.

Total System Global Area 584568832 bytes

Fixed Size    2255432 bytes

Variable Size    226493880 bytes

Database Buffers    352321536 bytes

Redo Buffers    3497984 bytes

Database mounted.

SQL alter database open ;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option fordatabase open

SQL alter database open noresetlogs;

alter database open noresetlogs

*

ERROR at line 1:

ORA-01588: must use RESETLOGS option for database open

SQL alter database open resetlogs;

Database altered.

SQL select max(sequence#) from v$archived_log; 

MAX(SEQUENCE#)

————–

    7

數(shù)據(jù)庫正常啟動(dòng)

prd-db2- export ORACLE_SID=prb

prd-db2- sqlplus  /as  sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 17 19:11:492016

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, OLAP, Data Mining and Real ApplicationTesting options

SQL shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL startup

ORACLE instance started.

Total System Global Area 584568832 bytes

Fixed Size    2255432 bytes

Variable Size    226493880 bytes

Database Buffers    352321536 bytes

Redo Buffers   3497984 bytes

Database mounted.

Database opened.

上述就是丸趣 TV 小編為大家分享的 ORACLE11G RMAN 備份如何恢復(fù)到異機(jī)數(shù)據(jù)庫了，如果剛好有類似的疑惑，不妨參照上述分析進(jìn)行理解。如果想知道更多相關(guān)知識(shí)，歡迎關(guān)注丸趣 TV 行業(yè)資訊頻道。