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.

 

 

 




		
		
		
Report message to a moderator





	
		
	






	
		

		

			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: 68733
Registered: March 2007 
Location: Saint-Maur, France, https...
						
							
					
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


		
		
		
Report message to a moderator





	
		
	






	
		

		

			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..
		
		
		
Report message to a moderator





	
		
	






	
		

		

			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: 8964
Registered: January 2010 
Location: Global Village
						
							
					
Senior Member

					
		

		

			




	
		Perhaps you copied the wrong file, or perhaps the ownership/permissions are wrong.
		
		
		
Report message to a moderator





	
		
	






	
		

		

			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: 68733
Registered: March 2007 
Location: Saint-Maur, France, https...
						
							
					
Senior Member
Account Moderator

					
		

		

			




	
		Or maybe the file is corrupted.



Regards

Michel


		
		
		
Report message to a moderator





	
		
	






	
		

		

			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: 1736
Registered: December 2005 
Location: NJ
						
							
					
Senior Member

					

		

		

			




	
		Ok.., How about REUSE command ?




CREATE CONTROLFILE  REUSE SET DATABASE "CCSPS" RESETLOGS NOARCHIVELOG 




- Babu
		
		
		
Report message to a moderator





	
		
	






	
		

		

			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: 68733
Registered: March 2007 
Location: Saint-Maur, France, https...
						
							
					
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


		
		
		
Report message to a moderator





	
		
	












	

	Previous Topic:
	Connect to Target db 


	

	Next Topic:
	Can we convert or export oracle 9i dump to 8i dump





Goto Forum:


	
	
	  
	





[ Syndicate this forum (XML) ] [ RSS ] 


Current Time: Sun Feb 09 08:34:58 CST 2025









	.::
	Forum Home ::
	Blogger Home ::
	Wiki Home ::
	Contact ::
	Privacy
	::.