rman备份恢复要异机

最新推荐文章于 2024-07-02 14:24:02 发布
最新推荐文章于 2024-07-02 14:24:02 发布
阅读量136 收藏
点赞数
文章标签： 数据库
这里分两个数据库;
本地数据库sid=PROD1   ip：192.168.0.11
远端数据库（应该说是数据库软件）ip：192.168.0.15
本地库和目标库sid应该一样，（因为我们用的是本地库的控制文件，如果sid不一样，不法使用，到时候控制文件里的database name无法改）
而本地路径和远端库路径可以一样，只不过这样更简单恢复。而路径不一样也没事，用set newname for datafile ,但必须写在run块里）
1、在本地数据库创建完整备份（数据文件、归档日志、控制文件）
RMAN> backup database plus archivelog;


Starting backup at 27-FEB-16
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=73 RECID=9 STAMP=904917179
input archived log thread=1 sequence=74 RECID=8 STAMP=904917179
input archived log thread=1 sequence=75 RECID=4 STAMP=904917179
input archived log thread=1 sequence=76 RECID=11 STAMP=904917179
input archived log thread=1 sequence=77 RECID=6 STAMP=904917179
input archived log thread=1 sequence=78 RECID=2 STAMP=904917179
input archived log thread=1 sequence=79 RECID=10 STAMP=904917179
input archived log thread=1 sequence=80 RECID=12 STAMP=904917179
input archived log thread=1 sequence=81 RECID=13 STAMP=904917179
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35po7c_.bkp tag=TAG20160227T203013 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=18 STAMP=904917179
input archived log thread=1 sequence=2 RECID=17 STAMP=904917179
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35pp92_.bkp tag=TAG20160227T203013 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=5 STAMP=904917179
input archived log thread=1 sequence=2 RECID=14 STAMP=904917179
input archived log thread=1 sequence=3 RECID=21 STAMP=904917179
input archived log thread=1 sequence=4 RECID=19 STAMP=904917179
input archived log thread=1 sequence=5 RECID=23 STAMP=904917179
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35pqbq_.bkp tag=TAG20160227T203013 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=25 STAMP=904920922
input archived log thread=1 sequence=2 RECID=26 STAMP=904920922
input archived log thread=1 sequence=3 RECID=27 STAMP=904920922
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35prdd_.bkp tag=TAG20160227T203013 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=28 STAMP=904923996
input archived log thread=1 sequence=2 RECID=29 STAMP=904923999
input archived log thread=1 sequence=3 RECID=30 STAMP=904924002
input archived log thread=1 sequence=4 RECID=31 STAMP=904924006
input archived log thread=1 sequence=5 RECID=32 STAMP=904924010
input archived log thread=1 sequence=6 RECID=33 STAMP=904924013
input archived log thread=1 sequence=7 RECID=34 STAMP=904924017
input archived log thread=1 sequence=8 RECID=35 STAMP=904924020
input archived log thread=1 sequence=9 RECID=36 STAMP=904924024
input archived log thread=1 sequence=10 RECID=37 STAMP=904924027
input archived log thread=1 sequence=11 RECID=38 STAMP=904924031
input archived log thread=1 sequence=12 RECID=39 STAMP=904924035
input archived log thread=1 sequence=13 RECID=40 STAMP=904924038
input archived log thread=1 sequence=14 RECID=46 STAMP=904925214
input archived log thread=1 sequence=15 RECID=41 STAMP=904925214
input archived log thread=1 sequence=16 RECID=42 STAMP=904925214
input archived log thread=1 sequence=17 RECID=44 STAMP=904925214
input archived log thread=1 sequence=18 RECID=43 STAMP=904925214
input archived log thread=1 sequence=19 RECID=48 STAMP=904926339
input archived log thread=1 sequence=20 RECID=49 STAMP=904926340
input archived log thread=1 sequence=21 RECID=50 STAMP=904926340
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35psgn_.bkp tag=TAG20160227T203013 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=51 STAMP=904928710
input archived log thread=1 sequence=2 RECID=52 STAMP=904928778
input archived log thread=1 sequence=3 RECID=53 STAMP=904940992
input archived log thread=1 sequence=4 RECID=54 STAMP=904941012
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35q8jb_.bkp tag=TAG20160227T203013 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-FEB-16

Starting backup at 27-FEB-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD1/undotbs01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD1/sysaux01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/tt01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/tbs01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/ts01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/PROD1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp tag=TAG20160227T203033 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_ncsnf_TAG20160227T203033_cf35qsq9_.bkp tag=TAG20160227T203033 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-FEB-16

Starting backup at 27-FEB-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=55 STAMP=904941050
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203050_cf35qttx_.bkp tag=TAG20160227T203050 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-FEB-16

RMAN> backup current controlfile;

Starting backup at 27-FEB-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 27-FEB-16
channel ORA_DISK_1: finished piece 1 at 27-FEB-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_ncnnf_TAG20160227T203118_cf35rqkg_.bkp tag=TAG20160227T203118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-FEB-16
2、把备份集和参数文件传到远端库
[oracle@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Feb 27 20:47:43 2016

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 Application Testing options

SQL> create pfile from spfile;

File created.
SQL> !
[oracle@localhost dbs]$ ls
cntrlPROD1.dbf  hc_PROD.dat  initPROD1.ora  lkPROD1     snapcf_PROD1.f   spfilePROD1.ora.bak
hc_PROD1.dat    init.ora     lkDUMMY        orapwPROD1  spfilePROD1.ora
scp initPROD1.ora domain:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initPROD1.ora
The authenticity of host 'domain (192.168.0.15)' can't be established.
RSA key fingerprint is 78:dc:af:49:74:74:72:81:b5:7a:47:76:b1:03:71:fa.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'domain,192.168.0.15' (RSA) to the list of known hosts.
oracle@domain's password:
initPROD1.ora                                                100%  975     1.0KB/s   00:00   
[oracle@localhost 2016_02_27]$ scp *.bkp domain:/u01/app/oracle/fast_recovery_area/
oracle@domain's password:
o1_mf_annnn_TAG20160227T203013_cf35po7c_.bkp                 100%   32MB  31.6MB/s   00:01   
o1_mf_annnn_TAG20160227T203013_cf35pp92_.bkp                 100% 3274KB   3.2MB/s   00:00   
o1_mf_annnn_TAG20160227T203013_cf35pqbq_.bkp                 100% 2500KB   2.4MB/s   00:00   
o1_mf_annnn_TAG20160227T203013_cf35prdd_.bkp                 100% 3447KB   3.4MB/s   00:00   
o1_mf_annnn_TAG20160227T203013_cf35psgn_.bkp                 100%  954MB 106.0MB/s   00:09   
o1_mf_annnn_TAG20160227T203013_cf35q8jb_.bkp                 100% 3720KB   3.6MB/s   00:00   
o1_mf_annnn_TAG20160227T203050_cf35qttx_.bkp                 100% 4096     4.0KB/s   00:00   
o1_mf_ncnnf_TAG20160227T203118_cf35rqkg_.bkp                 100% 9888KB   9.7MB/s   00:01   
o1_mf_ncsnf_TAG20160227T203033_cf35qsq9_.bkp                 100% 9920KB   9.7MB/s   00:00   
o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp                 100% 1379MB  98.5MB/s   00:14  
 3、创建参数文件相关目录（在远端数据库）
[oracle@domain ~]$ mkdir -p /u01/app/oracle/admin/PROD1/adump
[oracle@domain ~]$ mkdir -p /u01/app/oracle/oradata/PROD1/
[oracle@domain ~]$ mkdir -p /u01/app/oracle/fast_recovery_area/PROD1/
[oracle@domain ~]$ mkdir -p /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/
4、恢复控制文件
[oracle@domain dbs]$ rman target/

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Feb 27 21:17:30 2016

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

connected to target database: PROD1 (not mounted)

RMAN> restore controlfile from '/u01/app/oracle/fast_recovery_area/o1_mf_ncnnf_TAG20160227T203118_cf35rqkg_.bkp'; 知道路径不用DBID

Starting restore at 27-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 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/PROD1/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/PROD1/control02.ctl
Finished restore at 27-FEB-16

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

5、恢复数据库
RMAN> restore database;

Starting restore at 27-FEB-16
Starting implicit crosscheck backup at 27-FEB-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
Crosschecked 18 objects
Finished implicit crosscheck backup at 27-FEB-16

Starting implicit crosscheck copy at 27-FEB-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 27-FEB-16

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/27/2016 21:18:37
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> restore database;

Starting restore at 27-FEB-16
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/27/2016 21:22:44
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> list backup;

specification does not match any backup in the repository

RMAN> catalog start with '/u01/app/oracle/fast_recovery_area/PROD1/backupset'; 如果备份集没放到默认位置，控制文件是不知道的，此时可以注册进去用catalog start with 加路径
searching for all files that match the pattern /u01/app/oracle/fast_recovery_area/PROD1/backupset

List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35pqbq_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203050_cf35qttx_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35po7c_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35pp92_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_ncsnf_TAG20160227T203033_cf35qsq9_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35prdd_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_ncnnf_TAG20160227T203118_cf35rqkg_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35psgn_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35q8jb_.bkp

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/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35pqbq_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203050_cf35qttx_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35po7c_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35pp92_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_ncsnf_TAG20160227T203033_cf35qsq9_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35prdd_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_ncnnf_TAG20160227T203118_cf35rqkg_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35psgn_.bkp
File Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203013_cf35q8jb_.bkp

RMAN> recover database;

Starting recover at 27-FEB-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/27/2016 21:25:06
RMAN-06094: datafile 1 must be restored

RMAN> restore datafile 1;

Starting restore at 27-FEB-16
using channel ORA_DISK_1

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/PROD1/system01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp tag=TAG20160227T203033
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 27-FEB-16

RMAN> alter database open;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/27/2016 21:25:59
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/27/2016 21:26:09
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/PROD1/system01.dbf'

RMAN> restore database;

Starting restore at 27-FEB-16
using channel ORA_DISK_1

skipping datafile 1; already restored to file /u01/app/oracle/oradata/PROD1/system01.dbf
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/PROD1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/PROD1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/PROD1/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/tbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/ts01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/tt01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_nnndf_TAG20160227T203033_cf35q9p6_.bkp tag=TAG20160227T203033
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 27-FEB-16

RMAN> recover database;

Starting recover at 27-FEB-16
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=5
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203050_cf35qttx_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_27/o1_mf_annnn_TAG20160227T203050_cf35qttx_.bkp tag=TAG20160227T203050
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/PROD1/archivelog/2016_02_27/o1_mf_1_5_cf397p5r_.arc thread=1 sequence=5
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_27/o1_mf_1_5_cf397p5r_.arc RECID=56 STAMP=904944630
unable to find archived log
archived log thread=1 sequence=6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/27/2016 21:30:31
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 6 and starting SCN of 1195148

RMAN> recover database until cancel;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input

RMAN> recover database until sequence 5;

Starting recover at 27-FEB-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/27/2016 21:33:06
RMAN-06556: datafile 1 must be restored from backup older than SCN 1195123

RMAN> recover database;

Starting recover at 27-FEB-16
using channel ORA_DISK_1

starting media recovery

unable to find archived log
archived log thread=1 sequence=6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/27/2016 21:33:29
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 6 and starting SCN of 1195148

RMAN> recover database until scn 1195148;

Starting recover at 27-FEB-16
using channel ORA_DISK_1

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

Finished recover at 27-FEB-16

RMAN> alter database open resetlogs;

database opened

整体是一个不完全恢复，因为没有在线日志，当然可以把本地库shutdown，然后拷贝日志文件做完全恢复。

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

转载于:http://blog.itpub.net/30604784/viewspace-2072346/

cmjv45501
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
rman恢复方案和oracle异机恢复
09-10
在异机恢复时，可能需要调整数据库的初始化参数，比如`compatible`参数要与新服务器上的Oracle软件版本相匹配，以及`db_files`参数要设置为新的文件系统能容纳的最大数据文件数。 3. **使用RMAN恢复** 使用RMAN...
因incarnation导致恢复时出现RMAN-06026错误
还不算晕的专栏
06-12 4906
正常恢复控制文件并MOUNT数据库 环境： 生产环境进行备份数据库、控制文件 测试环境在之前执行过异机恢复任务，并进行过RESETLOGS操作，并遗留下每次RESETLOGS后的归档日志。 在使用生产环境的备份进行恢复时，报错： RMAN-06026: some targets not found - aborting restore RMAN-06100: no channel
RMAN-06026: 有些目标没有找到 - 终止还原
最新发布
yeshuoChen的博客
07-02 241
把闪回恢复目录db_recovery_file_dest里面残留的文件都删除后，可以正常恢复了。RMAN-06026: 有些目标没有找到 - 终止还原。RMAN-06023: 没有找到数据文件7的副本来还原。RMAN-06023: 没有找到数据文件4的副本来还原。RMAN-06023: 没有找到数据文件3的副本来还原。RMAN-06023: 没有找到数据文件1的副本来还原。RMAN还原时报没有找到数据文件副本。
RMAN-06026报错解决方法
weixin_30807677的博客
09-07 528
环境：oracle 11g rac asm for linux 6.7 将系统备份，准备恢复至备机上，将pfile备份拷贝至备机 1.删除备机的现有库 sql> shutdown immediate sql> startup mount restrict sql> drop database; 2.使用spfile创建pfile sql>crea...
RMAN RESTORE fails with RMAN-06023 or ORA-19505 or RMAN-06100
huoshuyinhua的专栏
01-02 830
某个库用nbu做了一个全库备份但不知什么原因，输出日志没了，为了验证备份有效性，使用restore validate database 验证备份有效性。 报错 RMAN> restore validate database; Starting restore at 07-SEP-2007 20:38:21 allocated channel: ORA_DISK_1 chann
oracle备份恢复之rman恢复到异机
08-06
### Oracle备份恢复之RMAN恢复到异机 在Oracle数据库管理中，为了保障数据的安全性和系统的可用性，定期进行数据库备份至关重要。其中一种常见的备份工具是Recovery Manager（RMAN），它提供了强大的备份与恢复功能...
rman异机恢复流程.txt
02-06
使用Rman工具异机恢复oracle数据库，实例教程 ------------------------------------- ------------------------------------- 备份方法 修改路径 恢复方法
ORACLE RMAN备份恢复指南
07-26
### ORACLE RMAN备份恢复指南 #### 引言 本文旨在详细介绍Oracle RMAN（Recovery Manager）备份与恢复的相关操作及技术要点。RMAN作为Oracle官方提供的强大工具，专为数据库备份、恢复以及灾难恢复而设计。对于...
数据迁移的时候出现RMAN-03002，RMAN-06026
cmbzwa6940的博客
12-08 816
这几天做了一个生产到测试的整个数据库的数据迁移，数据大概是1.5T左右，从生产全备份备份完成以后，传输至测试库开始恢复，测试数据库恢复完控制文件，开始使用rman恢复数据文件的时候出现 RMAN-005...
教你快速掌握解决RMAN-06026错误的方法
08-09 360
问题：在数据库损坏的情况下，如果恢复时报RMAN-06026错误应当如何解 解答：如果你没有使用catalog，你可以选择dbms_backup_restore来进行恢复。1、具体的错误信息...
RMAN-06094 Datafile does not exist
congfen5646的博客
05-08 413
RMAN-06094 Datafile does not exist Applies to:oracle server version 10.2.0.2 and later.Symptomeswhen trying t...
笔记：物理Standby搭建时恢复报错RMAN-03002 RMAN-06026 RMAN-06100
Lizi_TT的博客
07-31 665
说明: 在进行physical standby搭建过程中，使用rman恢复灾备库，出现报错RMAN-03002 RMAN-06026 RMAN-06100，无法正常恢复数据库。 错误信息： RMAN> RMAN-03090: Starting restore at 2020-07-31 09:40:32 RMAN-06009: using target database control file instead of recovery catalog RMAN-08030: allocated ch
adg的archive出现gap，使用增量恢复的方式进行恢复adg，RMAN-06094: datafile 1 must be restored
09-19 2773
①　主库丢失归档文件，然后在不重建物理dg的情况下来恢复物理dg 一.4.2 实验过程 一.4.2.1 主备库环境 查看主库的信息： SQL>select protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$database; PRO...
dg中基于scn恢复RMAN-06094故障解决
Brent的专栏
02-05 1490
dataguard中出现gap后,采用基于scn的备份和恢复的方法进行恢复. 在恢复的过程中出现报错: RMAN> recover database noredo; Starting recover at 05-FEB-20 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 usin...
控制文件与数据文件头SCN不一致导致数据库无法启动故障处理 Fuzzy scn
mygodhome的专栏
10-25 1563
Reference: https://www.askmaclean.com/archives/rman-06026-absolute_fuzzy_change.html https://blog.csdn.net/songxixi/article/details/7010934 RMAN> run{ debug on; set until time "to_date('2013-08...
RMAN-06026 错误的解决 (RMAN恢复案例三 — 所有控制文件丢失(2))
congkutu8778的博客
04-11 185
情景回顾：尝试做RMAN恢复实验，首先做了一个全备，然后shutdown，删除所有controlfile，后恢复。然后又shutdown，删除所有controlfile和datafile，尝试恢复出现以下情况： C:\Docu...
Oracle RMAN备份与异机恢复详解
本文档详细介绍了如何在异机环境中使用RMAN进行备份和恢复的过程，特别关注了全量备份的情况，并强调了数据库SID的一致性。" 在Oracle数据库管理中，RMAN是数据库管理员的关键工具，它能够执行多种类型的备份，包括...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值