debugMinor
cannot understand why restore database preview fails (missing archive logs)
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)
I wanted to check with 'restore ... preview' if my backup is good enough to restore database from zero.
result= failure!
reason:
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;
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/
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.dbfas 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)
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 8740124Code 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 8740124Context
StackExchange Database Administrators Q#117580, answer score: 2
Revisions (0)
No revisions yet.