Guest User

Untitled

a guest
Jan 19th, 2018
269
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. RMAN> DELETE EXPIRED BACKUP;
  2.  
  3. using channel ORA_DISK_1
  4.  
  5. List of Backup Pieces
  6. BP Key BS Key Pc# Cp# Status Device Type Piece Name
  7. ------- ------- --- --- ----------- ----------- ----------
  8. 12 12 1 1 EXPIRED DISK /home/oracle/backup/ARCHIVELOG_XYZ.16
  9.  
  10. Do you really want to delete the above objects (enter YES or NO)? yes
  11. deleted backup piece
  12. backup piece handle=/home/oracle/backup/ARCHIVELOG_XYZ.16 RECID=12 STAMP=965851791
  13. Deleted 1 EXPIRED objects
  14.  
  15.  
  16. RMAN> RUN { RESTORE DATABASE; RECOVER DATABASE; }
  17.  
  18. Starting restore at 19-JAN-18
  19. using channel ORA_DISK_1
  20.  
  21. skipping datafile 1; already restored to file /opt/oracle/data/xyz/system01.dbf
  22. skipping datafile 2; already restored to file /opt/oracle/data/xyz/sysaux01.dbf
  23. skipping datafile 3; already restored to file /opt/oracle/data/users.dbf
  24. skipping datafile 5; already restored to file /opt/oracle/data/undotbs.dbf
  25. restore not done; all files read only, offline, or already restored
  26. Finished restore at 19-JAN-18
  27.  
  28. Starting recover at 19-JAN-18
  29. using channel ORA_DISK_1
  30.  
  31. starting media recovery
  32.  
  33. RMAN-00571: ===========================================================
  34. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  35. RMAN-00571: ===========================================================
  36. RMAN-03002: failure of recover command at 01/19/2018 22:05:30
  37. RMAN-06053: unable to perform media recovery because of missing log
  38. RMAN-06025: no backup of archived log for thread 1 with sequence 15 and starting SCN of 1361136 found to restore
  39.  
  40. RMAN>
Advertisement
Add Comment
Please, Sign In to add comment