Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Exclamation Unanswered: Stuck Cloning Database

    I am in the process of cloning a database onto a Windows 2000 machine. The cursor has been sitting at the command "recover database until cancel from controlfile;" for 45 minutes. It's a large database, about 13.5 GB and I edited the control trace file (created with the "alter database backup controlfile to trace" command) to use the "set database" command instead of "reuse database"). I thought it was supposed to ask for the log sequence where I could enter "auto", but it's not. What should I do? Thanks for your help! Here's a listing of the backup control I'm using.

    Dump file C:\ORANT\RDBMS72\trace\ORA01756.TRC
    Wed Dec 31 11:52:41 2003
    ORACLE V7.2.2.4.0 - Production Release vsnsta=0
    vsnsql=a vsnxtr=3
    Windows NT V5.0, OS V8.147, CPU type 586
    Wed Dec 31 11:52:41 2003
    Wed Dec 31 11:52:41 2003

    *** SESSION ID9.1) 2003.12.31.11.52.41.402
    # The following commands will create a new control file and use it
    # to open the database.
    # No data other than log history will be lost. Additional logs may
    # be required for media recovery of offline data files. Use this
    # only if the current version of all online logs are available.
    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "BSS" RESETLOGS ARCHIVELOG
    MAXLOGFILES 10
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 1
    MAXLOGHISTORY 100
    LOGFILE
    GROUP 1 (
    'd:\ORACLE\log1bss.ora',
    'd:\ORACLE\log2bss.ora'
    ) SIZE 20M,
    GROUP 2 (
    'd:\ORACLE\log3bss.ora',
    'd:\ORACLE\log4bss.ora'
    ) SIZE 20M,
    GROUP 3 (
    'd:\ORACLE\log5bss.ora',
    'd:\ORACLE\log6bss.ora'
    ) SIZE 20M,
    GROUP 4 (
    'd:\ORACLE\log7bss.ora',
    'd:\ORACLE\log8bss.ora'
    ) SIZE 20M,
    GROUP 5 (
    'd:\ORACLE\log9bss.ora',
    'd:\ORACLE\log10bss.ora'
    ) SIZE 20M,
    GROUP 6 (
    'd:\ORACLE\log11bss.ora',
    'd:\ORACLE\log12bss.ora'
    ) SIZE 20M
    DATAFILE
    'd:\oracle\bsssys.ora',
    'd:\oracle\bssdata01.ora',
    'd:\oracle\bssuser.ora',
    'd:\oracle\bssdata02.ora',
    'd:\oracle\bssdata03.ora',
    'd:\oracle\bssdata04.ora',
    'd:\oracle\bssdata05.ora',
    'd:\oracle\bssdata06.ora',
    'd:\oracle\bssdata07.ora',
    'd:\oracle\bssdata08.ora',
    'd:\oracle\bssdata09.ora'
    ;

    # Recovery is required if any of the datafiles are restored backups,
    # or if the last shutdown was not normal or immediate.
    RECOVER DATABASE

    # All logs need archiving and a log switch is needed.
    ALTER SYSTEM ARCHIVE LOG ALL;

    # Database can now be opened normally.
    ALTER DATABASE OPEN;

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    What is your Backup type? I mean to ask is it Cold or Hot?

    If it is Cold then, No need to Recover. Also Change the ARCHIVELOG TO NOARCHIVELOG in CREATE CONTROLFILE command.

    No need to type "RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL'

    Simply open your database with ALTER DATABASE OPEN RESETLOGS statement.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Dec 2003
    Posts
    5
    Originally posted by Hings
    What is your Backup type? I mean to ask is it Cold or Hot?

    If it is Cold then, No need to Recover. Also Change the ARCHIVELOG TO NOARCHIVELOG in CREATE CONTROLFILE command.

    No need to type "RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL'

    Simply open your database with ALTER DATABASE OPEN RESETLOGS statement.

    I'm REALLY new to Oracle and copied the live data files over to the test server, instead of using the hotbu files. I know better now. Anyway, I cancelled out of the stuck command and issued "recover database". It then said "statement processed" and then I opened the database and all is well. Looked at the alert log file and it said it recovered data files from a "fuzzy" backup. I hope that's alright. Thanks for your help, I'm learning a lot! Happy New Year!

Posting Permissions

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