RMAN:
RUN {
RESTORE DATABASE;
RECOVER DATABASE;
}
alert.log
Wed Dec 10 12:57:00 2014
Checker run found 15 new persistent data failures
Wed Dec 10 12:57:01 2014
Cannot read block 1 from O:\ORACLE\BACKUP\ORCL\BACKUP_ORCL_25754_1_INC0.DBF - restore failover to read from F:\DB\BACKUP_ORCL_25754_1_INC0.DBF
ORA-19505: failed to identify file "O:\ORACLE\BACKUP\ORCL\BACKUP_ORCL_25754_1_INC0.DBF"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) Systém nemůže nalézt uvedenou cestu.
Řešení
RMAN> crosscheck backup of database;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=360 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=O:\ORACLE\BACKUP\ORCL\BACKUP_ORCL_25438_1_INC0.DBF RECID=2
4953 STAMP=864936067
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=O:\ORACLE\BACKUP\ORCL\BACKUP_ORCL_25754_1_INC0.DBF RECID=2
5268 STAMP=865627278
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\DB\BACKUP_ORCL_25754_1_INC0.DBF RECID=25313 STAMP=865945
693
Crosschecked 3 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
------- ------- --- --- ----------- ----------- ----------
24953 24953 1 1 EXPIRED DISK O:\ORACLE\BACKUP\ORCL\BACKUP_ARBES_25438_1_INC0.DBF
25268 25268 1 1 EXPIRED DISK O:\ORACLE\BACKUP\ORCL\BACKUP_ARBES_25754_1_INC0.DBF
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=O:\ORACLE\BACKUP\ORCL\BACKUP_ORCL_25438_1_INC0.DBF RECID=2
4953 STAMP=864936067
deleted backup piece
backup piece handle=O:\ORACLE\BACKUP\ORCL\BACKUP_ORCL_25754_1_INC0.DBF RECID=2
5268 STAMP=865627278
Deleted 2 EXPIRED objects
RMAN> crosscheck backup of database;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\DB\BACKUP_ORCL_25754_1_INC0.DBF RECID=25313 STAMP=865945
693
Crosschecked 1 objects
RMAN:
RUN {
RESTORE DATABASE;
RECOVER DATABASE;
}


Komentáře