Skip to Content
author's profile photo Former Member
Former Member

Client Copy: recover using backup controlfile

Hi.

We recently upgraded from Oracle 9.1 32 bit to Oracle 10.2 64 bit. I had a process for doing a quick and simple client copy from one box to another. This was a process that was given to us by one of the SAP tech we had on site when upgrade to R/3 Enterprise x200 (we are currently rinning that on 64 bit Win2K3 x64 platform).

The basic process was to backup the datafiles, oralog (and mirrorlogs) and the SAPARCH folder. Wethen restore the information to the target system. We create the control files by backing up the souorce controlfiles (alter database backup...) and we then take and edit the file to match the system ID of the target system.

This has worked great for the last 5 years, but when I try to follow the same basic process I get a error that eventually leads to a message that I need to use recover database using backup controlfile. When I tr running that command it suggest using a log file that does not exist. If I try to use and existing arcive file I get the message that it belongs to the wrong database. I have tried numorous suggestions and everything I can think of. Somewhere in the process some thing changed in Oracle and I can't put my finger on it except for the fact that I how have an ORAARCH folder. When I look bat a documentation and such for the previous system the only difference I see is the old system does not have the ORAARCH folder and the log files and archive files are held in the SAPARCH folder.

I'm looking for any insite that some minght have on how to recover the database so I can finish the rest of the client copy process, creating the neccessary users, granting authorizations and cleaning up various items one the target system once it is up and running.

Gale S.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    Posted on Jan 30, 2010 at 07:06 AM

    [Note 549828 - Database copy with Online backup|https://service.sap.com/sap/support/notes/549828]

    [Note 4157 - General flowchart for ORACLE recovery|https://service.sap.com/sap/support/notes/4157]

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2010 at 09:38 PM

    > ...but when I try to follow the same basic process I get a error that eventually leads to a message that I need to use recover database using backup controlfile. When I tr running that command it suggest using a log file that does not exist.

    Well -if you'd have given the exact command and a context it would maybe be possible that someone could give a suggestion. Usually I'd post logfiles or console session text (leaving out the unimportant parts). With just such a vague "description" it's only possible to vaguely guess what happened.

    > I'm looking for any insite that some minght have on how to recover the database so I can finish the rest of the client copy process, creating the neccessary users, granting authorizations and cleaning up various items one the target system once it is up and running.

    I suggest your just read the systemcopy guides, the procedure is completely described there:

    http://service.sap.com/instguides

    or use this [direct link|https://service.sap.com/~sapidb/011000358700000416392008E.PDF] and read chapter 5.1.

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 01, 2010 at 10:33 AM

    Hi Gale,

    So far I know control file of DB should not edit. Take a fresh control file backup afeter restor that control file to the specific location and then try to recover.

    Regards

    Wahid

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2010 at 11:06 PM

    It is obvious from some of the posts that I was not clear on the processes I use, I apologize for that.

    In a nutshell here is what my old Oracle 9i client copy did:

    1. command "alter databse backup controlfile to trace:" run on source server

    2. copy/backup source data and logs, in this case from my PRD system

    3 take file created in step 1 and modify. changes are made to the CREAT CONTROLFILE statement; Change SIDs, change REUSE to SET change NORESETLOGS to RESETLOGS, and change ARCHIVELOG to NOARCHIVELOG. Delete everything before the first STARTUP NOMOUNT through to the ";", delete everything after.

    4 copy/restore to target making sure to restore or rename folders to correct SID for target.

    5 run script file created in step 3

    6 command "alter database open resetlogs;"

    It is at this point I get a recovery message (system file needs recovery)

    When I try to recover the system file I get the message to use "recover database using backup controlfile" required.

    I run that command and I get a message saying that a file cannot be opened. It give me the filename and a prompt telling to accept the suggested, enter another filename, AUTO or CANCEL.

    If I accept any option other than cancel I wind up with the message the file can't be opened because it can't be found.

    When used with Oracle 9i, the rest of the client copy process consists of createing system useers, granting rights, cleaning out various tables, check transport system and other client copy related items.

    I am reveiwing all suggested notes and documents so far suggested. Because this process has worked so well in the past I have not bothered to look for any newer copies of the client copy process. So it was good to get a more current copy for the proccess.

    I do realize that my old process may not be applicable due to the fact that I am now on Oracle 102g, but before I scrap this process (which is a very easy process to use without requiring the exporting or imorting the data) I want to find oout if it will work with the new Oracle.

    One last note: I have not used forums that much in the past so I am up against a slight "adjustment" curve here. Again I apologize for my first post, and for the extended size of this one.

    Thank you in advance for your help and understandingt

    Gale S.

    Edited by: Gale Shenefelt on Feb 2, 2010 12:07 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2010 at 06:30 AM
    1. command "alter databse backup controlfile to trace:" run on source server
    2. copy/backup source data and logs, in this case from my PRD system
    3 take file created in step 1 and modify. changes are made to the CREAT CONTROLFILE statement; Change SIDs, change REUSE to SET change NORESETLOGS to RESETLOGS, and change ARCHIVELOG to NOARCHIVELOG. Delete everything before the first STARTUP NOMOUNT through to the ";", delete everything after.
    4 copy/restore to target making sure to restore or rename folders to correct SID for target.
    5 run script file created in step 3
    6 command "alter database open resetlogs;"

    Exactly correct till this step

    It is at this point I get a recovery message (system file needs recovery)

    Means you are restoring Online backup

    When I try to recover the system file I get the message to use "recover database using backup controlfile" required.

    yes, ssytem will ask you, because you made a new controlfile(backed up)

    I run that command and I get a message saying that a file cannot be opened. It give me the filename and a prompt telling to accept the suggested, enter another filename, AUTO or CANCEL.

    check where it is asking Archivelogs and compare with your source system(may be sorce and target's archive path is different)

    Or

    Place all archivelogs in path(where system is checking for) and rename all the archivelogs according to new SID

    And select Auto....system will recovers the database....after applying all archivelogs just use below query to open your database

    sql>alter database open resetlogs;

    If I accept any option other than cancel I wind up with the message the file can't be opened because it can't be fo
    und.

    If you restored all the archive logs and renamed according to target SID, ssystem will not show this

    Regards,

    Nick Loy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2010 at 06:15 PM

    Thanks everyone for your input, it has been helpful but has not gotten me any closer to my client copy.

    I'm going to take a shift in direction here: rather than try and get direct answers to the errors being generated I just want to find a client copy method.

    I have R/3 Enterprise 4.70 x200 with SAPBasis 6.40 64 bit kernel. It is running on a x64 Windows Server 2003 and is running with Oracle 10.2.0.4 (x64).

    I had a set of instructions (developed for us by a SAP tech who helped install the current version) for doing a client copy with an Oracle 9.1.0.x system (I can post this if someone want to see it). This method was direct and simple, similar to the technique outlined in the System Copy for NetWeaver 7 guide.

    I have downloaded the System Copy guide specified in a previous post, but it is for NetWeave 7. It looked like it might be helpful but there are some obvious differences in the NetWeaver 7 that I don't have in my R/3 Enterprise system.

    I have also looked at the different SAP notes suggested, helpful but still falling short.

    The bottom line is this. I am looking for a client copy method that is useable with my current installation. I have one method that uses import/export but I would have to go in and re-sintall and update my TaxFactory every time I did a client copy.

    Again, thanks;

    Gale S.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      I have used the same technique for doing Homogeneous system copies as for NW 7.0 for Oracle Specific tool, using orabrcopy tool and the backup/restore mode with success. Just a few minutes ago I remembered I have the 6.40 sr1 homogeneous system copy guide and took a look at it and donĀ“t find any difference doing the Homogeneous system copy (ABAP of course) just be sure to use the 6.40 SR1 or latter master DVD and the lattest sapinst program you find and you will get everything working in a short time.

      This is not difficult at all and if the restore time is short then the whole process is not long.

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.