Skip to Content
avatar image
Former Member

Difference between various BRARCHIVE functions

Hello Everyone,

I was using BRARCHIVE for backing up ofline redo log files. While performing brarchive i came across the selection option amongst various BRARCHIVE functions:

<b>save|save_delete|second_copy|second_c

opy_delete|double_save|double_save_delete|copy_save|copy_delete_save|delete_saved|delete_copied</b>

I was performing BRARCHIVE over disk. Iam confused between the difference in all these values and their meanings,i searched through various pdf docs and help site also but could not get the difference and clear meaning of all these. If someone could clarify the difference between these various options along with their meanings ,it shall be very helpful.

Useful answers shall be surely awarded points. Requested to revert at earliest.

Regards,

Somya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 03, 2007 at 10:52 AM

    1. second_copy is same as copy only or it means saving an archive to three different locations ,first save ,then copy ,then second copy?

    second copy mean save only the archives that are already saved with save or copy option to one location that you have defined in initSID.sap.

    it checks the file archSID.log and if a file is already saved it will save it again.

    2. Ahmed: In ur second point second_copy_delete wont save , then copy ,then delete the new 10 archives ? or it just wont do nything?

    it wont do anything.

    3. Last suppose iam performing complete online backup( full ) of datbase through BRBACKUP through BRtools ,after tat iam just performing the backup of offline redologs through BRARCHIVE formed after tat backup and iam not backing up the previosly formed Offline redologs before backup which are many in number.......................wll it be sufficient enough for complete restoration / do i need to take backup of previously formed offline redologs also?

    it is sufficient for restore as you backup contains all the changes before. what you can is to do that consistent online backup online_cons in initSID.sap to backup online the db and archives after. after that just backup the archives.

    4. How does taking up FULL database OFFLINE (BRBACKUP) + redologs (BRARCHIVE) and FULL database ONLINE (BRBACKUP) + redologs (BRARCHIVE) differ frm each other in terms of restoration like i mean how wld the restoration differ in both the scenarios.

    it is the same process...you will do compelete recovery with offlineredos or onlineredos...you will restore the database and after that you will do a recovery with offline redologs

    thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ahmed assigned you full 10 points, but just aquery in mind:

      Wts the difference between online_const backup and online backup. how do both of them differ in recovery scenarios ?and how the backup procedures differ in both the cases as in full online backup also iam taking full backup na........................after tat taking backup of formed archives through brarchive?????????????????????????????revert please.

      Also if could revert on my another forum

      <b>Facing Errors in BRBACKUP through BRTOOLS and DB13

      plz revert on tat also as iam struggling with taking backup through db13 still.

      Reagrds,

      Somya

  • avatar image
    Former Member
    Aug 03, 2007 at 01:09 PM

    Hi,

    which option of brarchive did you use?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2007 at 11:32 AM

    Hi,

    Not sure what information you are looking for that is not already on the documentation but I'll give a shot.

    <b>save</b> -> copy (save) the offline redo logs to the destination indicated by the parameter device

    <b>save_delete</b> -> Same as before plud delte the files that have been copied (saved)

    <b>second_copy</b> -> create a second copy of files that have been already copied ( with the first option )

    <b>second_copy_delete</b> -> Same as previous one plus deleting the files.

    <b>double_save</b> -> it saves <i><u>two</u></i> copies of the redo logs. You must indicate two destinations.

    <b>double_save_delete</b> -> Same as previous one plus deleting the files.

    Perhaps here are the "issues" understanding:

    <b>copy_save</b> -> <i>Create a second copy of offline redo log files that have already been archived and then archive the newly created offline redo log files</i>

    first time a redo log is "archived" to a new location, it is called "save", the second time is called "copy". This option allows you to perfrom two copies in two different BRARCHIVE runs.

    For example, you have 5 archived redo logs.

    The first time you run this command it "saves" this 5 redo logs on tape. ( no deletion ). Next run you have 10 archived redo logs ( 5 from before and 5 news )

    BRARCHIVE will "copy" the 5 archive redo logs that were already copied and will "save" the 5 new redo logs.

    Apparently there is no difference, but this now a 3rd run. You have 15 redo logs

    5 copied and saved

    5 saved

    5 new.

    This run will "copy" the 5 redo logs that were "saved" and "save" the 5 new redo logs. Nothing is done with the first 5.

    This make more sense with the next option:

    <b>copy_delete_save</b> -> same as before, but it will delete the archive redo logs <u>AFTER</u> they are saved.

    1st -> 5 redo logs are "saved"

    2nd -> 5 redo logs already "saved" are "copied" and then <u>deleted</u>

    the 5 new redo logs are "saved"

    3rd -> 5 redo logs already "saved" are "copied" and then <u>deleted</u>

    the 5 new redo logs are "saved"

    <b>delete_saved</b> -> Deletes from disk all offline redo logs that have already been "saved" by BRARCHIVE.

    <b>delete_copied</b> -> Deletes from disk all offline redo logs that have already been "copied" by BRARCHIVE.

    Remember, copy mean that two copies have been done.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2007 at 11:48 AM

    Hi,

    save|save_delete|second_copy|second_c

    opy_delete|double_save|double_save_delete|copy_save|copy_delete_save|delete_saved|delete_copied

    all this options use archSID.log

    · -s|-save

    Archive the offline redo log files.

    · -sc|-second_copy

    Create a second copy of the offline redo log files which were already archived. check archSID.log for already archived logs and save them again.

    · -ds|-delete_saved

    Delete offline redo log files that have been archived once. delete saved archives based on archSID.log

    · -dc|-delete_copied

    Delete offline redo log files that have been copied twice. check archSID.log if archives are saved twice with save followed by second_copy and delete them

    · -sd|-save_delete

    Archive offline redo log files and then delete these files.

    · -scd|-second_copy_delete

    Create a second copy of the offline redo log files that have already been archived and then delete these files.

    · -ss|-double_save

    Archive the offline redo logs to two backup devices (tape devices) in parallel.

    · -ssd|-double_save_delete

    Archive the offline redo logs to two backup devices (tape devices) in parallel and then delete the files.

    · -cs|-copy_save

    Create a second copy of offline redo log files that have already been archived and then archive the newly created offline redo log files.

    · -cds|-copy_delete_save

    Create a second copy of offline redo log files which were already archived. These are then deleted and archiving of the newly created offline redo log files is begun.

    in general the good idea depending on your need is to make to copy of archive logs

    so you save with save option and then resave them with second_c

    opy_delete

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Ahmed and Fidel,

      Thanks fore ur replies. It was quite informative but so many options tat it was vwery much confusing also.

      Few Questions:

      1. Here deletion means deleting the redo logs from their original location only na that is the ORAARCH directory?

      2. delete_saved ,delete_copied and save_delete , second_copy_delete options sound the same as their previous ones then wts thed ifference between them.

      3. If we r saving the Offline redologs twice ( the first and the second one),where r they saved and where do we define tat location?

      4. Wt r the recommended options tat we shld use and wt we shld use?

      Thanks,

      Saumya

  • avatar image
    Former Member
    Aug 01, 2007 at 12:39 PM

    1. Here deletion means deleting the redo logs from their original location only na that is the ORAARCH directory?

    Yes it deletes them after save

    2. delete_saved ,delete_copied and save_delete , second_copy_delete options sound the same as their previous ones then wts thed ifference between them.

    delete_saved, delete_copied - this will not save anything just delete them. the idea customers need to delete archives after some times

    save_delete : save and delete immediately

    second_copy_delete: check archives in archSID.log, save them again if they are

    saved and delete them but the new ones are not saved.

    3. If we r saving the Offline redologs twice ( the first and the second one),where r they saved and where do we define tat location?

    depend on backup_dev_type in initSID.sap

    backup_dev_type = tape --->>> available tapes

    backup_dev_type = disk --->>> archive_copy_dir parameter in initSID.sap

    4. Wt r the recommended options tat we shld use and wt we shld use?

    the good strategy is to save the redologs with SAVE option and then Resave them with second_copy_delete. you can define to initSID.sap and change archive_copy_dir to backup on it

    initSID.sap.Dir1 ---> archive_copy_dir = Dir1

    brarchive -p initSID.sap.Dir1 -s s

    initSID.sap.Dir2 ---> archive_copy_dir = Dir2

    brarchive -p initSID.sap.Dir1 -s cpd

    with script you can start both of them instead of DB13

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      Lets try.

      first the concepts

      1) save -> it backups the redo logs to a different location

      2) copy -> it backups the redo logs to a different location

      clear? both options will "copy/save/transfer" the redo log to a different location.

      What is the difference between both if "both seem to do the same"?

      Easy, as I indicated in my first reply:

      <quote>

      <u><i>Remember, copy mean that two copies have been done.</i></u> </quote>

      if you have a "new" offline redo log, the first time it is "<b>save</b>" and the second it is "<b>copy</b>".

      Now to the questions:

      1.<b>delete_saved, delete_copied</b>

      the options will delete the redo logs that have been <i>saved</i> ( copied only one time ) or <i>copied</i> ( copied two times ) previously.

      Remember that you have the options <b>save</b>, <b>second_copy</b>, <b>double_save</b> and <b>copy_save</b>. None of this options delete the redo log from disk. As the disk drives have a limited size, you will reach a point whne you want to delete some of those files that are already backed up.

      2. <b>second_copy_delete.</b> Again the same as before.

      <quote>

      <u><i>Remember, copy mean that two copies have been done.</i></u></quote>

      with this parameter you are asking to make a <b>second copy</b> of the redo logs ( ONLY A SECOND COPY )

      The new ones do not have any copy, then you <i>cannot</i> do a second copy of them.

      3. You indicate the destinations on the same parameter. I think that they are separated by comma.

      <quote>

      4. Wt r the recommended options tat we shld use and wt we shld use?

      <quote>

      This is a FORUM, not a telephone. Please, can you write the question in plain English, with all the missing letters?

      thanks. People here is trying to help, I'm asking for a little respect.

  • avatar image
    Former Member
    Aug 02, 2007 at 01:15 PM

    Hello Ahmed,

    1. In delete_saved, delete_copied - i didnt get wt u meant by this will not save anything just delete them. the idea customers need to delete archives after some times . if its only deleting not saving y save/copy word is used?Then after u r writing customers hv to delete themselves ?

    Lets give an example:

    You have 25 archives. 10 saved, 5 copied (saved twice), 10 new archives

    delete_saved will delete 10

    delete_copied will delete 5

    Imagine you work with customer who wants archives to be saved twice and retained in disk and delete them after the next backup. you can save them twicce during the day and after your backup you schedule brarchive to delete them delete_copied...if he need just one copy the same apply with delete_saved.

    2. second_copy_delete:i didnt get wt u meant by but the new ones are not saved , y r not they saved?

    second_copy_delete save archives that are saved twice and delete them but no processing for the new created archive logs

    Lets give an example:

    You have 25 archives. 10 saved, 5 copied (saved twice), 10 new archives

    this will save 10 again delete them, delete 5 copied already

    nothing will happen for 10 new archives

    3. In initSMD.sap only one destination location can be defined at a time in archive_copy_dir ,how to define two at a time for copying? plz clarify?

    You will create two initSMD.sap and change archive_copy_dir.

    initSMD.sap.save with archive_copy_dir = DIR1 and archive_function = save

    initSMM.sap.second_copy_delete with archive_copy_dir = DIR2 and archive_function = second_copy_delete

    start brarchive -p initSMD.sap.save this will save archives in DIR1

    start brachive -p initSMM.sap.second_copy_delete this will make a second copy of archives in DIR2 and delete them.

    Hope all is clear

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      have a look on Fidel's reply read it carefully. It explains like anything.

      second_copy : Create a second copy of offline redo log files which were already archived.

      If A is copied and you can do second copy for A. If B is not copied you cant do second copy for B.The new ones do not have any copy, then you cannot do a second copy of them

      second_copy_delete : Create a second copy of offline redo log files which were already archived and then delete these files.

      If A is copied it will do second copy of A and Delete A.

      I cant unstd what you are asking . If you have offline backup on sunday and on line backup on mon tue wed thu fri and sat. It is recmnd to have archives generated after offline backup ie after sunday.Means once u have full offline backup on latest sunday then you can delete all the archives for last week.If your offline backup is Good.

      Two types of backup Offline and Online

      When all the services are down its called Offline backup

      When all the services are up its caleld Online backup.

      Try to unstd Diff between redologs and Archives or Offline redologs. And read help.sap.com you need to unstd conecpts. Spoon feeding is out of scope.

      Vinod

  • avatar image
    Former Member
    Aug 03, 2007 at 11:55 AM

    Wts the difference between online_const backup and online backup. how do both of them differ in recovery scenarios ?and how the backup procedures differ in both the cases as in full online backup also iam taking full backup na........................after tat taking backup of formed archives through brarchive?????????????????????????????

    online_cons = its an onlibe backup followed by brarchive run which will backup archives logs... we can say it is ONLINE BACKUP + ARCHIVE LOGS BACKUP. it is the same for recovery.

    online -- backup_type = online

    online_cons --- backup_type = online_cons..brbackup will start the backup and once finished it will start brarchive to backup offline redologs.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Additionall in my 3rd point i meant for complete restoration and recovery scenario inorder to bring the datatbase to its consistent state.

      Thanks,

      Somya

  • avatar image
    Former Member
    Aug 03, 2007 at 12:19 PM

    1. Tat means Full online_cons backup through BRBACKUP is Full online backup through BRBACKUP + archive logs backup needed for online backup/generated during backup through BRARCHIVE.

    Yes..generated during and before. this will backup the DB and archive logs in one brbackup run.

    2. Tat means when iam taking Full online_cons backup through BRBACKUP i do not need to take Full online backup through BRBACKUP separately and archive logs backup needed for online backup/generated during backup through BRARCHIVE separately .

    Yes

    3. Suppose iam taking cons_online backup today ,this wll take up backup of complete database along with archives during backup . Now suppose i wanna restore this backup 2 days later then ill need cons_online backup of today + backup of the archives formed later afterbacking up archives through cons_online backup ie; the archives tat were not backed up in the previous backup also na or just tat cons_online full backup of today wll do?

    Yes...you will restore backup and archive logs generated after this backup to complete the recovery.

    Add comment
    10|10000 characters needed characters exceeded