Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Question Unanswered: Moving Backup To New Server

    Our company database on is having several performance issues due to hardware alone. I've received the new standalone database server and I've just installed Oracle 11g R2 (11.2.0.3) on RHEL 6.1 Linux fine.

    When I installed Oracle Database 11g, I used the OUI as recommended per the docs. During the OUI installer, I selected 'Enterprise Edition' & 'Install database software only' which finished successful however there now is obviously no database instance running on my new server since I installed database software only and omitted creating a test / sample database from OUI.

    My question is for you seasoned DBA's for how I should proceed from this point. I've got a full backup copy that I took from the old failing database server using RMAN. Now since I did a 'Install database software only' option and no Instance or database exist on the new system, do I / should I first create a database using the 'dbca' utility as mentioned here:

    Installing Oracle Database and Creating a Database

    or should I not even waste my time doing 'dbca' to create a new database / instance since I'm going to import the database information from a backup I took from the old server?

    I'm not sure what the logical order of procedure is for me in the above scenario.

    Thanks for any info!

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    If you're planning to import the database then at the very least you will need to create an instance, otherwise you won't have anything in to which you can import it.

    If you're using RMAN then consider using it to create your duplicate database.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Sep 2012
    Posts
    18
    new database with primary database's DBFs and CTLs are needed i guess

    you want to make a replica?

Posting Permissions

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