Restore a single file from BRBACKUP

[Former Member]

Hi All,

IN one of my NW04s system one of the datafile is got corrupted.

Kinly let me know from the offline backup using brbackup how I can restore the single file using the brrestore.

Thanks in advance.

[former_member265710]

Hi,

You can use brrestore to restore the specifc datafile with the following syntax.

brrestore -b last - m <datafile name>

For ex.

brrestore -b last - m

/oracle/C11/sapdata2/ddicd_5/ddicd.data5

More info can be found in note 14004.

then you have to recover the database using the following steps.

sqlplus "/ as sysdba"

SQL>

If the DB is running

SQL> SHUTDOWN

SQL> STARTUP MOUNT

SQL> ALTER DATABASE DATAFILE '<file1>' OFFLINE;

The DB can now be opened if it is not yet open:

SQL> ALTER DATABASE OPEN;

you might Reloaded the defective data files from the last backup using brrestore

SQL> RECOVER DATAFILE '<file1>' ;

SQL> ALTER DATABASE DATAFILE '<file1>' ONLINE;

SQL> EXIT

P.S: file 1 is your corrupted file.

hope this helps.

Regards

Arun.

[Former Member]

Hi,

check http://help.sap.com/saphelp_40b/helpdata/en/0d/d3076e4a0c11d182b80000e829fbfe/content.htm

regards,

kaushal