warning in offline backup.

[Former Member]

hi,

i will take offline backup every day 1:00 am through DB13.( hp-ux, oracle 9.1, sap 4.7) from 3 days, it is giveing warning as

"BR0334W ststus of database file /oracle/C1P/sapdata5/temp_2.data2 is RECOVER.

"

how to solve this problem.

Regards,

SK

[Former Member · Accepted solution]

Hi,

Check the status of Datafiles thru Sqlplus

sql>SELECT NAME,FILE#,STATUS FROM V$DATAFILE;

if file /oracle/C1P/sapdata5/temp_2.data2 is in recover mode then recover it

sql> recover datafile '/oracle/C1P/sapdata5/temp_2.data2 ';

regards

Umesh K

[Former Member · Accepted solution]

hi umesh,

thanks for ans......

while doing recover, it is showing error like

"

SQL>Alter database recover datafile '/oracle/C1P/sapdata5/temp_2/temp.data2';

alter database recover datafile '/oracle/C1P/sapdata5/temp_2/temp.data2'

*

ERROR at line 1:

ORA-00279: change 178244057 generated at 05/21/2007 12:38:29 needed for thread

1

ORA-00289: suggestion : /oracle/C1P/saparch/C1Parch/1_68742.dbf

ORA-00280: change 178244057 for thread 1 is in sequence #68742

"

it is asking 21 day redo log. this redo log is in 21 day redolog backup (HP-tape drive).

then how to restore 68724.dbf log file from tape drive to saparchive folder.

Regards,

SK.

[Former Member · Accepted solution]

Hi,

As far as i know, u need to restore the archivefiles and apply the log

regards

Umesh K

[former_member204746 · Accepted solution]

easiest solution in your case:

when you can, shutdown SAP + Oarcle , drop PSAPTEMP and recreate it.

[Former Member · Accepted solution]

Hello Swati,

to restore redolog files from tape to saparch use:

brarchive -c -a <first redolog number>-<Last redolog number> -p init<SID>.sap

e.g:. brarchive -c -a 68742-68800 -p init<SID>.sap

This command will restore redolog from 68742 to 68800 into the saparch directory.

*Make sure you have enough diskspace in saparch

*Make sure your init<SID>.sap is configured properly

Regards,

Ammey Kesarkar