Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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-copy-erorr-in-generating-controlsql-file

    regards,

    Subhajit.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.