BR*Tools Backup Restore issues

[Former Member]

Hi Experts,

I have a problem starting the SAP server the disp+work is not starting.

We used the BRbackup tool to backup tablespace PSAPDEVUSR offline and tried to restore the tablespace with Brrestore. The file DEVUSR.DATA1 was restored but when i try to open the database i am getting the following error

SQL> Connected to an idle instance.

SQL>

SQL> ORACLE instance started.

Total System Global Area 496574992 bytes

Fixed Size 455184 bytes

Variable Size 268435456 bytes

Database Buffers 226492416 bytes

Redo Buffers 1191936 bytes

Database mounted.

ORA-01113: file 26 needs media recovery

ORA-01110: data file 26: 'G:\ORACLE\DEV\SAPDATA4\DEVUSR_1\DEVUSR.DATA1'

Now i am unable to srat SAP. Please give a solution.

Thanks in Advance.

[Former Member · Accepted solution]

Anil

If these points were helpfull award points and close thread.

Vinod

[Former Member]

HI,

SQL> STARTUP MOUNT ( IF Db is not in mount in ur case it is already so skip this)

SQL> RECOVER DATABASE

SQL> SELECT * FROM V$BACKUP WHERE STATUS = 'ACTIVE';

FILE# STATUS CHANGE# TIME

-

---

-

---

-

---

-

---

0 rows selected.

SQL>ALTER DATABASE OPEN;

Regards

Vinod

Message was edited by:

Vinod U

[Former Member]

Hello Anil,

Try to recover the database using 'recover database using backup controlfile ... ' command.

You need to apply the redo log files until the Media log recovery is complete.

Also check the following link for detail Oracle Recovery senarios.

http://examples.oreilly.com/unixbr/oracle.html

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>