RE: RMAN restore on another server
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=-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
RE: RMAN restore on another server
DENNIS...Thanks for your feedback. Here it is.. (NSF problem??) 1. I am not using Tape only disk backups.. 2. I ftp'd the backup pieces to new machine 3. I created a link to duplicate the backup location on the original machine and other locations as pfiles...edited the init file for new control locations etc. 4. The controlfile was wrapping in the backup piece same backup command 5. It is an NSF mount point. (Netapp) Is there a solution with the NFS issue? Brian Spears Database Services [EMAIL PROTECTED] Limitedbrands TECHNOLOGY SERVICES -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4: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=-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
RE: RMAN restore on another server
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=-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
RE: RMAN restore on another server
Brian - My sys admin pleads amnesia on the NFS problem. My recollection was that it was misconfigured or had a default configuration that expected only a couple of connections and RMAN actually opens MANY file connections. My specific symptoms is that RMAN would create the first few data files and then just stop. Oracle Support made me take NFS out of the mix and then everything worked. In your case, I am also concerned about the control file. I was unable to get 8i to create the control file from the backup although others on this list reported success with that. I would feel better if you said that you separately backed up the control file at the end of the RMAN backup, and manually moved that control file into place on the test system. At least you would eliminate that as the problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 08, 2003 8:49 AM To: Multiple recipients of list ORACLE-L DENNIS...Thanks for your feedback. Here it is.. (NSF problem??) 1. I am not using Tape only disk backups.. 2. I ftp'd the backup pieces to new machine 3. I created a link to duplicate the backup location on the original machine and other locations as pfiles...edited the init file for new control locations etc. 4. The controlfile was wrapping in the backup piece same backup command 5. It is an NSF mount point. (Netapp) Is there a solution with the NFS issue? Brian Spears Database Services [EMAIL PROTECTED] Limitedbrands TECHNOLOGY SERVICES -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4: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=-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
RE: RMAN restore on another server
Dennis and all, I have no problem getting the controlfile... I just comment out the SET commands to change the directories of the dbfs...and I replicate the control according to the init file specifications.. So This operation actually extract the controlfile out of the backup piece so I know the location and connections are working fine. But since the controlfile is backup and I am restoring it with the same RMan command I think I should have no problem.. I know other DBAs.. run this same script and restore the database on another server with no problem if the controlfile is restored before the database is restored and recovered. Here is the restore controlfile script and resulting log file == Controlfile restore Script == connect catalog rman81740/[EMAIL PROTECTED] connect target / run { allocate channel d1 type disk ; sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; set until time = '2003-12-02 05:50:00'; #restore controlfile to '/u02/vssppln/restored_cf.ctl'; replicate controlfile from '/u02/vssppln/restored_cf.ctl'; release channel d1; } == Successful Controlfile restore log == Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 run 7 8 { 9 10 allocate channel d1 type disk ; 11 12 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 13 set until time = '2003-12-02 05:50:00'; 14 15 16 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 17 18 replicate controlfile from '/u02/vssppln/restored_cf.ctl'; 19 20 release channel d1; 21 } 22 23 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: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS RMAN-03023: executing command: sql RMAN-03022: compiling command: set RMAN-03022: compiling command: replicate RMAN-03023: executing command: replicate RMAN-08058: replicating controlfile RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1 Recovery Manager complete. = Here is the orignal entire script to restore controlfile and database but it just hangs on the set commands.. = == 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] 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=-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
RE: RMAN restore on another server
why not use the RMAN duplicate database process. that sounds like what you are trying to do. Have you ever let the script run to completion? Maybe its slow for another reason. I have used duplicate database on Solaris many times with great success. Josh -Original Message- Sent: Monday, December 08, 2003 8:20 AM To: Multiple recipients of list ORACLE-L Dennis and all, I have no problem getting the controlfile... I just comment out the SET commands to change the directories of the dbfs...and I replicate the control according to the init file specifications.. So This operation actually extract the controlfile out of the backup piece so I know the location and connections are working fine. But since the controlfile is backup and I am restoring it with the same RMan command I think I should have no problem.. I know other DBAs.. run this same script and restore the database on another server with no problem if the controlfile is restored before the database is restored and recovered. Here is the restore controlfile script and resulting log file == Controlfile restore Script == connect catalog rman81740/[EMAIL PROTECTED] connect target / run { allocate channel d1 type disk ; sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; set until time = '2003-12-02 05:50:00'; #restore controlfile to '/u02/vssppln/restored_cf.ctl'; replicate controlfile from '/u02/vssppln/restored_cf.ctl'; release channel d1; } == Successful Controlfile restore log == Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 run 7 8 { 9 10 allocate channel d1 type disk ; 11 12 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 13 set until time = '2003-12-02 05:50:00'; 14 15 16 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 17 18 replicate controlfile from '/u02/vssppln/restored_cf.ctl'; 19 20 release channel d1; 21 } 22 23 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: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS RMAN-03023: executing command: sql RMAN-03022: compiling command: set RMAN-03022: compiling command: replicate RMAN-03023: executing command: replicate RMAN-08058: replicating controlfile RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1 Recovery Manager complete. = Here is the orignal entire script to restore controlfile and database but it just hangs on the set commands.. = == 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] 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=-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
Re: RMAN restore on another server
I did this exercise a few months ago and created some rough but detailed docs that you may find helpful. http://www.cybcon.com/~jkstill/Alternate_Client_Restore_With_Veritas_NetBackup_and_Oracle_RMAN.doc Jared On Fri, 2003-12-05 at 14:14, Spears, Brian wrote: 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] 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=-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
RE: RMAN restore on another server
Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4: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=-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
Re: RMAN restore on another server
How did you expect the restore to work w/o first restoring the controlfile? or am i missing something here? joe Spears, Brian wrote: *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=-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
RE: RMAN restore on another server
Title: Message By default RMAN restores the backup to the machine from where it is backedup. If you need to restore the backup on to alternate client, your netbackup admin has to setup the access. You have not mentioned whether you are using Netbackup or legato or something else. Once the access is set up, you can test it by connecting to rman target / catalog rman/[EMAIL PROTECTED] on the new machine ,and issuing the command list backup at RMAN prompt on the new machine. If you see the backups, you can restore the backup. If you are using NETBACKUP, use the var NB_ORA_CLIENT, If not substitute with the corresponding variable. Startup nomount; Run { Allocate channel t1 type 'sbt_tape' parms="ENV=(NB_ORA_CLIENT=backedupclient; export NB_ORA_CLIENT); Restore controlfile; Alter database mount; Restore database; Alter database open; } -- Janardhana -Original Message- From: Spears, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RMAN restore on another server 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 andgets to theRMAN-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] 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=-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
RE: RMAN restore on another server
Title: Message I am sorry, I thought you are restoring from Tape. In either case, you connect to target and catalog database on the new server and see if you can access the backups that were backed up on the original server. -- Janardhana -Original Message- From: Spears, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RMAN restore on another server 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 andgets to theRMAN-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] 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=-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 }
RE: RMAN restore on another server
Title: Message 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- From: Spears, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RMAN restore on another server 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 andgets to theRMAN-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] 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=-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
RE: RMAN restore on another server
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=-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