QA database won't start after Production-QA sync up

a05121c6-8166-41ea-b52d-c08865f07c96

For a test activity we asked the server team to sync up qa to production. The server has a HP Unix file system and a total of 4 databases. 3 of them started successfully but 1 failed. A similar activity was performed in 2014 which was successful. Logs for both activity are provided below. Can someone help me with this ?

Logs for 2014 when the activity was successful

Database dismounted.

ORACLE instance shut down.

SQL> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production

---

* Renaming Database from shppr2 to shpqapr2 *

---

SQL*Plus: Release 9.2.0.7.0 - Production on Fri May 23 10:13:55 2014

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> SQL> ORACLE instance started.

Total System Global Area 572485320 bytes

Fixed Size 736968 bytes

Variable Size 335544320 bytes

Database Buffers 234881024 bytes

Redo Buffers 1323008 bytes

SQL> Control file created.

SQL> Database altered.

SQL> SQL> Database closed.

Logs for 2016 when the database won't start

Database dismounted.

ORACLE instance shut down.

SQL> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production

---

* Renaming Database from shppr2 to shpqapr2 *

---

SQL*Plus: Release 9.2.0.7.0 - Production on Tue Jul 26 10:41:27 2016

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected. SQL> SQL> ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> CREATE CONTROLFILE REUSE set DATABASE "SHPQAPR2" RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01012: not logged on

SQL> alter database open resetlogs * ERROR at line 1: ORA-01012: not logged on

SQL> SQL> ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

SQL> Disconnected

fail 1 ## 10:41:29 ## ERROR... Errors found when changing the SID of the database check file ->/home/oracle/renamedb/tmp/tmp2.23976.1 logout

Pavan Kumar

Hi,

1. We don't know what is your process of sync-up

2. We have no diea about the parameters -- as from control file you are setting up new database name

3. You are DBA's of your environment -- you should dig up from you side and post the step by step what is the process (not the description of issue)

4. Does the last shutdown went fine ? can you verify shared memory segments

Connected. SQL> SQL> ORA-01081: cannot start already-running ORACLE - shut it down first

Being a DBA basic check is already running how come you perform controlfile ? have you check atleast whether its in nomount ? Basics of DBA

You need to study -- else contact your senior colleagues in your team

- Pavan Kumar N