Home » RDBMS Server » Backup & Recovery » ORA-01161: database name CCSPS in file header does not match given name of CCSP (SunOS cbgs0201 5.9 Generic_122300-56 sun4u sparc SUNW,Netra-T12)
ORA-01161: database name CCSPS in file header does not match given name of CCSP [message #532866] Fri, 25 November 2011 04:10 Go to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Hi,
While creating a controlfile while bringing the database up we are consistently getting the below error

ORA-01161: database name CCSPS in file header does not match given name of CCSP
ORA-01110: data file 312: '/aoq53/appl/oracle/ccsps/dtmcs01_07.dbf'

The controlfile creation script is as follows.


CREATE CONTROLFILE  SET DATABASE "CCSPS" RESETLOGS  NOARCHIVELOG
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 255
    MAXLOGMEMBERS 2
    MAXDATAFILES 1022
    MAXINSTANCES 8
    MAXLOGHISTORY 904
LOGFILE
  GROUP 1 (
    '/aoq7/appl/oracle/ccsps/redo_1a.log',
    '/aoq8/appl/oracle/ccsps/redo_1b.log'
  ) SIZE 2000M,
  GROUP 2 (
    '/aoq7/appl/oracle/ccsps/redo_2a.log',
    '/aoq8/appl/oracle/ccsps/redo_2b.log'
  ) SIZE 2000M,
  GROUP 3 (
    '/aoq7/appl/oracle/ccsps/redo_3a.log',
    '/aoq8/appl/oracle/ccsps/redo_3b.log'
  ) SIZE 2000M,
  GROUP 4 (
    '/aoq7/appl/oracle/ccsps/redo_4a.log',
    '/aoq8/appl/oracle/ccsps/redo_4b.log'
  ) SIZE 2000M,
  GROUP 5 (
    '/aoq7/appl/oracle/ccsps/redo_5a.log',
    '/aoq8/appl/oracle/ccsps/redo_5b.log'
  ) SIZE 2000M
-- STANDBY LOGFILE
DATAFILE
'/aoq7/appl/oracle/ccsps/dttools_01.dbf',
'/aoq7/appl/oracle/ccsps/srs01_dat_03.dbf',
'/aoq7/appl/oracle/ccsps/dtuser_01.dbf',
'/aoq7/appl/oracle/ccsps/incdw01_01.dbf',
'/aoq33/appl/oracle/ccsps/incdw01_02.dbf',
'/aoq7/appl/oracle/ccsps/statspack_01.dbf',
'/aoq7/appl/oracle/ccsps/system01.dbf',
'/aoq7/appl/oracle/ccsps/undotbs01.dbf',
'/aoq7/appl/oracle/ccsps/xdb_01.dbf',
'/aoq8/appl/oracle/ccsps/dtcdw01_01.dbf',
'/aoq8/appl/oracle/ccsps/dtmcs01_01.dbf',
'/aoq8/appl/oracle/ccsps/dtmcs01_02.dbf',
'/aoq10/appl/oracle/ccsps/dtmcs01_03.dbf',
'/aoq54/appl/oracle/ccsps/dtmcs01_06.dbf',
'/aoq53/appl/oracle/ccsps/dtmcs01_07.dbf',
'/aoq9/appl/oracle/ccsps/dtcc01s_01.dbf',
'/aoq9/appl/oracle/ccsps/dtcc01s_02.dbf',
'/aoq9/appl/oracle/ccsps/dtcc01xs_01.dbf',
'/aoq34/appl/oracle/ccsps/dtcc01xs_02.dbf',
'/aoq9/appl/oracle/ccsps/inmcs01_01.dbf',
'/aoq10/appl/oracle/ccsps/incc01s_01.dbf',
'/aoq10/appl/oracle/ccsps/incc01s_02.dbf',
'/aoq11/appl/oracle/ccsps/incc01s_03.dbf',
'/aoq10/appl/oracle/ccsps/incc01xs_01.dbf',
'/aoq10/appl/oracle/ccsps/inmcs01_02.dbf',
'/aoq51/appl/oracle/ccsps/inmcs01_03.dbf',
'/aoq49/appl/oracle/ccsps/inmcs01_04.dbf',
'/aoq11/appl/oracle/ccsps/dtcc01m_01.dbf',
'/aoq11/appl/oracle/ccsps/dtcc01m_02.dbf',
'/aoq11/appl/oracle/ccsps/dtcc01m_03.dbf',
'/aoq44/appl/oracle/ccsps/dtcc01m_04.dbf',
'/aoq13/appl/oracle/ccsps/incc01m_01.dbf',
'/aoq13/appl/oracle/ccsps/incc01m_02.dbf',
'/aoq13/appl/oracle/ccsps/incc01m_03.dbf',
'/aoq34/appl/oracle/ccsps/incc01m_04.dbf',
'/aoq26/appl/oracle/ccsps/incc01m_05.dbf',
'/aoq17/appl/oracle/ccsps/incc01l_01.dbf',
'/aoq17/appl/oracle/ccsps/srs01_idx_03.dbf',
'/aoq18/appl/oracle/ccsps/incc01l_02.dbf',
'/aoq18/appl/oracle/ccsps/incc01l_03.dbf',
'/aoq18/appl/oracle/ccsps/incc01l_04.dbf',
'/aoq14/appl/oracle/ccsps/incc01l_05.dbf',
'/aoq14/appl/oracle/ccsps/incc01l_06.dbf',
'/aoq17/appl/oracle/ccsps/incc01l_07.dbf',
'/aoq10/appl/oracle/ccsps/incc01l_08.dbf',
'/aoq38/appl/oracle/ccsps/incc01l_09.dbf',
'/aoq38/appl/oracle/ccsps/incc01l_10.dbf',
'/aoq38/appl/oracle/ccsps/incc01l_11.dbf',
'/aoq37/appl/oracle/ccsps/incc01l_12.dbf',
'/aoq39/appl/oracle/ccsps/incc01l_13.dbf',
'/aoq39/appl/oracle/ccsps/incc01l_14.dbf',
'/aoq40/appl/oracle/ccsps/incc01l_15.dbf',
'/aoq15/appl/oracle/ccsps/dtcc01l_01.dbf',
'/aoq15/appl/oracle/ccsps/dtcc01l_02.dbf',
'/aoq15/appl/oracle/ccsps/dtcc01l_03.dbf',
'/aoq16/appl/oracle/ccsps/dtcc01l_04.dbf',
'/aoq16/appl/oracle/ccsps/dtcc01l_05.dbf',
'/aoq16/appl/oracle/ccsps/dtcc01l_06.dbf',
'/aoq75/appl/oracle/ccsps/dtcc01l_07.dbf',
'/aoq84/appl/oracle/ccsps/dtcc01l_08.dbf',
'/aoq19/appl/oracle/ccsps/dtcc01xl_01.dbf',
'/aoq19/appl/oracle/ccsps/dtcc01xl_02.dbf',
'/aoq19/appl/oracle/ccsps/dtcc01xl_03.dbf',
'/aoq20/appl/oracle/ccsps/dtcc01xl_04.dbf',
'/aoq20/appl/oracle/ccsps/dtcc01xl_05.dbf',
'/aoq20/appl/oracle/ccsps/dtcc01xl_06.dbf',
'/aoq21/appl/oracle/ccsps/dtcc01xl_07.dbf',
'/aoq21/appl/oracle/ccsps/dtcc01xl_08.dbf',
'/aoq21/appl/oracle/ccsps/dtcc01xl_09.dbf',
'/aoq22/appl/oracle/ccsps/dtcc01xl_10.dbf',
'/aoq22/appl/oracle/ccsps/dtcc01xl_11.dbf',
'/aoq22/appl/oracle/ccsps/dtcc01xl_12.dbf',
'/aoq23/appl/oracle/ccsps/dtcc01xl_13.dbf',
'/aoq23/appl/oracle/ccsps/dtcc01xl_14.dbf',
'/aoq23/appl/oracle/ccsps/dtcc01xl_15.dbf',
'/aoq24/appl/oracle/ccsps/dtcc01xl_16.dbf',
'/aoq24/appl/oracle/ccsps/dtcc01xl_17.dbf',
'/aoq24/appl/oracle/ccsps/dtcc01xl_18.dbf',
'/aoq25/appl/oracle/ccsps/dtcc01xl_19.dbf',
'/aoq36/appl/oracle/ccsps/dtcc01xl_20.dbf',
'/aoq36/appl/oracle/ccsps/dtcc01xl_21.dbf',
'/aoq36/appl/oracle/ccsps/dtcc01xl_22.dbf',
'/aoq28/appl/oracle/ccsps/srs01_idx_01.dbf',
'/aoq56/appl/oracle/ccsps/SYMANTEC_I3_ORCL.dbf',
'/aoq7/appl/oracle/ccsps/dtlobdat_01.dbf',
'/aoq11/appl/oracle/ccsps/dtlobdat_02.dbf',
'/aoq11/appl/oracle/ccsps/srs01_idx_02.dbf',
'/aoq14/appl/oracle/ccsps/dtlobdat_03.dbf',
'/aoq16/appl/oracle/ccsps/dtlob2dat_01.dbf',
'/aoq14/appl/oracle/ccsps/dtlob2dat_02.dbf',
'/aoq30/appl/oracle/ccsps/dtlob2dat_03.dbf',
'/aoq30/appl/oracle/ccsps/dtlob2dat_04.dbf',
'/aoq30/appl/oracle/ccsps/dtlob2dat_05.dbf',
'/aoq30/appl/oracle/ccsps/dtlob2dat_06.dbf',
'/aoq31/appl/oracle/ccsps/dtlob2dat_07.dbf',
'/aoq31/appl/oracle/ccsps/dtlob2dat_08.dbf',
'/aoq32/appl/oracle/ccsps/dtlob2dat_09.dbf',
'/aoq32/appl/oracle/ccsps/dtlob2dat_10.dbf',
'/aoq33/appl/oracle/ccsps/dtlob2dat_11.dbf',
'/aoq33/appl/oracle/ccsps/dtlob2dat_12.dbf',
'/aoq34/appl/oracle/ccsps/dtlob2dat_13.dbf',
'/aoq48/appl/oracle/ccsps/dtlob2dat_14.dbf',
'/aoq48/appl/oracle/ccsps/dtlob2dat_15.dbf',
'/aoq42/appl/oracle/ccsps/dtlob2dat_16.dbf',
'/aoq44/appl/oracle/ccsps/dtlob2dat_17.dbf',
'/aoq44/appl/oracle/ccsps/dtlob2dat_18.dbf',
'/aoq57/appl/oracle/ccsps/dtlob2dat_19.dbf',
'/aoq57/appl/oracle/ccsps/dtlob2dat_20.dbf',
'/aoq57/appl/oracle/ccsps/dtlob2dat_21.dbf',
'/aoq59/appl/oracle/ccsps/dtlob2dat_22.dbf',
'/aoq61/appl/oracle/ccsps/dtlob2dat_23.dbf',
'/aoq61/appl/oracle/ccsps/dtlob2dat_24.dbf',
'/aoq61/appl/oracle/ccsps/dtlob2dat_25.dbf',
'/aoq64/appl/oracle/ccsps/dtlob2dat_26.dbf',
'/aoq64/appl/oracle/ccsps/dtlob2dat_27.dbf',
'/aoq64/appl/oracle/ccsps/dtlob2dat_28.dbf',
'/aoq64/appl/oracle/ccsps/dtlob2dat_29.dbf',
'/aoq49/appl/oracle/ccsps/dtlob3dat_01.dbf',
'/aoq49/appl/oracle/ccsps/dtlob3dat_02.dbf',
'/aoq49/appl/oracle/ccsps/dtlob3dat_03.dbf',
'/aoq50/appl/oracle/ccsps/dtlob3dat_04.dbf',
'/aoq50/appl/oracle/ccsps/dtlob3dat_05.dbf',
'/aoq50/appl/oracle/ccsps/dtlob3dat_06.dbf',
'/aoq51/appl/oracle/ccsps/dtlob3dat_07.dbf',
'/aoq51/appl/oracle/ccsps/dtlob3dat_08.dbf',
'/aoq51/appl/oracle/ccsps/dtlob3dat_09.dbf',
'/aoq63/appl/oracle/ccsps/dtlob3dat_10.dbf',
'/aoq63/appl/oracle/ccsps/dtlob3dat_11.dbf',
'/aoq63/appl/oracle/ccsps/dtlob3dat_12.dbf',
'/aoq63/appl/oracle/ccsps/dtlob3dat_13.dbf',
'/aoq76/appl/oracle/ccsps/dtlob3dat_14.dbf',
'/aoq74/appl/oracle/ccsps/dtlob3dat_15.dbf',
'/aoq83/appl/oracle/ccsps/dtlob3dat_16.dbf',
'/aoq82/appl/oracle/ccsps/dtlob3dat_17.dbf',
'/aoq51/appl/oracle/ccsps/srs01_dat_01.dbf',
'/aoq9/appl/oracle/ccsps/dtcdw01_02.dbf',
'/aoq31/appl/oracle/ccsps/dtcdw01_03.dbf',
'/aoq31/appl/oracle/ccsps/dtcdw01_04.dbf',
'/aoq34/appl/oracle/ccsps/dtcc07s_01.dbf',
'/aoq76/appl/oracle/ccsps/dtcc07s_02.dbf',
'/aoq35/appl/oracle/ccsps/incc07s_01.dbf',
'/aoq19/appl/oracle/ccsps/undotbs02.dbf',
'/aoq19/appl/oracle/ccsps/undotbs03.dbf',
'/aoq32/appl/oracle/ccsps/undotbs04.dbf',
'/aoq32/appl/oracle/ccsps/undotbs05.dbf',
'/aoq42/appl/oracle/ccsps/undotbs06.dbf',
'/aoq43/appl/oracle/ccsps/undotbs07.dbf',
'/aoq42/appl/oracle/ccsps/undotbs08.dbf',
'/aoq43/appl/oracle/ccsps/undotbs09.dbf',
'/aoq43/appl/oracle/ccsps/undotbs10.dbf',
'/aoq54/appl/oracle/ccsps/undotbs11.dbf',
'/aoq54/appl/oracle/ccsps/undotbs12.dbf',
'/aoq54/appl/oracle/ccsps/undotbs13.dbf',
'/aoq55/appl/oracle/ccsps/undotbs14.dbf',
'/aoq55/appl/oracle/ccsps/undotbs15.dbf',
'/aoq55/appl/oracle/ccsps/undotbs16.dbf',
'/aoq56/appl/oracle/ccsps/undotbs17.dbf',
'/aoq54/appl/oracle/ccsps/srs01_dat_02.dbf',
'/aoq33/appl/oracle/ccsps/cc01mandat_01.dbf',
'/aoq65/appl/oracle/ccsps/cc01mandat_02.dbf',
'/aoq20/appl/oracle/ccsps/dtcdw01_05.dbf',
'/aoq37/appl/oracle/ccsps/dtcdw01_06.dbf',
'/aoq37/appl/oracle/ccsps/dtcdw01_07.dbf',
'/aoq39/appl/oracle/ccsps/dtmcs01_04.dbf',
'/aoq40/appl/oracle/ccsps/dtcc01xl_23.dbf',
'/aoq40/appl/oracle/ccsps/dtcc01xl_24.dbf',
'/aoq41/appl/oracle/ccsps/dtcc01xl_25.dbf',
'/aoq41/appl/oracle/ccsps/dtcc01xl_26.dbf',
'/aoq46/appl/oracle/ccsps/dtcc01xl_27.dbf',
'/aoq46/appl/oracle/ccsps/dtcc01xl_28.dbf',
'/aoq53/appl/oracle/ccsps/dtcc01xl_29.dbf',
'/aoq53/appl/oracle/ccsps/dtcc01xl_30.dbf',
'/aoq53/appl/oracle/ccsps/dtcc01xl_31.dbf',
'/aoq47/appl/oracle/ccsps/dtcc01xl_32.dbf',
'/aoq47/appl/oracle/ccsps/dtcc01xl_33.dbf',
'/aoq46/appl/oracle/ccsps/dtcc01xl_34.dbf',
'/aoq27/appl/oracle/ccsps/dtcc01xl_35.dbf',
'/aoq49/appl/oracle/ccsps/dtcc01xl_36.dbf',
'/aoq25/appl/oracle/ccsps/dtcc01xl_37.dbf',
'/aoq24/appl/oracle/ccsps/dtcc01xl_38.dbf',
'/aoq58/appl/oracle/ccsps/dtcc01xl_39.dbf',
'/aoq58/appl/oracle/ccsps/dtcc01xl_40.dbf',
'/aoq58/appl/oracle/ccsps/dtcc01xl_41.dbf',
'/aoq59/appl/oracle/ccsps/dtcc01xl_42.dbf',
'/aoq59/appl/oracle/ccsps/dtcc01xl_43.dbf',
'/aoq35/appl/oracle/ccsps/cc01l_idx01.dbf',
'/aoq35/appl/oracle/ccsps/cc01l_idx02.dbf',
'/aoq35/appl/oracle/ccsps/cc01l_idx03.dbf',
'/aoq35/appl/oracle/ccsps/cc01l_idx04.dbf',
'/aoq45/appl/oracle/ccsps/cc01l_idx16.dbf',
'/aoq45/appl/oracle/ccsps/cc01l_idx17.dbf',
'/aoq52/appl/oracle/ccsps/cc01l_idx18.dbf',
'/aoq52/appl/oracle/ccsps/cc01l_idx19.dbf',
'/aoq48/appl/oracle/ccsps/cc01l_idx19.dbf',
'/aoq48/appl/oracle/ccsps/cc01l_idx20.dbf',
'/aoq52/appl/oracle/ccsps/cc01l_idx21.dbf',
'/aoq12/appl/oracle/ccsps/cc01l_idx22.dbf',
'/aoq12/appl/oracle/ccsps/cc01l_idx23.dbf',
'/aoq15/appl/oracle/ccsps/cc01l_idx24.dbf',
'/aoq60/appl/oracle/ccsps/cc01l_idx25.dbf',
'/aoq60/appl/oracle/ccsps/cc01l_idx26.dbf',
'/aoq60/appl/oracle/ccsps/cc01l_idx27.dbf',
'/aoq34/appl/oracle/ccsps/cdw01_dat01.dbf',
'/aoq34/appl/oracle/ccsps/cdw01_dat02.dbf',
'/aoq34/appl/oracle/ccsps/cdw01_dat03.dbf',
'/aoq34/appl/oracle/ccsps/cdw01_dat04.dbf',
'/aoq47/appl/oracle/ccsps/cdw01_dat05.dbf',
'/aoq66/appl/oracle/ccsps/incc01m_06.dbf',
'/aoq75/appl/oracle/ccsps/incc01m_07.dbf',
'/aoq75/appl/oracle/ccsps/incc01m_08.dbf',
'/aoq69/appl/oracle/ccsps/incc01m_09.dbf',
'/aoq12/appl/oracle/ccsps/incc01m_09.dbf',
'/aoq45/appl/oracle/ccsps/dtcc01m_05.dbf.dbf',
'/aoq62/appl/oracle/ccsps/dtcc01m_06.dbf',
'/aoq28/appl/oracle/ccsps/dtcc01m_07.dbf',
'/aoq76/appl/oracle/ccsps/dtcc01m_08.dbf',
'/aoq71/appl/oracle/ccsps/dtcc01m_09.dbf',
'/aoq62/appl/oracle/ccsps/cc01l_idx28.dbf',
'/aoq65/appl/oracle/ccsps/cc01l_idx29.dbf',
'/aoq65/appl/oracle/ccsps/cc01l_idx30.dbf',
'/aoq75/appl/oracle/ccsps/cc01l_idx31.dbf',
'/aoq75/appl/oracle/ccsps/cc01l_idx32.dbf',
'/aoq75/appl/oracle/ccsps/cc01l_idx33.dbf',
'/aoq82/appl/oracle/ccsps/cc01l_idx34.dbf',
'/aoq84/appl/oracle/ccsps/cc01l_idx34.dbf',
'/aoq68/appl/oracle/ccsps/dtlob2dat_30.dbf',
'/aoq68/appl/oracle/ccsps/dtlob2dat_31.dbf',
'/aoq71/appl/oracle/ccsps/dtlob2dat_32.dbf',
'/aoq71/appl/oracle/ccsps/dtlob2dat_33.dbf',
'/aoq71/appl/oracle/ccsps/dtlob2dat_34.dbf',
'/aoq72/appl/oracle/ccsps/dtlob2dat_35.dbf',
'/aoq72/appl/oracle/ccsps/dtlob2dat_36.dbf',
'/aoq66/appl/oracle/ccsps/dtlob2dat_37.dbf',
'/aoq66/appl/oracle/ccsps/dtlob2dat_38.dbf',
'/aoq73/appl/oracle/ccsps/dtlob2dat_39.dbf',
'/aoq56/appl/oracle/ccsps/dtlob2dat_40.dbf',
'/aoq50/appl/oracle/ccsps/dtlob2dat_41.dbf',
'/aoq79/appl/oracle/ccsps/dtlob2dat_42.dbf',
'/aoq79/appl/oracle/ccsps/dtlob2dat_43.dbf',
'/aoq78/appl/oracle/ccsps/dtlob2dat_44.dbf',
'/aoq80/appl/oracle/ccsps/dtlob2dat_45.dbf',
'/aoq80/appl/oracle/ccsps/dtlob2dat_46.dbf',
'/aoq81/appl/oracle/ccsps/dtlob2dat_47.dbf',
'/aoq81/appl/oracle/ccsps/dtlob2dat_48.dbf',
'/aoq81/appl/oracle/ccsps/dtlob2dat_49.dbf',
'/aoq83/appl/oracle/ccsps/dtlob2dat_50.dbf',
'/aoq66/appl/oracle/ccsps/dtlob2dat_51.dbf',
'/aoq72/appl/oracle/ccsps/dtlob2dat_52.dbf',
'/aoq73/appl/oracle/ccsps/dtlob2dat_53.dbf',
'/aoq74/appl/oracle/ccsps/dtlob2dat_54.dbf',
'/aoq76/appl/oracle/ccsps/dtlob2dat_55.dbf',
'/aoq77/appl/oracle/ccsps/dtlob2dat_56.dbf',
'/aoq55/appl/oracle/ccsps/dtlob2dat_57.dbf',
'/aoq76/appl/oracle/ccsps/dtlob3dat_13.dbf',
'/aoq67/appl/oracle/ccsps/dtcc01xl_44.dbf',
'/aoq67/appl/oracle/ccsps/dtcc01xl_45.dbf',
'/aoq67/appl/oracle/ccsps/dtcc01xl_46.dbf',
'/aoq69/appl/oracle/ccsps/dtcc01xl_47.dbf',
'/aoq69/appl/oracle/ccsps/dtcc01xl_48.dbf',
'/aoq79/appl/oracle/ccsps/dtcc01xl_49.dbf',
'/aoq80/appl/oracle/ccsps/dtcc01xl_50.dbf',
'/aoq82/appl/oracle/ccsps/dtcc01xl_51.dbf',
'/aoq84/appl/oracle/ccsps/dtcc01xl_52.dbf',
'/aoq85/appl/oracle/ccsps/dtcc01xl_53.dbf',
'/aoq85/appl/oracle/ccsps/dtcc01xl_54.dbf',
'/aoq86/appl/oracle/ccsps/dtcc01xl_55.dbf',
'/aoq85/appl/oracle/ccsps/dtcc01xl_56.dbf',
'/aoq85/appl/oracle/ccsps/dtcc01xl_57.dbf',
'/aoq86/appl/oracle/ccsps/dtcc01xl_58.dbf',
'/aoq86/appl/oracle/ccsps/dtcc01xl_59.dbf',
'/aoq86/appl/oracle/ccsps/dtcc01xl_60.dbf',
'/aoq76/appl/oracle/ccsps/dtcc01xl_61.dbf',
'/aoq34/appl/oracle/ccsps/dtcc01xl_62.dbf',
'/aoq74/appl/oracle/ccsps/dtcc01xl_63.dbff',
'/aoq74/appl/oracle/ccsps/dtcc01xl_64.dbf',
'/aoq73/appl/oracle/ccsps/dtcc01xl_65.dbf',
'/aoq90/appl/oracle/ccsps/dtcc01xl_67.dbf',
'/aoq90/appl/oracle/ccsps/dtcc01xl_68.dbf',
'/aoq90/appl/oracle/ccsps/dtcc01xl_69.dbf',
'/aoq34/appl/oracle/ccsps/mcs01_dat01.dbf',
'/aoq34/appl/oracle/ccsps/mcs01_dat02.dbf',
'/aoq62/appl/oracle/ccsps/mcs01_dat05.dbf',
'/aoq73/appl/oracle/ccsps/srs01_dat_04.dbf',
'/aoq73/appl/oracle/ccsps/srs01_dat_05.dbf',
'/aoq74/appl/oracle/ccsps/srs01_dat_06.dbf',
'/aoq74/appl/oracle/ccsps/srs01_dat_07.dbf',
'/aoq77/appl/oracle/ccsps/am_staging_d_01.dbf',
'/aoq77/appl/oracle/ccsps/am_staging_d_02.dbf',
'/aoq77/appl/oracle/ccsps/am_staging_d_03.dbf',
'/aoq78/appl/oracle/ccsps/am_staging_d_04.dbf',
'/aoq78/appl/oracle/ccsps/am_staging_d_05.dbf',
'/aoq61/appl/oracle/ccsps/dtlob2dat_58.dbf',
'/aoq74/appl/oracle/ccsps/dtlob2dat_59.dbf',
'/aoq59/appl/oracle/ccsps/dtlob2dat_60.dbf',
'/aoq68/appl/oracle/ccsps/dtlob2dat_61.dbf',
'/aoq70/appl/oracle/ccsps/dtlob2dat_62.dbf',
'/aoq70/appl/oracle/ccsps/dtlob2dat_63.dbf',
'/aoq86/appl/oracle/ccsps/dtlob2dat_64.dbf',
'/aoq84/appl/oracle/ccsps/dtlob2dat_65.dbf',
'/aoq84/appl/oracle/ccsps/dtlob2dat_66.dbf',
'/aoq85/appl/oracle/ccsps/dtlob2dat_676.dbf',
'/aoq86/appl/oracle/ccsps/dtlob2dat_68.dbf',
'/aoq83/appl/oracle/ccsps/dtlob2dat_69.dbf',
'/aoq37/appl/oracle/ccsps/dtlob2dat_70.dbf',
'/aoq37/appl/oracle/ccsps/dtlob2dat_71.dbf',
'/aoq47/appl/oracle/ccsps/dtlob2dat_72.dbf',
'/aoq57/appl/oracle/ccsps/dtlob2dat_74.dbf',
'/aoq70/appl/oracle/ccsps/dtlob2dat_75.dbf',
'/aoq56/appl/oracle/ccsps/dtlob2dat_76.dbf',
'/aoq70/appl/oracle/ccsps/dtlob2dat_77.dbf',
'/aoq88/appl/oracle/ccsps/dtlob2dat_79.dbf',
'/aoq88/appl/oracle/ccsps/dtlob2dat_80.dbf',
'/aoq88/appl/oracle/ccsps/dtlob2dat_81.dbf',
'/aoq89/appl/oracle/ccsps/dtlob2dat_82.dbf',
'/aoq89/appl/oracle/ccsps/dtlob2dat_83.dbf',
'/aoq89/appl/oracle/ccsps/dtlob2dat_84.dbf',
'/aoq91/appl/oracle/ccsps/dtlob2dat_85.dbf',
'/aoq91/appl/oracle/ccsps/dtlob2dat_86.dbf',
'/aoq96/appl/oracle/ccsps/dtlob2dat_87.dbf',
'/aoq96/appl/oracle/ccsps/dtlob2dat_88.dbf',
'/aoq96/appl/oracle/ccsps/dtlob2dat_89.dbf',
'/aoq97/appl/oracle/ccsps/dtlob2dat_90.dbf',
'/aoq97/appl/oracle/ccsps/dtlob2dat_91.dbf',
'/aoq97/appl/oracle/ccsps/dtlob2dat_92.dbf',
'/aoq88/appl/oracle/ccsps/dtlob2dat_93.dbf',
'/aoq89/appl/oracle/ccsps/dtlob2dat_94.dbf',
'/aoq90/appl/oracle/ccsps/dtlob2dat_95.dbf',
'/aoq91/appl/oracle/ccsps/dtlob2dat_96.dbf',
'/aoq91/appl/oracle/ccsps/dtlob2dat_97.dbf',
'/aoq93/appl/oracle/ccsps/dtlob2dat_98.dbf',
'/aoq94/appl/oracle/ccsps/dtlob2dat_99.dbf',
'/aoq95/appl/oracle/ccsps/dtlob2dat_100.dbf',
'/aoq97/appl/oracle/ccsps/dtlob2dat_101.dbf',
'/aoq92/appl/oracle/ccsps/dtlob2dat_102.dbf',
'/aoq92/appl/oracle/ccsps/dtlob2dat_103.dbf',
'/aoq26/appl/oracle/ccsps/dtlob2dat_107.dbf',
'/aoq26/appl/oracle/ccsps/dtlob2dat_108.dbf',
'/aoq12/appl/oracle/ccsps/dtlob2dat_109.dbf',
'/aoq25/appl/oracle/ccsps/dtlob2dat_110.dbf',
'/aoq17/appl/oracle/ccsps/dtlob2dat_111.dbf',
'/aoq29/appl/oracle/ccsps/dtlob2dat_115.dbf',
'/aoq29/appl/oracle/ccsps/dtlob2dat_116.dbf',
'/aoq29/appl/oracle/ccsps/dtlob2dat_117.dbf',
'/aoq28/appl/oracle/ccsps/dtcc01xl_71.dbf'
CHARACTER SET US7ASCII
 



Please help us as our produciton database is not coming up due to this issue and we are on the verge of missing SLA.

Thanks in advance.




Re: ORA-01161: database name CCSPS in file header does not match given name of CCSP [message #532874 is a reply to message #532866] Fri, 25 November 2011 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 65377
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You try to create a control file for a database named CCSPS but the header of (at least one of) the files contains another name, so Oracle can't associate both.

Regards
Michel
Re: ORA-01161: database name CCSPS in file header does not match given name of CCSP [message #532878 is a reply to message #532874] Fri, 25 November 2011 04:49 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
So what is the workaround for that ? Please help..
Re: ORA-01161: database name CCSPS in file header does not match given name of CCSP [message #532880 is a reply to message #532878] Fri, 25 November 2011 05:05 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
Perhaps you copied the wrong file, or perhaps the ownership/permissions are wrong.
Re: ORA-01161: database name CCSPS in file header does not match given name of CCSP [message #532887 is a reply to message #532880] Fri, 25 November 2011 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65377
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or maybe the file is corrupted.

Regards
Michel
Re: ORA-01161: database name CCSPS in file header does not match given name of CCSP [message #533036 is a reply to message #532887] Sun, 27 November 2011 14:43 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Ok.., How about REUSE command ?

CREATE CONTROLFILE  REUSE SET DATABASE "CCSPS" RESETLOGS NOARCHIVELOG 


- Babu
Re: ORA-01161: database name CCSPS in file header does not match given name of CCSP [message #533058 is a reply to message #533036] Mon, 28 November 2011 01:15 Go to previous message
Michel Cadot
Messages: 65377
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The REUSE option say you want to reuse an already present control file, it will not fix anything about data files header!

Regards
Michel
Previous Topic: Connect to Target db
Next Topic: Can we convert or export oracle 9i dump to 8i dump
Goto Forum:
  


Current Time: Sun Feb 18 01:57:16 CST 2018

Total time taken to generate the page: 0.29775 seconds