cancel
Showing results for 
Search instead for 
Did you mean: 

Database refresh using SWPM

Former Member
0 Kudos

Hi ,

Currently performing oracle database refresh using swpm , After restoring the DB successfully when I execute the swpm it gives me me error ALTER DATABASE OPEN   must use ORA-01589: must use RESETLOGS or NORESETLOGS​ .

Can able to open the database using SQL but again after executing the swpm further it's trying to create the control file again

I have attached the CONTROL.SQL file and SWPM error screenshot below, Kindly give your inputs to  fix the error .

Accepted Solutions (0)

Answers (1)

Answers (1)

Reagan
Advisor
Advisor
0 Kudos

Start the database from the SQL and open the database with the resetlogs option.

RB

Former Member
0 Kudos

Hi Reagan,

I have tried as above mentioned but again after executing the swpm it gives error.

do u mean after database open should i stop using SWPM ?

Reagan
Advisor
Advisor
0 Kudos

If you have opened the database successfully then modify the content of the CONTROL.SQL file by deleting everything and enter STARTUP;

Retry in sapinst.

RB

Former Member
0 Kudos

Hi Reagan,

After restore have you executed control.sql?

is your database in open mode?

If yes then create a empty control.sql file in SWPM location and just write STARTUP in this file

after that try to continue with SWPM.

Thanks,

Venkat