Performing Disaster Recovery › Scenarios for Restoring to an Alternate Server › Restore to a Server with Different Directory Structures

Restore to a Server with Different Directory Structures

Use the following procedure to restore to an alternate server that cannot support the different directory structure.

To restore the database to a server with different directory structure

1. Install the option on the target server, and add an additional Oracle database instance for the new database that you want to recover.
2. Create an ORACLE instance or PWFILE if necessary, as described in the section Recover the ORCL Database in this appendix.
3. In the Arcserve Backup Restore Manager, clear the Restore to original location option.
4. Restore all necessary recovery files (for example, configuration files) to a new location on the target server.
5. Restore the database to the target’s temporary directory (the temporary directory is where you would like to keep the files—database files, archive logs, and control files).
6. Move database files and archive logs to their new location on the target server.
7. Edit the INITSID.ORA to reflect your new directory structure. Because the directory structures are different from the original, the control files must be recreated.
8. Start up the instance but do not mount or open the database.
9. Connect to the instance.
10. Execute the following command:

    Startup nomount
    

11. Issue the create control file command. For the exact syntax, see the Oracle documentation. An example might be:

    create controlfile
    set database TEST
    logfile group 1('e:\oracle\test\redlog1a.ora') size 200K,
    group 2('e:\oracle\test\redlog1b.ora') size 50K
    RESETLOGS
    datafile 'e:\oracle\test\systest.ora' size 10M,
    'e:\oracle\test\testrollback.dbs' size 2M
    maxlogfiles 50
    maxlogmembers 3
    maxdatafiles 200
    maxinstances 6
    archivelog;
    

    Note: The user has specified the RESETLOGS and ARCHIVELOG options.

12. Ensure that the control file is copied to all necessary locations and renamed with the appropriate name.
13. Enter the following command:

    Recover database using backup controlfile until cancel;
    

14. When the recovery is complete, enter the following command:

    Alter database open resetlogs;
    

    This action recreates the redo logs and opens the database. If you get an error, check the previous section.

15. Delete the archive logs.