还原种子数据库练习(二)
ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/ade/b/385031636/oracle/oradata/Seed_Database.dfb RECID=1 STAMP=762085401
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb RECID=2 STAMP=825342912
Crosschecked 2 objects
RMAN> delete expired backup; ----->>>>删除过期备份
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 EXPIRED DISK /ade/b/385031636/oracle/oradata/Seed_Database.dfb
Do you really want to delete the above objects (enter YES or NO) YES
deleted backup piece
backup piece handle=/ade/b/385031636/oracle/oradata/Seed_Database.dfb RECID=1 STAMP=762085401
Deleted 1 EXPIRED objects
RMAN> list backup; ----->>>>检查备份集的相关信息
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 253.38M DISK 00:00:58 17-SEP-11
BP Key: 2 Status: AVAILABLE Compressed: YES Tag:
Piece Name: /oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 995547 17-SEP-11 /ade/b/385031636/oracle/oradata/seeddata/system01.dbf
2 Full 995547 17-SEP-11 /ade/b/385031636/oracle/oradata/seeddata/sysaux01.dbf
3 Full 995547 17-SEP-11 /ade/b/385031636/oracle/oradata/seeddata/undotbs01.dbf
4 Full 995547 17-SEP-11 /ade/b/385031636/oracle/oradata/seeddata/users01.dbf
------->
>>上述检查后，我们就该知道要修改数据文件的名字到新的目录
RMAN> restore database;
Starting restore at 05-SEP-13
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 /ade/b/385031636/oracle/oradata/seeddata/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /ade/b/385031636/oracle/oradata/seeddata/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /ade/b/385031636/oracle/oradata/seeddata/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /ade/b/385031636/oracle/oradata/seeddata/users01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb
ORA-19504: failed to create file "/ade/b/385031636/oracle/oradata/seeddata/system01.dbf"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
failover to previous backup
creating datafile file number=1 name=/ade/b/385031636/oracle/oradata/seeddata/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/05/2013 13:59:56
ORA-01180: can not create datafi