May be you try the following:
If you get errors restoring controlfile, You may ftp the controlfiles manually to the new server and startup mount the database first. Then, Try your restore database.
-- Janardhana
-----Original Message-----
Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database.
Some of the steps to setup the new machine. 1) Install oracle 8i 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the "RMAN-03022: compiling command: set " and just hangs...adding another line every 1/2 hour or so...
Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple..
Here is the command in operation
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN>
RMAN-06006: connected to target database: vssppln (not mounted)
RMAN-03022: compiling
command: allocate
RMAN-03022: compiling
command: sql
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling
command: set (and it slowly keeps spitting out these "RMAN-03022: compiling command: set " ) |
Title: Message
- RMAN restore on another server Spears, Brian
- RE: RMAN restore on another server DENNIS WILLIAMS
- Re: RMAN restore on another server Joe Testa
- RE: RMAN restore on another server Janardhana Babu Donga
- RE: RMAN restore on another server Janardhana Babu Donga
- RE: RMAN restore on another server Janardhana Babu Donga
- RE: RMAN restore on another server DENNIS WILLIAMS
- Re: RMAN restore on another server Jared Still
- RE: RMAN restore on another server Spears, Brian
- RE: RMAN restore on another server Spears, Brian
- RE: RMAN restore on another server DENNIS WILLIAMS
- RE: RMAN restore on another server DENNIS WILLIAMS
- RE: RMAN restore on another server Spears, Brian
- RE: RMAN restore on another server Josh Collier