HiveBrain v1.2.0
Get Started
← Back to all entries
debugMinor

cannot understand why restore database preview fails (missing archive logs)

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
cannotwhyfailspreviewlogsdatabaseunderstandmissingrestorearchive

Problem

I am fully backing up my standby database every night with following statement. (please note that I do not use rman catalog but control file)

backup AS COMPRESSED BACKUPSET full database tag ORCL_FULL_STBY format '/oradata/archive/fast_recovery_area/%d_%T_%s_%p_FULL_STBY' plus archivelog tag ORCL_FULL_STBY delete all input;


I wanted to check with 'restore ... preview' if my backup is good enough to restore database from zero.

result= failure!

reason:

"no backup of archived log for thread 1 with sequence 65 and starting SCN of 49020676 found to restore"


I have been reading oracle documentation and blogs since days but I could not understand that even though I take full online backup yesterday if I want to restore my database today I still need archive logs of last month?

can you please review my analysis and tell me where do I do wrong ?

for example a piece from my last backup;

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1008    Full    199.25M    DISK        00:04:44     08-OCT-15
        BP Key: 1010   Status: AVAILABLE  Compressed: YES  Tag: ORCL_FULL_STBY
        Piece Name: /oradata/archive/fast_recovery_area/QIPDB1_20151008_1057_1_FULL_STBY
  List of Datafiles in backup set 1008
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 50570723   08-OCT-15 /oradata/data/qipdb1/system01.dbf
  4       Full 50570723   08-OCT-15 /oradata/data/qipdb1/users01.dbf


as you can see 'Ckp SCN' is 50570723 so my understanding tells me if restore these backups I will need archive logs on top of these SCN.
for me best candidate is

```
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1004 65.25M DISK 00:01:24 08-OCT-15
BP Key: 1006 Status: AVAILABLE Compressed: YES Tag: ORCL_FULL_STBY
Piece Name: /oradata/

Solution

I do not see your exact database version anywhere, but it seems to be the bug described in the below MOS note:

RMAN-06025 - RMAN RESTORE DATABASE PREVIEW at standby site is asking for old log (Doc ID 1599013.1)

CAUSE

Checkpoint_change# standby controlfile not refreshed properly.

BUG 15876029 - RESTORE PREVIEW ASKING OLD ARCHIVE LOG IN STANDBY DATABASE

Closed as DUPLICATE of

BUG 8740124 - CURRENT STANDBY REDO LOG GROUP SHOULD BE INCLUDED IN THE DATABASE BACKUP BY RMAN

  SOLUTION

1) Workaround is to recreate the standby controlfile.

OR

2) upgrade to 11.2.0.4 or above where Bug 8740124  is fixed

OR

3) check for availability of patch 8740124

Code Snippets

CAUSE

Checkpoint_change# standby controlfile not refreshed properly.

BUG 15876029 - RESTORE PREVIEW ASKING OLD ARCHIVE LOG IN STANDBY DATABASE

Closed as DUPLICATE of

BUG 8740124 - CURRENT STANDBY REDO LOG GROUP SHOULD BE INCLUDED IN THE DATABASE BACKUP BY RMAN

  SOLUTION

1) Workaround is to recreate the standby controlfile.

OR

2) upgrade to 11.2.0.4 or above where Bug 8740124  is fixed

OR

3) check for availability of patch 8740124

Context

StackExchange Database Administrators Q#117580, answer score: 2

Revisions (0)

No revisions yet.