Oracle: To get Which Backup File has an Archived log

 MAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 12/12/2013 14:27:48

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 1 with sequence 263960 and starting SCN of 34650648110 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263959 and starting SCN of 34648105015 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263958 and starting SCN of 34648101702 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263957 and starting SCN of 34646674493 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263956 and starting SCN of 34646668173 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263955 and starting SCN of 34646656561 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263954 and starting SCN of 34641805015 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263953 and starting SCN of 34638161381 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263952 and starting SCN of 34638152744 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263951 and starting SCN of 34638132311 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263950 and starting SCN of 34638117540 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263949 and starting SCN of 34638072373 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263948 and starting SCN of 34637969044 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263947 and starting SCN of 34637657991 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263946 and starting SCN of 34637326273 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263945 and starting SCN of 34637295691 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263944 and starting SCN of 34637289617 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263943 and starting SCN of 34637264143 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 263942 and starting SCN of 34637198376 foun



RMAN> list backup of archivelog sequence 263838;



List of Backup Sets

===================



BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

21050   249.73M    DISK        00:01:02     12-DEC-13

        BP Key: 21058   Status: AVAILABLE  Compressed: YES  Tag: TAG20131212T103010

        Piece Name: /usr/opt/app/dbdump/hot_backup/HRPROD/HRPROD_ARC_T20131212_s317_p1_833970613.bak


  List of Archived Logs in backup set 21050

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    263838  34627555091 12-DEC-13 34627561818 12-DEC-13

  

  

  

  ANOTHER POSSIBLE OUTPUT

  ========================

          Piece Name: /usr/opt/app/dbdump/hot_backup/HRPROD/temp/HRPROD_ARC_T20131212_s321_p1_833970757.bak


  List of Archived Logs in backup set 25452

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    263929  34632897357 12-DEC-13 34632902497 12-DEC-13

  1    263930  34632902497 12-DEC-13 34632908378 12-DEC-13

  1    263931  34632908378 12-DEC-13 34632919168 12-DEC-13

  1    263932  34632919168 12-DEC-13 34632998246 12-DEC-13

  1    263933  34632998246 12-DEC-13 34633008898 12-DEC-13

  1    263934  34633008898 12-DEC-13 34633139591 12-DEC-13

  1    263935  34633139591 12-DEC-13 34633195970 12-DEC-13

  1    263936  34633195970 12-DEC-13 34633221518 12-DEC-13

  1    263937  34633221518 12-DEC-13 34633770030 12-DEC-13


Comments

Post a Comment

Popular posts from this blog

Postgres: Clean up stopped replication slot

Image
  When a slot is inactive, that means that Murty and his team have stopped the replication on their side. The SQL below will identify inactive slots. We should schedule this script in a job , running every hour.    (1) SELECT  slot_name,  pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(),restart_lsn)) AS size,  active,  slot_type  FROM pg_replication_slots;       (2) Once you identify the replication slot, the job should drop it with the following command:     SELECT pg_drop_replication_slot ('pg_replication_slot_name_from_above');         (3) Restart the database instance to clean up unwanted disk space.   Notes from Google:- Thank you for contacting Google Cloud Support. My name is Jagadeesh and I will be assisting you with this issue.   I understand that WAL logs are expanding to over 1.5TB and you want to know what is causing WAL logs to grow and you want to reduce it. Please confirm if ...
Read more