Skip to main content
Solved

Overwriting the Oracle database

  • February 24, 2022
  • 2 replies
  • 643 views

Hello Commvault Community,

 

I want to ask you and ask for help on overwriting the Oracle database.

 

A daily schedule is created to overwrite the Oracle databases from "abc.PROD." to "abc.TEST".

 

The process is correct, but after the operation is completed, the overwritten database often remains in the "STARTED" instead of "OPEN" mode. We can raise it to the "OPEN" state and the situation is ok. Repeating the overwrite operation is also always correct and the database is available.

 

Are we able to somehow change the configuration so that the database is always in the OPEN state, and not STARTED, after the overwriting task is completed? Tasks end with the status "Completed with errors".

 

Error Code: [19: 1336] Description: Oracle Restore [Failed to execute the create controlfile script. Please run this script [shutdown immediate; startup nomount; @ '/ opt / commvault / Base / Temp // CreateControlFileScript_1645579842.sql'; exit; ] manually again from sqlplus, open the database with resetlogs and change the id using nid.] Source: xyz, Process: ClOraAgent

 

Thanks&Regards,
Kamil

Best answer by Kamil

Hi @Gowri Shankar ,

 

Thanks for your suggestion.

 

In the logs I found information about a problem with executing scripts on the Oracle database, I suspect that there was a problem there.

Let us consider this thread completed.

 

Regards,
Kamil

View original
Did this answer your question?
If you have a question or comment, please create a topic

2 replies

Forum|alt.badge.img+13

Hi @Kamil,

 

You are using a Cross SID restore type where we create the controlfile & rename the DB name using oracle tools like NID. The above error is while recreating the control file which could fails due to various environmental issues.

Please look at the oracle Alert log to check why it failed to recreate the controlfile

 

Regards,

Gowri Shankar


  • Author
  • 143 replies
  • Answer
  • March 14, 2022

Hi @Gowri Shankar ,

 

Thanks for your suggestion.

 

In the logs I found information about a problem with executing scripts on the Oracle database, I suspect that there was a problem there.

Let us consider this thread completed.

 

Regards,
Kamil


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings