Face the ORA-01180 when try to restore database with RMAN.
- folder & permission is correctly.
- rman> list backup; (found that there are a lot of backupset with “EXPIRED” status)
- rman> crosscheck backup;
- rman> run { restore database; }
Everything is OK
—— Log list backup
List of Backup Pieces for backup set 44 Copy #1
BP Key Pc# Status Piece Name
70 1 EXPIRED /backup/rman/prd/db-PRD-1gqrve22_1_1
71 2 EXPIRED /backup/rman/prd/db-PRD-1gqrve22_2_1
BS Key Type LV Size Device Type Elapsed Time Completion Time
45 Full 1.86G DISK 00:02:56 22-JAN-16
List of Datafiles in backup set 45
File LV Type Ckp SCN Ckp Time Name
24 Full 52148723 22-JAN-16 /oracle/PRD/sapdata1/sr3_21/sr3.data21
Backup Set Copy #1 of backup set 45