Database Cloning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Cloning

  1. #1
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56

    Database Cloning

    Hello all :0:

    I am doing a database cloning, and folloed all steps suggested by Sumit sarin in his book "Oracle DBA", bu, at end, in las line, when I order BD to OPEN with RESETLOGS clausule, it says me the following message "file 1 was not restored from a sufficiently old backup"
    I am restoring my Database from my last cold yesterday's backup.

    Have someone a suggestion??

    I really would thanks!
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'm not familiar with that book, but I am guessing your control files are older than your system.dbf datafile.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56
    I WILL EXPLAIN THE STEPS:

    1) Create Parameters Files - Ok
    2) Logon on My current DB, "ALTER DATABASE BACKUP CONTROFILE TO TRACE - Ok
    3) Alter trace file to create all control files again.
    This is my 'OpenClone.sql:

    startup nomount pfile="D:\oracle\admin\clone\pfile\initclone.ora"
    CREATE CONTROLFILE SET DATABASE "CLONE" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 1815
    LOGFILE
    GROUP 1 '\\ORACLE\ORADATA\CLONE\REDO01.LOG' SIZE 1M,
    GROUP 2 '\\ORACLE\ORADATA\CLONE\REDO02.LOG' SIZE 1M,
    GROUP 3 '\\ORACLE\ORADATA\CLONE\REDO03.LOG' SIZE 1M
    DATAFILE
    '\\ORACLE\ORADATA\CLONE\SYSTEM01.DBF',
    '\\ORACLE\ORADATA\CLONE\RBS01.DBF',
    '\\ORACLE\ORADATA\CLONE\USERS01.DBF',
    '\\ORACLE\ORADATA\CLONE\TEMP01.DBF',
    '\\ORACLE\ORADATA\CLONE\TOOLS01.DBF',
    '\\ORACLE\ORADATA\CLONE\INDX01.DBF',
    ALTER DATABASE OPEN RESETLOGS;


    OK
    4) Copy all Data Files and Redo Files - OK
    Here I am restoring from my last cold backup - Today - 01:30 am
    5) Define System Variables like ORACLE_HOME, ORACLE_SID... - OK
    6) Initiate Instance - OK
    7) Execute my "INITCLONE.SQL" - OK
    Here error occurs pointing that '\\ORACLE\ORADATA\CLONE\SYSTEM01.DBF', is in error

    Please, help me

    Sorry by my so long post!!
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

  4. #4
    Join Date
    Apr 2001
    Posts
    108
    Your script has a comma where it should have a semi-colon at the end of the file list. ie:

    startup nomount pfile="D:\oracle\admin\clone\pfile\initclone.ora"
    CREATE CONTROLFILE SET DATABASE "CLONE" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 1815
    LOGFILE
    GROUP 1 '\\ORACLE\ORADATA\CLONE\REDO01.LOG' SIZE 1M,
    GROUP 2 '\\ORACLE\ORADATA\CLONE\REDO02.LOG' SIZE 1M,
    GROUP 3 '\\ORACLE\ORADATA\CLONE\REDO03.LOG' SIZE 1M
    DATAFILE
    '\\ORACLE\ORADATA\CLONE\SYSTEM01.DBF',
    '\\ORACLE\ORADATA\CLONE\RBS01.DBF',
    '\\ORACLE\ORADATA\CLONE\USERS01.DBF',
    '\\ORACLE\ORADATA\CLONE\TEMP01.DBF',
    '\\ORACLE\ORADATA\CLONE\TOOLS01.DBF',
    '\\ORACLE\ORADATA\CLONE\INDX01.DBF';
    ALTER DATABASE OPEN RESETLOGS;
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

  5. #5
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56
    Thanks by your attention, but I've just typed wrong.
    Im my SQL File there is a semicolon on the right place.
    Anyway, thanks!!!
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

Posting Permissions

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



Click Here to Expand Forum to Full Width