Skip to Content
avatar image
Former Member

Generate the control files on production as per OraBRCopy Java tool

Dear All,

I want to make a copy of production database to our test system.

For this purpose i am using a one month old Offline backup.

Now I want to generate the control files on production as per OraBRCopy Java tool

as per doc it is mention before running the OraBRCopy tool I have to Make sure that all redo log groups are archived by this what they mean how to do this and the command

Only valid for: Windows

n Log on as <sapsid>adm.

n Enter the following commands:

ora_br_copy.bat u2013generateFiles u2013forceLogSwitches u2014targetSid <TARGET_DBSID>

u2014password <systemu2019s password> u2014listenerPort <listener port>

Is there any caution I have to take before running this to prd server.

generate the control file which will consist of data till today ( number of data files may be differ from actual restored and mentioned in script ), however i want the control files which generate control files till my offline backup (ie 1 month old).

Please suggest how to do and step by step process for using OraBRCopy tool for system

Regards,

Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 09, 2009 at 07:29 AM

    Hi,

    You can use exisiting offline backup but you have to clean redo logs with forced log switches.

    For more information, please check below lnik:

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6945da7d-0c01-0010-1792-dd7b5d87235c?overridelayout=true

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2009 at 10:52 AM

    Hi,

    I want to add upon the following to resolve the following OraBRCopy error which you were receiving at the beginning of the post.

    Incorrect application options:
    At least one from 'generateFiles' or 'forceLogSwitches' options is required

    .

    Please go through the following link which suggests how to resolve the above error generated during the generation of control.sql in the source system using ora_br_copy.bat.

    system-copyerorr-in-generating-controlsql-file

    regards,

    Subhajit.

    Add comment
    10|10000 characters needed characters exceeded