Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2006
    Location
    ISTANBUL/TURKEY
    Posts
    6

    Unanswered: Copying Database , urgent help is needed

    Hi,
    I am trying to create a copy of a database according to note 18070.1 in metalink. I am trying to move 10.1.0.3 (TASDEN) database to 10.2.0.1 (ORATEST) database. My purpose is to copy datafiles to faster disks on another machine. Following the note, i issued the command :
    ALTER DATABASE BACKUP CONTROLFILE TO TRACE on TASDEN db
    and copied the datafiles and control files to new machine. And changed the script to the new paths. Then note and books says on the new machine issue :
    startup nomount
    SQL> startup nomount;
    ORACLE instance started.

    Total System Global Area 591396864 bytes
    Fixed Size 2022536 bytes
    Variable Size 377488248 bytes
    Database Buffers 205520896 bytes
    Redo Buffers 6365184 bytes
    SQL>
    SQL> CREATE CONTROLFILE REUSE SET DATABASE "ORATEST" RESETLOGS NOARCHIVELOG
    2 MAXLOGFILES 16
    3 MAXLOGMEMBERS 3
    4 MAXDATAFILES 100
    5 MAXINSTANCES 8
    6 MAXLOGHISTORY 454
    7 LOGFILE
    8 GROUP 1 '/redolog1/redo01.log' SIZE 10M,
    9 GROUP 2 '/redolog1/redo02.log' SIZE 10M,
    10 GROUP 3 '/redolog1/redo03.log' SIZE 10M
    11 -- STANDBY LOGFILE
    12 DATAFILE
    13 '/ocfs/dbtst01/ORATEST/system01.dbf',
    14 '/ocfs/dbtst01/ORATEST/undotbs01.dbf',
    15 '/ocfs/dbtst01/ORATEST/sysaux01.dbf',
    16 '/ocfs/dbtst01/ORATEST/users01.dbf',
    17 '/ocfs/dbtst01/ORATEST/koray01.dbf'
    18 CHARACTER SET TR8MSWIN1254
    ; 19
    CREATE CONTROLFILE REUSE SET DATABASE "ORATEST" RESETLOGS NOARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-12720: operation requires database is in EXCLUSIVE mode


    SQL>

    And i haven't seen anybody facing such problem. Am i missing some point or what may be the cause of this?

    Thanks,

    Koray

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Have you setup a new parameter file for the new instance? Did you reference it in your startup command? Until the database is actually created, oracle has no way to figure out the pfile.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Feb 2006
    Location
    ISTANBUL/TURKEY
    Posts
    6
    Hi,
    The main problem was i was trying to copy single instance database to RAC. I tried copying it to single instance db, then problem is solved. But now i have another problem. After issuing the following :

    SQL> RECOVER DATABASE USING backup CONTROLFILE;
    ORA-00279: change 390838 generated at 04/14/2006 14:10:25 needed for thread 1
    ORA-00289: suggestion : /archlog1/SONDAN/1_1_587745234.dbf
    ORA-00280: change 390838 for thread 1 is in sequence #1


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    /archlog1/SONDAN/1_10_587647432.dbf
    ORA-00342: archived log does not have expected resetlogs SCN 390838
    ORA-00334: archived log: '/archlog1/SONDAN/1_10_587647432.dbf'

    and i don't know why it happened?

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    When you made the physical backup of the database files, was the original database shutdown?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Metalink indicates this error involve "changing" the characterset.
    Also, IMO you should NOT be copying the control files since you are CREATING new one(s).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    CREATE CONTROLFILE REUSE SET DATABASE "ORATEST" RESETLOGS NOARCHIVELOG
    Remove the word REUSE (the option is either REUSE or SET - in this instance you need SET):

    CREATE CONTROLFILE SET DATABASE "ORATEST" RESETLOGS NOARCHIVELOG
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •