Software Knowledge

  1. Home
  2. Docs
  3. Software Knowledge
  4. Database
  5. Oracle: RMAN restore on clone system with ORA-01180
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Oracle: RMAN restore on clone system with ORA-01180

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