Linux環境下oracle數據庫Rman備份如何實現異機恢復

小編給大家分享一下Linux環境下oracle數據庫Rman備份如何實現異機恢復，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！

備份的數據庫和要恢復的數據庫OS和數據庫的版本均一致，恢復的目錄也均一致！
備份數據庫：
RMAN> backup format ‘/home/oracle/scripts/full_prod.%U’ database plus archivelog;
備份控制文件：
RMAN> backup current CONTROLFILE format '/home/oracle/scripts/control.%U';
確認所有文件夾路徑，備庫最好要創建和源庫一樣的路徑，否則需要指定路徑。
SYS@PROD> select name from v$datafile;
SYS@PROD> select member from v$logfile;
SYS@PROD> select name from v$controlfile;
傳輸spfile到要恢復的服務器
[oracle@wangxx1 dbs]$ scp spfilePROD.ora 172.16.12.117:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
SYS@PROD> create pfile from spfile;
根據pfile文件位置創建相應的目錄
[oracle@wangxx2 ~]$ mkdir -p /u01/app/oracle/oradata/PROD/
[oracle@wangxx2 dbs]$ mkdir -p /u01/app/oracle/admin/PROD/adump
傳輸備份文件到相同位置
[oracle@wangxx1 scripts]$ scp full 172.16.12.117:/home/oracle/scripts
[oracle@wangxx1 scripts]$ scp control 172.16.12.117:/home/oracle/scripts
從指定備份集恢復控制文件
[oracle@wangxx2 scripts]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jan 8 10:14:24 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: PROD (not mounted)
RMAN> set DBID=358601116
RMAN> restore CONTROLFILE  from '/home/oracle/scripts/control.07so5c0l_1_1';
Starting restore at 08-JAN-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 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/PROD/control01.ctl
output file name=/u01/app/oracle/oradata/PROD/control02.ctl
Finished restore at 08-JAN-18
RMAN> restore database;
RMAN> recover  database;
Starting recover at 08-JAN-18
using channel ORA_DISK_1
using channel ORA_DISK_2

starting media recovery

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/08/2018 11:23:34
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 49 and starting SCN of 2002997 found to restore
報錯屬于正常，因為聯機日志沒有拷貝過來！
RMAN> alter database open resetlogs;
database opened
SYS@PROD> select status from v$instance;

STATUS

OPEN

以上是“Linux環境下oracle數據庫Rman備份如何實現異機恢復”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注億速云行業資訊頻道！