RAMAN异地恢复

数据已经进行rman备份了，下面操作全备在异地备份机器上面进行操作。

首先安装数据库软件。

首先创建密码文件：
[oracle@db_test dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwlcamdb password=comtop#123
[oracle@db_test dbs]$ ls
init.ora  orapwlcamdb
[oracle@db_test dbs]$ cd 
[oracle@db_test ~]$ ls
[oracle@db_test ~]$ cd /u01
[oracle@db_test u01]$ ls
app  lost+found  soft
[oracle@db_test u01]$ mkdir -p /u01/orafile
[oracle@db_test u01]$ ls
app  lost+found  orafile  soft
[oracle@db_test u01]$ ls
app  lost+found  orafile  soft
[oracle@db_test u01]$ mkdir rman
[oracle@db_test u01]$ echo ORACLE_SID
ORACLE_SID
[oracle@db_test u01]$ echo $ORACLE_SID
lcamdb
[oracle@db_test u01]$ rman target /


Recovery Manager: Release 11.2.0.4.0 - Production on Tue Apr 18 18:55:14 2017


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


connected to target database (not started)




RMAN> set dbid=2271632629


executing command: SET DBID


RMAN> startup nomount;


startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initlcamdb.ora'


starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started


Total System Global Area    1068937216 bytes


Fixed Size                     2260088 bytes
Variable Size                285213576 bytes
Database Buffers             775946240 bytes
Redo Buffers                   5517312 bytes


RMAN> restore spfile to pfile '/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora' from '/u01/rman/full_02s210io_20170418';


Starting restore at 2017-04-18 19:02:45
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=429 device type=DISK


channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u01/rman/full_02s210io_20170418
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 2017-04-18 19:02:46


RMAN> startup force nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora';


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/18/2017 19:03:39
RMAN-04014: startup failed: ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux-x86_64 Error: 2: No such file or directory


RMAN>     


RMAN> 


RMAN> 


RMAN> startup force nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora';


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/18/2017 19:05:04
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925


RMAN> /u01/app/oracle/fast_recovery_area^C
user interrupt received




RMAN> 


RMAN> 


RMAN> 


RMAN> startup force nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora';


Oracle instance started


Total System Global Area   14397386752 bytes


Fixed Size                     2267104 bytes
Variable Size               2315257888 bytes
Database Buffers           12046041088 bytes
Redo Buffers                  33820672 bytes


RMAN> restore controlfile from '/u01/rman/full_02s210io_20170418';


Starting restore at 2017-04-18 19:07:29
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=385 device type=DISK


channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/18/2017 19:07:30
ORA-19504: failed to create file "/u01/app/oracle/fast_recovery_area/lcamdb/control02.ctl"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
ORA-19600: input file is control file  (/u01/app/oracle/oradata/lcamdb/control01.ctl)
ORA-19601: output file is control file  (/u01/app/oracle/fast_recovery_area/lcamdb/control02.ctl)


RMAN> restore controlfile from '/u01/rman/full_02s210io_20170418';


Starting restore at 2017-04-18 19:08: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/lcamdb/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/lcamdb/control02.ctl
Finished restore at 2017-04-18 19:08:23


RMAN> alter database mount;


database mounted
released channel: ORA_DISK_1


RMAN> restore database;


Starting restore at 2017-04-18 19:08:57
Starting implicit crosscheck backup at 2017-04-18 19:08:57
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=385 device type=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 2017-04-18 19:08:57


Starting implicit crosscheck copy at 2017-04-18 19:08:57
using channel ORA_DISK_1
Finished implicit crosscheck copy at 2017-04-18 19:08:57


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


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/lcamdb/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/lcamdb/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/lcamdb/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/lcamdb/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/orafile/lcam_zc_data_01.dbf
channel ORA_DISK_1: reading from backup piece /u01/rman/full_01s210i9_20170418
channel ORA_DISK_1: piece handle=/u01/rman/full_01s210i9_20170418 tag=MONDAY_INC0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 2017-04-18 19:09:13


RMAN> recover database;


Starting recover at 2017-04-18 19:09:37
using channel ORA_DISK_1


starting media recovery


unable to find archived log
archived log thread=1 sequence=44
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/18/2017 19:09:38
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 44 and starting SCN of 1505607


RMAN> alter database open resetlogs;


database opened


RMAN> 

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

转载于:http://blog.itpub.net/28869493/viewspace-2137562/