Recovery Manager: Release 10.2.0.5.0 - Production on Thu Jul 31 13:51:40 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
RMAN> set dbid 1619708557
executing command: SET DBID
RMAN> startup nomount
Oracle instance started
Total System Global Area 8388608000 bytes
Fixed Size 2109640 bytes
Variable Size 5117054776 bytes
Database Buffers 3221225472 bytes
Redo Buffers 48218112 bytes
RMAN> restore controlfile from '/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854376584_9xmsr8fm_.bkp';
Starting restore at 31-JUL-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1084 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output filename=/home/oracle/orabase/oradata/ORACLE/control01.ctl
output filename=/home/oracle/orabase/oradata/ORACLE/control02.ctl
output filename=/home/oracle/orabase/oradata/ORACLE/control03.ctl
Finished restore at 31-JUL-14
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
RMAN> restore database;
启动 restore 于 31-7月-14
使用通道 ORA_DISK_1
创建数据文件 fno = 1 名称 = /home/oracle/orabase/oradata/ORACLE/system01.dbf
MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore 命令 (在 07/31/2014 12:06:00 上) 失败
ORA-01180: 无法创建数据文件 1
ORA-01110: 数据文件 1: '/home/oracle/orabase/oradata/ORACLE/system01.dbf'
RMAN>
RMAN> crosscheck backupset;
Starting implicit crosscheck backup at 31-JUL-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1084 devtype=DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 31-JUL-14
Starting implicit crosscheck copy at 31-JUL-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 31-JUL-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /home/oracle/orabase/flash_recovery_area/ORACLE/archivelog/2014_07_31/o1_mf_1_116_9xm5yprp_.arc
File Name: /home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673
crosschecked backup piece: found to be 'EXPIRED'
ba