Skip to Content
avatar image
Former Member

System Copy Error @ CreateDB using control.sql file

Hi Experts,

I am doing A Homogeneous System Copy. I have installed DB and patched 10.2.0.2 as source is of the same level.

After DB Installation, restored DB , run the control.sql file and opened it. Recovered DB using this way: "Recover Database using backup controlfile until cancel;" and opened reset logs

Once DB is open, i continued other steps from the point Backup/Restore DB in sapinst. It said CONTROL.SQL file is missing, so i have placed the same in installation directory. In this step "CREATE DATABASE with control.sql file" it has been throwing me error: Ora-00265 instance recovery required, cannot set ARCHIVE log mode DB altered. DB Closed. DB Dismounted and DB Closed.

Could you please explain why it is asking for Archive logs and shutting down the DB.

Thanks,

Subbu

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 19, 2010 at 01:28 PM

    Hi Subbu,

    After DB Installation, restored DB , run the control.sql file and opened it. Recovered DB using this way: "Recover Database using backup controlfile until cancel;" and opened reset logs

    I wonder y u have recovered and opened the database in between without letting the SAPINST to do that 😔 The actual procedure is to restore the data files and the backup logs and then create a script file control.sql in the installation directory and then allowing the SAPINST to proceed with the post processing.

    Going through the sections Restoring Database Files on the Target System and Restoring the Database Files on the Target System with BRools will give u better idea on this.

    Hope this helps and clarifies.

    Regards,

    Varadharajan M

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 19, 2010 at 05:59 PM

    Hi,

    well the copy guide says you have to do an OFFLINE backup.

    So sapinst expects a restored database (from offline backup) with non existing controlfiles

    and the need to do a CREATE CONTROLFILE ...

    You already did that manually. You already opened the db...

    So there is no way to run a CREATE CONTROLFILE with "SET database" (not sure

    about the RESETLOGS in this case for a second time...).

    I do not know what state your DB is in right now. If it is completely operational

    and fully recovered and can be opened and shutdown normal, try to substitute

    your control.sql with simply (copy the original content somewhere else)

    alter database mount;

    alter database open;

    Repeat the sapinst step.

    Depending on how far it put in the progress bars in the xml file, you might need

    only one of those two statements in control.sql.

    If the restored DB is not operational now, then the controlfiles might be garbled due to the

    second try top create them from sapinst. Not sure what the situation is then.

    Volker

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you , I have skipped the step in sapinst as I have laready opened the DB and it went fine with out errors.

      Thanks,

      Subbu