Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: Oracle 8 Hot Backup clone machine

    Hello,
    following situation:
    Oracle 8, hot backup.
    We want to clone the machine for developement work and test media recover scenario.

    We switch the tablespaces one after the other into backup mode, copy the datafiles and then exit backup mode. We copy also archivelogfiles and have "log switch" and "archive log current" inside the hot backup.

    On the new machine we create a new control file by script:

    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "DATABASENAME" RESETLOGS ARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 14520
    LOGFILE
    GROUP 1 'E:\ORACLE\ORADATA\DATABASENAME\LOG1.ORA' SIZE 50M,
    GROUP 2 'E:\ORACLE\ORADATA\DATABASENAME\LOG2.ORA' SIZE 50M,
    GROUP 3 'E:\ORACLE\ORADATA\DATABASENAME\LOG3.ORA' SIZE 50M
    DATAFILE
    'E:\ORACLE\ORADATA\DATABASENAME\SYSTEM01.DBF',
    'E:\ORACLE\ORADATA\DATABASENAME\RBS01.DBF',
    'E:\ORACLE\ORADATA\DATABASENAME\USERS01.DBF',
    'E:\ORACLE\ORADATA\DATABASENAME\TEMP01.DBF',
    'E:\ORACLE\ORADATA\DATABASENAME\TOOLS01.DBF',
    'E:\ORACLE\ORADATA\DATABASENAME\INDX01.DBF',
    'E:\ORACLE\ORADATA\DATABASENAME\DATABASENAME_DATA. ORA',
    'E:\ORACLE\ORADATA\DATABASENAME\DATABASENAME_INDX. ORA',
    'E:\ORACLE\ORADATA\DATABASENAME\OEM_REPOSITORY.ORA ',
    'E:\ORACLE\ORADATA\DATABASENAME\DATABASENAME_DATA1 .ORA'
    CHARACTER SET WE8ISO8859P1
    ;

    shutdown immediate;

    startup mount
    SQL> recover database until cancel using backup control file;

    Then Oracle asks for the path to the archivelogs. Gave him the path. Then Oracle reads the archivlogs one after the other. At the end Oracle asks for archivelogs, which will we written by the live system 2 hours after the hot backup. When I gave him this log, then Oracle asks for a logfile, which isn't written yet. Oracle says, that he cannot find the archivelog, of course this log isn't availiabe on the live system.

    I have this problem only since I insert data by script into the live system during the hot backup, to test whether backup is complete.

    After that we can "alter database open resetlogs" and the instance starts and runs fine, but I am not shure if all data are there because of the message of missing archivelog.

    Any idea ?

    Thank you in advance !
    Stefan


    ORA-00289: Vorschlag: E:\ORACLE\ORADATA\DATABASENAME\ARCHIVE\ARC52346.00 1
    ORA-00280: Anderung 39325633 fur Thread 1 in Sequenz #52346
    ORA-00278: Log-Datei 'E:\ORACLE\ORADATA\DATABASENAME\ARCHIVE\ARC52345.0 01' fur diese
    Wiederherstellung nicht mehr erforderlich


    ORA-00308: Archiv-Log 'E:\ORACLE\ORADATA\DATABASENAME\ARCHIVE\ARC52346.0 01' kann
    nicht geoffnet werden
    ORA-27041: Offnen der Datei nicht moglich
    OSD-04002: Datei kann nicht gevffnet werden
    O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down Cancel the reservations

    That is why you used the "until cancel" option in the recover command!
    You are telling Oracle to do recovery until you decide to "cancel".

    Just respond CANCEL and open the database "resetlogs".

    DUH!


    PS: Whatever data is there are completed transactions upto that point in time.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2009
    Posts
    2
    Thank you for your reply.

    I tried this already and it works. I have just a logical problem:

    Why doesn't the Oracle know, until which logfile-no there has to be done the roll forward ? Oracle asks for a logfile-no which doesn't exist yet.

    Hm, I understand, I create a new controlfile, and there is no info there or elsewhere for the new instance on the new machine, till which log-no to rollforward.

    So the database should be consistent for work.

    Just for my understanding - where is the information about the last written archivelog stored ? In the controlfile ?

    Is there are better way to roll forward on a new machine without stopping the instance on the live machine ?
    Thank you & Best regards
    Stefan

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    it is stored in the controlfile.
    Anyways, you can always restore to point-in-time or restore up to SCN.
    That would avoid doing it manually with UNTIL CANCEL.

    Also, you could query what archives need to be applied to get to a stable state after your hotbackup is restored.

    Normally I just do what you did, restore db, then apply archives until cancel and resetlogs. usually it is only 3-10 archivelogs needed after the backup.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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