RESTORING INFORMATION: brrestore command

[Former Member]

Hi .. I'm new on this one ..

The problem in question is the following:

OPERATING SYSTEM VERSION:

patito:root:> uname -a

OSF1 patito V4.0 1229 alpha

patito:root:> sizer -v

Digital UNIX V4.0F (Rev. 1229); Mon May 3 13:36:23 EDT 2004

PROBLEM:

We had 4 disks damaged and they have been replaced right now

After that we aplied the following commands on digital operating system for creating:

sap_domain6#sapdata6 /oracle/SP1/sapdata6 advfs

sap_domain6#sapdata9 /oracle/SP1/sapdata9 advfs

1. disklabel -rw rzf32

2. mkfdmn /dev/rzf32c sap_domain6

3. mkfset sap_domain6 sapdata6

4. mkfset sap_domain6 sapdata9

5. mount sap_domain6#sapdata6 /oracle/SP1/sapdata6

6. mount sap_domain6#sapdata9 /oracle/SP1/sapdata9

After these commands, Fs's there were built:

We have to restore 2 fs:

sap_domain6#sapdata6 71095392 32 71078016 1% /oracle/SP1/sapdata6

sap_domain6#sapdata9 71095392 32 71078016 1% /oracle/SP1/sapdata9

Right now , we are ok for restore the information ONLY for

/oracle/SP1/sapdata6

/oracle/SP1/sapdata9

We are new on this one .... :' (

please help us with the following doubt:

We reviewed the script that does the backup and is using the following:

on cron:

00 10 * * 3 /backup/script/brbackup_SP1 1> /dev/null 2>&1

and the script named initSP1-DualTapes.sap contains a line :

su - userora -c 'nohup brbackup -p initSP1-DualTapes.sap -u system/`/pass`

-c "-a -cds -c"'

the file initSP1-DualTapes.sap is a profile for userora.

we have reviewed that we can use brrestore command for restoring the following file systems:

/oracle/SP1/sapdata6

/oracle/SP1/sapdata9

Could you tell us .. how can we use brrestore only for restoring above fs's showed?

Is correct the following command:

su - orauser -c 'brrestore -p initSP1-DualTapes.sap -u system/`/pass` -c "-a -cds -c"' -m /oracle/SP1/sapdata6

su - orauser -c 'brrestore -p initSP1-DualTapes.sap -u system/`/pass` -c "-a -cds -c"' -m /oracle/SP1/sapdata9

PLEASE, HELP US ...

THANKS A LOT.

[former_member185954]

Hi Daniela,

You might want to do 2 things first restore those 2 directories and then restore some archive logs when the database will start recovering those two restored directories and synching them with existing sapdatas.

Also while restoring the backup log, you need to specify -b parameter and specify which online/offline backup needs to be used to retrieve those directories.

This log file should be chosen from the sapbackup directory you should choose the latest online full backup for the same.

su - orauser -c 'brrestore -p initSP1-DualTapes.sap -u system/`/pass` -b <backup log> -m /oracle/SP1/sapdata6

su - orauser -c 'brrestore -p initSP1-DualTapes.sap -u system/`/pass` -b <backup log> -m /oracle/SP1/sapdata9

Also note that the options -a cds -c is not required , cause that's used by brbackup to specify to run archive log backup in unattended mode when the online backup completes cds= copy,delete and save.

Now once you have run the restore, you should start oracle in mount stage and then try to recover the database with auto option the database will immediately tell you which archive log files you will need if its not able to find them on your system.

if the specified archive log file is not found on the system, you will need to restore them from your backup system using the command.

su - orauser -c 'brrestore -p initSP1-DualTapes.sap -u system/`/pass` -a<start number>-<end number>=/oracle/<SID>/saparch

start number = the log file requested

end number = the last log file generated by the database.

Please ensure that you have enough space in the saparch to restore all your deleted log files, if not possible, then restore in parts , the recover that you have started should be able to pickup files one by one.

Hope that helps,

Regards,

Siddhesh

[former_member185954]

Hi Daniela,

Here are some examples:

brrestore -b last -m all

Restore all tablespaces without the control file and online redo log files, starting from the last successful backup.

brrestore -b bcnmhluz.aft -m full

Restore all the files from backup bcnmhluz.aft , including the control file and the online redo log files. Restore the mirror copies of the control file and the online redo log files.

brrestore -m /usr/sap/C11/SYS/profile

Restore the SAP profiles.

brrestore -m /usr/sap/C11/SYS/exe/run:sapdba

Restore the SAPDBA executable.

brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5

Restore all the database data files that were originally stored in the subdirectories of /oracle/C11/sapdata1 in directory /oracle/C11/sapdata5 .

brrestore -b last -m 1-10,01-04,0

Restore all the database data files with ORACLE file IDs from 1 through 10, the four online redo log files, and the control file starting from the last successful backup. Restore the mirror copies of the control file and the online redo log files.

brrestore -m 0

Restore the control file. Restore the mirror copies of the control file.

brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5

Restore a database data file starting from the last successful backup.

brrestore -a 200-220

Restore the archived redo log files with the log sequence numbers from 200 through 220 into the archiving directory.

brrestore -a 40-70=/oracle/C11/sapbackup, 71-90=/oracle/C11/sapreorg

Restore the archived redo log files with the log sequence numbers from 40 through 70 in directory sapbackup and those with the log sequence numbers from 71 through 90 in directory /oracle/C11/sapreorg .

brrestore -a 40-69,70-100=/oracle/C11/sapbackup

Restore the archived redo log files with the log sequence numbers from 40 through 69 in the archiving directory, and those with the log sequence numbers from 70 through 100 in directory sapbackup .

brrestore -n det_log

Restore a detail log to the local working directory.

I found this from sap documentation, i keep it handy with me , here is the official link:

http://help.sap.com/saphelp_47x200/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/frameset.htm

Regards,

Siddhesh

[former_member204746]

check the following page:

http://service.sap.com/~form/sapnet?_SHORTKEY=00200797470000049528&;

[Former Member]

Hi . thanks for answering ...

but .. i do not have access to that portal ..

[Former Member]

Hi

Here are the BRRESTORE with command options (as below), thate override the

values in the initialization profile.

brrestore

[-a|-archive|-a1|-archive1 [<DBSID>,]<log_no>[=<rest_dest>]|

[<DBSID>,]<log_no1>-<log_no2>[=<rest_dest>]|[<DBSID>,]

<log_no_list>[==<rest_dest>]]

[-a2|-archive2 [<DBSID>,]<log_no>[=<rest_dest>]|

[<DBSID>,]<log_no1>-<log_no2>[=<rest_dest>]|[<DBSID>,]

<log_no_list>[==<rest_dest>]]

[-b|-backup|-b1|-backup1 <log name>|last]

[-b2|-backup2 <util_backup_id>|#NULL

[-c|-confirm [force]]

[-d|-device tape|disk|pipe|tape_auto|pipe_auto|tape_box|pipe_box|

util_file|stage|rman_util|rman_disk|rman_stage|rman]

[-e|-execute <number>]

[-f|-fillup <log_name1>[,<log_name2>,..]|<yyyy-mm-dd hh.mi.ss>|

<no. of days>|last]

[-h|-help [version]]

[-k|-compress no|yes|hardware]

[-l|-language E|D]

[-m|-mode all|all_data|full|incr_all|incr|incr_only|incr_full|

<tablespace>[=<rest_dest>]|<file_ID>[=<rest_dest>]|

<file_ID1>-<file_ID2>[=<rest_dest>]|<generic_path>[=<rest_dest>]|

<object list>|archive_logs|partial|non_db[==<rest_dest>]]

[-n|-number <file_pos>|init_ora|spfile|init_sap|space_log|det_log|

sum_log|init_all|all_log|control_file[=<rest_dest>]]

[-n2|-number2 <back_file>=<rest_dest>]

[-o|-output dist|time[,time|dist]]

[-p|-profile <profile>]

[-q|-query [check]]

[-r|-parfile <parameter_file>]

[-u|-user [<user>[/<password>]]]

[-w|-verify [use_dbv|only_conf]]

[-V|-VERSION [ALL]]

Also, your problem on the other hand may relate to "immature TCP

disconnection" issue.. Did you ensure

you have the patch level maaintained..?

Cheers

Senthil