restore 8i database to different server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: restore 8i database to different server

  1. #1
    Join Date
    Apr 2009
    Posts
    10

    restore 8i database to different server

    I'm testing using rman to restore an 8i database to a different server.
    I connected to the sid on the new server and the rman catalog, and started with this command:
    run {
    allocate channel ch01 type 'sbt_tape';
    restore control file;
    alter database mount;
    }

    It seems to be hung, it's been running for 90 minutes. How can I tell if it's doing anything? Is it ok to just stop this? How long should this step take?
    Thanks very much for any help.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    Talking Tape

    It seems to be waiting on the tape...Otherwise rman would produce an error!

    Or...It is scanning (reading) through the tape in order to find the controlfile which may be at (or close) to the end of the tape file(s).
    Last edited by LKBrwn_DBA; 04-24-2009 at 02:17 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Apr 2009
    Posts
    10
    There was no error message. I did stop it after 2 hours. Could I have caused any problems by stopping it? The test database looks ok. Is there any way to tell that it is doing something, or is just hung up? If it really can take that long just for the controlfile, will the restore database be real long too? The database is about 17-18Gb. Thanks very much.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    Cool Tape is spining

    Use your tape utility (manager) to check the contents of the tape.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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