restore with brtools - need more archive redolog files

[Former Member]

Good day

I will make online backup my oracle database with brtools

(Oracle 10g, BRBACKUP 7.00 (39))

brbackup -c -d util_file_online -t online -m all -u /

-

---

bdztoexw anf 2009-01-23 15.27.40 ; 2009-01-23 16.47.21 ; 1 ............... 57 56 0 17671 226215105 17676 226268039 ALL

online util_file_online -

---

7.00 (39)

BR0280I BRBACKUP time stamp: 2009-01-23 16.43.38

-

---

BR0232I 57 of 57 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2009-01-23 16.43.40

BR0340I Switching to next online redo log file for database instance VPP ...

BR0321I Switch to next online redo log file for database instance VPP successful

BR0117I ARCHIVE LOG LIST after backup for database instance VPP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/VPP/oraarch/VPParch

Archive format %t_%s_%r.dbf

Oldest online log sequence 17673

Next log sequence to archive 17676

Current log sequence 17676 SCN: 226268039

Database block size 8192 Thread: 1

Current system change number 226268041 ResetId: 603135330

-

---

After brbackup I'll do "brarchive" in the same script:

brarchive -c -d util_file -sd -u / > $br_out_file

-

---

#ARCHIVE.. 17670 /oracle/VPP/oraarch/VPParch1_17670_603135330.dbf ; 2009-01-23 15.10.36 ; 43450368 226202112 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17671 /oracle/VPP/oraarch/VPParch1_17671_603135330.dbf ; 2009-01-23 15.36.12 ; 43430912 226215105 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17672 /oracle/VPP/oraarch/VPParch1_17672_603135330.dbf ; 2009-01-23 15.40.27 ; 43515904 226227928 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17673 /oracle/VPP/oraarch/VPParch1_17673_603135330.dbf ; 2009-01-23 15.41.06 ; 43729408 226238784 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17674 /oracle/VPP/oraarch/VPParch1_17674_603135330.dbf ; 2009-01-23 16.06.06 ; 43450368 226250315 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

#ARCHIVE.. 17675 /oracle/VPP/oraarch/VPParch1_17675_603135330.dbf ; 2009-01-23 16.43.40 ; 13243904 226263012 1

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. adztolzu svd 2009-01-23 16.51.11

• VPP util_file adztolzu svd 2009-01-23 16.47.22 ; 2009-01-23 16.54.47 ; 1 ........... 17670 17675 0 0 ------- 7.00 (39) @0603135330

-

---

BR0280I BRARCHIVE time stamp: 2009-01-23 16.51.11

BR0232I 6 of 6 files saved by backup utility

BR0230I Backup utility called successfully

BR0016I 6 offline redo log files processed, total size 220.128 MB

-

---

Then I take tape with this data and try restore only from this tape

all datafiles and relevant archive redologs files (17670-17675) restored without errors

but in the end ERROR occurred

-

---

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/VPP/sapdata1/system_1/system.data1'

ORA-00279: change 226268039 generated at 01/23/2009 16:43:40 needed for thread

1

ORA-00289: suggestion : /oracle/VPP/oraarch/VPParch1_17676_603135330.dbf

ORA-00280: change 226268039 for thread 1 is in sequence #17676

-

---

My online backup ended, before switch to redolog 17676

Why I need this file? I think files (17670-17675) should be enough?

Besides, the change 226268039 generated exactly at moment Switching to next online redo.

Can I try open database regardless of this error?

Thank you for your prompt response

Andrey Timofeev

Edited by: Andrey Timofeev on Jul 21, 2009 3:52 PM

[anindya_bose · Accepted solution]

Hi Andrey

could you please check when 17676 was generated? is that before or after 2009-01-23 16.43.40?

You could also check archSID.log file for any corruption.

[Former Member · Accepted solution]

<BR>

<P> File archSID.log is OK;<BR>

I haven't 17676 file but from log's I see, that file generate exactly in 2009-01-23 16.43.40 </P>

[Former Member · Accepted solution]

File archSID.log is OK;
I haven't 17676 file but from log's I see, that file generate exactly in 2009-01-23 16.43.40

Not sure the purpose of this recovery. But if you are happy to do a point in time recovery then you can restore upto 2009-01-23 16.43.00.

[Former Member · Accepted solution]

Not sure the purpose of this recovery. But if you are happy to do a point in time recovery then you can restore upto 2009-01-23 16.43.00.

<P>

Thank you Manoj Chintawar

I've done recovery on 10 sec earlier and it's work!

SQL> recover from '/oracle/VPP/oraarch' database until time '2009-01-23 16.43.30' using backup controlfile;

ORA-00279: change 226268020 generated at 01/23/2009 16:43:12 needed for thread

1

ORA-00289: suggestion : /oracle/VPP/oraarch/1_17675_603135330.dbf

ORA-00280: change 226268020 for thread 1 is in sequence #17675

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Log applied.

Media recovery complete.

Now I have consistent database.

But I have bad feelings about NetBackup and NetBackup's script.

I've alredy make some modification of that script for work properly.

And now, I dont know, may I guarantee reliability online productive backups

Thank you ALL for help.

</P>

[former_member204746 · Accepted solution]

online_cons will also backup offline redologs necessary for a full recovery. all of this from within brbackup. no need for barchive for this.

This is very useful for system refresh.

it also reduce risk during restore as you rely on only one tape and one backup session.

Note that you still need to run brarchive on a regular basis in case you need to recover point-in-time.

[former_member204746]

shutdown you database.

rename all your online redologs. do not delete, just rename or move just in case you need them later.

try starting DB again

recover again if needed.

good luck.

[Former Member]

<font color="navy">

shutdown you database.

rename all your online redologs. do not delete, just rename or move just in case you need them later.

try starting DB again

recover again if needed.

</font>

<P>I rename my online redologs files

/oracle/VPP/origlogA/log_g11m1.dbf

/oracle/VPP/mirrlogA/log_g11m2.dbf

/oracle/VPP/origlogB/log_g12m1.dbf

/oracle/VPP/mirrlogB/log_g12m2.dbf

/oracle/VPP/origlogA/log_g13m1.dbf

/oracle/VPP/mirrlogA/log_g13m2.dbf

/oracle/VPP/origlogB/log_g14m1.dbf

/oracle/VPP/mirrlogB/log_g14m2.dbf

but have same error

Should I restore datafile again?<P/>

<P>SQL> Alter database open resetlogs;

Alter database open resetlogs

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '/oracle/VPP/sapdata1/system_1/system.data1'

SQL> Recover database using backup controlfile;

ORA-00279: change 226268039 generated at 01/23/2009 16:43:40 needed for thread

1

ORA-00289: suggestion : /oracle/VPP/oraarch/VPParch1_17676_603135330.dbf

ORA-00280: change 226268039 for thread 1 is in sequence #17676</P>

[former_member204746]

BR0280I BRBACKUP time stamp: 2009-01-23 16.43.40

BR0340I Switching to next online redo log file for database instance VPP

so, you need that archive log generated from 2009-01-23 16.43.40

Next time, backup using online_cons.

[anindya_bose]

do you have more redolog files? if yes, then apply those

I dont think that you should go for whole database restore once again. Rather you can go for only system.data1' data file.

RUn a command

brrestore -p initSID.sap -b <backup_id_file> -d util_file -r %ORACLE_HOME%\database\initSID.utl -m 1 -l E

Recheck if the file id is '1'.

Then try point-in-time recovery to a time before the backup started or until cancel.

BEST OF LUCK

Edited by: Anindya Bose on Jul 21, 2009 9:47 PM

[former_member204746]

I would not restore system.data1.

if this file is not consistent, 99% of chances are that the rest is also non-consistent.

[Former Member]

<P>

I use script from NetBackup SAP Agent with include 2 command

brbackup -c -d util_file_online -t online -m all -u /

brarchive -c -d util_file -sd -u /

What the difference between this script and online_cons options?

They should be same, am I right?

Can I make conclusion, that NetBackup script wrong, and not work properly?

I have not VPParch1_17676_603135330.dbf but seems to me this file not important.

Possibly it contain information about switching online redologs?

How can I see what contain in change 226268039 ?

</P>

[sunny_pahuja2]

Hi Andrey,

It looks like that your database need recovery.

Check SAP Note 424102 - Restarting BRARCHIVE after creating a standby database

Thanks

Sunny

[Former Member]

<P>Good day, sorry for TAG. Once more time. <BR>

I will make online backup my oracle database with brtools<BR>

(Oracle 10g, BRBACKUP 7.00 (39))</P>

<P>brbackup -c -d util_file_online -t online -m all -u /</P>

<HR>

<P>bdztoexw anf 2009-01-23 15.27.40 2009-01-23 16.47.21 1 ............... 57 56 0 17671 226215105 17676 226268039 ALL<BR>

online util_file_online </P>

<HR>

<P> BR0280I BRBACKUP time stamp: 2009-01-23 16.43.38</P>

<HR>

<BR>

<P>BR0232I 57 of 57 files saved by backup utility<BR>

BR0230I Backup utility called successfully</P>

<P>BR0280I BRBACKUP time stamp: 2009-01-23 16.43.40<BR>

BR0340I Switching to next online redo log file for database instance VPP ...<BR>

BR0321I Switch to next online redo log file for database instance VPP successful</P>

<P>BR0117I ARCHIVE LOG LIST after backup for database instance VPP</P>

<P>Parameter Value</P>

<P>Database log mode Archive Mode<BR>

Automatic archival Enabled<BR>

Archive destination /oracle/VPP/oraarch/VPParch<BR>

Archive format %t_%s_%r.dbf<BR>

Oldest online log sequence 17673<BR>

Next log sequence to archive 17676<BR>

Current log sequence 17676 SCN: 226268039<BR>

Database block size 8192 Thread: 1<BR>

Current system change number 226268041 ResetId: 603135330</P>

<HR>

<BR>

<P>After brbackup I'll do &quot;brarchive&quot; in the same script:</P>

<P>brarchive -c -d util_file -sd -u / &gt; $br_out_file</P>

<HR>

<P>#ARCHIVE.. 17670 /oracle/VPP/oraarch/VPParch1_17670_603135330.dbf 2009-01-23 15.10.36 43450368 226202112 1<BR>

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

#COPIED... ........ ... ................. .......... ........ ........... ............<BR>

#DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

#<BR>

#ARCHIVE.. 17671 /oracle/VPP/oraarch/VPParch1_17671_603135330.dbf 2009-01-23 15.36.12 43430912 226215105 1<BR>

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

#COPIED... ........ ... ................. .......... ........ ........... ............<BR>

#DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

#<BR>

#ARCHIVE.. 17672 /oracle/VPP/oraarch/VPParch1_17672_603135330.dbf 2009-01-23 15.40.27 43515904 226227928 1<BR>

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

#COPIED... ........ ... ................. .......... ........ ........... ............<BR>

#DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

#<BR>

#ARCHIVE.. 17673 /oracle/VPP/oraarch/VPParch1_17673_603135330.dbf 2009-01-23 15.41.06 43729408 226238784 1<BR>

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

#COPIED... ........ ... ................. .......... ........ ........... ............<BR>

#DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

#<BR>

#ARCHIVE.. 17674 /oracle/VPP/oraarch/VPParch1_17674_603135330.dbf 2009-01-23 16.06.06 43450368 226250315 1<BR>

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

#COPIED... ........ ... ................. .......... ........ ........... ............<BR>

#DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

#<BR>

#ARCHIVE.. 17675 /oracle/VPP/oraarch/VPParch1_17675_603135330.dbf 2009-01-23 16.43.40 13243904 226263012 1<BR>

#SAVED.... adztolzu svd *VXF1232718526 2009-01-23 16.51.11 ........... ............<BR>

#COPIED... ........ ... ................. .......... ........ ........... ............<BR>

#DELETED.. adztolzu svd 2009-01-23 16.51.11<BR>

#<BR>

1. VPP util_file adztolzu svd 2009-01-23 16.47.22 2009-01-23 16.54.47 1 ........... 17670 17675 0 0 </P>

<HR>

<P>#</P>

<HR>

<P>BR0280I BRARCHIVE time stamp: 2009-01-23 16.51.11<BR>

BR0232I 6 of 6 files saved by backup utility<BR>

BR0230I Backup utility called successfully<BR>

BR0016I 6 offline redo log files processed, total size 220.128 MB</P>

<HR>

<P>Then I take tape with this data and try restore only from this tape<BR>

all datafiles and relevant archive redologs files (17670-17675) restored without errors <BR>

but in the end ERROR occurred</P>

<HR>

<BR>

<P>ERROR at line 1:<BR>

ORA-01195: online backup of file 1 needs more recovery to be consistent<BR>

ORA-01110: data file 1: '/oracle/VPP/sapdata1/system_1/system.data1'</P>

<P>ORA-00279: change 226268039 generated at 01/23/2009 16:43:40 needed for thread<BR>

1<BR>

ORA-00289: suggestion : /oracle/VPP/oraarch/VPParch1_17676_603135330.dbf<BR>

ORA-00280: change 226268039 for thread 1 is in sequence #17676</P>

<HR>

<BR>

<P>My online backup ended, before swith to redolog 17676<BR>

Why I need this file? I think files (17670-17675) should be enough?</P>

<P>Besides, the cange 226268039 generated exactly at moment Switching to next online redo.<BR>

Can I try open database regardless of this error?</P>

<BR>

<P>Thank you for your prompt response<BR>

Andrey Timofeev</P>

Edited by: Andrey Timofeev on Jul 21, 2009 4:53 PM

Edited by: Andrey Timofeev on Jul 21, 2009 4:54 PM

[lbreddemann]

Hi Andrey,

please make use of the <code> tags.

Did you already check whether the files are still in ONLINE BACKUP mode?

Maybe all you've to do is to "ALTER ... DATAFILE END BACKUP" to get the database open.

regards,

Lars