Forum Stats

  • 3,768,655 Users
  • 2,252,827 Discussions
  • 7,874,669 Comments

Discussions

Tablespace Recovery Missing Log Error During Media Recovery Phase

User_C2N5L
User_C2N5L Member Posts: 4 Red Ribbon
edited Jun 26, 2020 8:33PM in Recovery Manager (RMAN)

Environment is Oracle 12.1.0.2.  Attempt to perform TSPITR (time based) with  below command.

run {

recover tablespace '<ts_name>'

until time="to_date('2020-06-25 08:15:00', 'YYYY-MM-DD HH24:MI:SS')"

auxiliary destination '<auxiliary_path>';

}

......

The needed archivelog to apply is from seq 300 to 305.  However, somehow RMAN includes seq 318 from FRA (not yet being backed up) as the last log to be applied.

Does anyone else run into this issue?  How to resolve this error?  Let's assume SCN based TSPITR is not an option for now.

Thanks in advance for your response!

RMAN-08054: starting media recovery

RMAN-06050: archived log for thread 1 with sequence 300 is already on disk as file <remote_NAS_backup_path>/arch_D-SANDBOX_id-359350069_S-300_T-1_A-438753821_6mv3jfg0

RMAN-06050: archived log for thread 1 with sequence 301 is already on disk as file <remote_NAS_backup_path>/arch_D-SANDBOX_id-359350069_S-301_T-1_A-438753821_6ov3jfsh

RMAN-06050: archived log for thread 1 with sequence 302 is already on disk as file <remote_NAS_backup_path>/arch_D-SANDBOX_id-359350069_S-302_T-1_A-438753821_6qv3jn20

RMAN-06050: archived log for thread 1 with sequence 303 is already on disk as file <remote_NAS_backup_path>/arch_D-SANDBOX_id-359350069_S-303_T-1_A-438753821_6sv3ju6g

RMAN-06050: archived log for thread 1 with sequence 304 is already on disk as file <remote_NAS_backup_path>/arch_D-SANDBOX_id-359350069_S-304_T-1_A-438753821_6uv3k5b4

RMAN-06050: archived log for thread 1 with sequence 305 is already on disk as file <remote_NAS_backup_path>/arch_D-SANDBOX_id-359350069_S-305_T-1_A-438753821_70v3kcfl

RMAN-06050: archived log for thread 1 with sequence 318 is already on disk as file /oracle/sandbox/archivelog/1_318_1042202924.dbf

RMAN-06221:

Removing automatic instance

RMAN-06225: shutting down automatic instance

RMAN-06402: Oracle instance shut down

RMAN-06226: Automatic instance removed

RMAN-06407: auxiliary instance file /oracle/sandbox/export/85f28750-5e70-4bc3-b4fd-33ad3c7cb103/SANDBOX/datafile/o1_mf_sysaux_hhb65ho3_.dbf deleted

RMAN-06407: auxiliary instance file /oracle/sandbox/export/85f28750-5e70-4bc3-b4fd-33ad3c7cb103/SANDBOX/datafile/o1_mf_undotbs1_hhb64ob3_.dbf deleted

RMAN-06407: auxiliary instance file /oracle/sandbox/export/85f28750-5e70-4bc3-b4fd-33ad3c7cb103/SANDBOX/datafile/o1_mf_system_hhb64ob3_.dbf deleted

RMAN-06407: auxiliary instance file /oracle/sandbox/export/85f28750-5e70-4bc3-b4fd-33ad3c7cb103/SANDBOX/controlfile/o1_mf_hhb64dck_.ctl deleted

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

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

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

RMAN-03002: failure of recover command at 06/25/2020 14:36:45

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 317 and starting SCN of 74254896 found to restore

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

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

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

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

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

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

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

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

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

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

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