Brian - I think that is the problem -- you can't tell RMAN you are on a different server. The part I'm not getting a clear picture on is your control file. For this specific recovery, how is it getting a control file? Did you move one over from production, or are you waiting for RMAN to cough it up from the backup pieces? On 8i this tends to be a problem.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, December 08, 2003 8:39 AM To: Multiple recipients of list ORACLE-L I have ftp'd the backup pieces into the identical backup location as the orignal server so I have all the stuff available... Im just wondering if I have to do something to tell it that I am on a different server... I've restored the controlfile mannually before but on the same server. I backup the controlfile and wrap in the backup piece with the normal backup. Brian -----Original Message----- DENNIS WILLIAMS Sent: Friday, December 05, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Janardhana - That's a good point. Brian - were you expecting RMAN to extract your controlfile from the RMAN backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in 8i. I couldn't get that to work myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, December 05, 2003 6:49 PM To: Multiple recipients of list ORACLE-L 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----- Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L 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 2) install the patch 4.0 3) copy .profile over 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> connect catalog rman81740/[EMAIL PROTECTED] <mailto:rman81740/[EMAIL PROTECTED]> 2> 3> connect target / 4> 5> 6> 7> run 8> 9> { 10> 11> allocate channel disk_channel1 type disk ; 12> 13> sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"'; 14> set until time = '2003-12-02 05:50:00'; 15> 16> set newname for datafile 1 to 17> '/u02/vssppln/system01.dbf'; 18> 19> set newname for datafile 2 to 20> '/u02/vssppln/rbs01.dbf'; 21> 22> set newname for datafile 3 to 23> '/u02/vssppln/rbs02.dbf'; 24> 25> set newname for datafile 4 to 26> '/u02/vssppln/AIMFACT01.dbf'; 27> 28> set newname for datafile 5 to 29> '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30> 31> set newname for datafile 6 to 32> '/u02/vssppln/AIMFACT101.dbf'; 33> 34> set newname for datafile 7 to 35> '/u02/vssppln/AIMFACT102.dbf'; 36> 37> set newname for datafile 8 to 38> '/u02/vssppln/aimfact1_index01.dbf'; 39> 40> set newname for datafile 9 to 41> '/u02/vssppln/aimfact1_index02.dbf'; 42> 43> set newname for datafile 10 to 44> '/u02/vssppln/aimfact1_index03.dbf'; 45> 46> set newname for datafile 11 to 47> '/u02/vssppln/aimfact1_index04.dbf'; 48> 49> set newname for datafile 12 to 50> '/u02/vssppln/aimfact201.dbf'; 51> 52> set newname for datafile 13 to 53> '/u02/vssppln/aimfact202.dbf'; 54> 55> set newname for datafile 14 to 56> '/u02/vssppln/aimfact2_index01.dbf'; 57> 58> set newname for datafile 15 to 59> '/u02/vssppln/aimfact2_index02.dbf'; 60> 61> set newname for datafile 16 to 62> '/u02/vssppln/aimfact2_index03.dbf'; 63> 64> set newname for datafile 17 to 65> '/u02/vssppln/aimfact2_index04.dbf'; 66> 67> set newname for datafile 18 to 68> '/u02/vssppln/aimstruct01.dbf'; 69> 70> set newname for datafile 19 to 71> '/u02/vssppln/aimstruct_index01.dbf'; 72> 73> set newname for datafile 20 to 74> '/u02/vssppln/aimstruct101.dbf'; 75> 76> set newname for datafile 21 to 77> '/u02/vssppln/aimstruct1_index01.dbf'; 78> 79> set newname for datafile 22 to 80> '/u02/vssppln/aimwork01.dbf'; 81> 82> set newname for datafile 23 to 83> '/u02/vssppln/mipsdata01.dbf'; 84> 85> set newname for datafile 24 to 86> '/u02/vssppln/mipsindex01.dbf'; 87> 88> set newname for datafile 25 to 89> '/u02/vssppln/mipsdata101.dbf'; 90> 91> set newname for datafile 26 to 92> '/u02/vssppln/mipsdata1_index01.dbf'; 93> 94> set newname for datafile 27 to 95> '/u02/vssppln/mipsdata201.dbf'; 96> 97> set newname for datafile 28 to 98> '/u02/vssppln/nipsdata2_index01.dbf'; 99> 100> set newname for datafile 29 to 101> '/u02/vssppln/tools01.dbf'; 102> 103> set newname for datafile 30 to 104> '/u02/vssppln/users01.dbf'; 105> 106> set newname for datafile 31 to 107> '/u02/vssppln/AIMINDEX01.dbf'; 108> 109> set newname for datafile 32 to 110> '/u02/vssppln/aimfact1_index05.dbf'; 111> 112> set newname for datafile 33 to 113> '/u02/vssppln/aimfact2_index05.dbf'; 114> 115> 116> restore database; 117> 118> restore controlfile to '/u02/vssppln/restored_cf.ctl'; 119> 120> mount database; 121> 122> switch datafile all; 123> 124> release channel disk_channel1; 125> } 126> 127> RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target database: vssppln (not mounted) RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: disk_channel1 RMAN-08500: channel disk_channel1: sid=10 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS" RMAN-03023: executing 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 " ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Spears, Brian INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
