RMAN Restore problem

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Wed, 10 Jul 2002 10:23:31 -0800
Message-ID: <F001.00493E7E.20020710102331@fatcity.com>

Greetings,  

I am trying to restore a database into a new host.  

The database called dsdn is originally located on dndev, catalog database is located on catserver1.  

I have copied the catalog to a database called trmanrfd, which is also located on the new host server2.  

Now I am trying to restore this database into a new host called server2.  

It is taking 6-7 hours to restore. Ideally it should take few mintes(may be 30 mts.).  

Do you have any idea, what could be the problem for slowness.  

Thanks,
Ashoke    

Running the following scripts on the new host server2. rman target rman_main/test \

     rcvcat rman_restore/rman_restore_at_trmanrfd.xxx.com \
     cmdfile $ORACLE_HOME/scripts/restore/dsdn/dsdn_newhost_on \
     msglog $ORACLE_HOME/scripts/restore/log/dsdn_newhost_on.log \
     append

run {
        allocate channel t1 type 'SBT_TAPE'
        parms 'ENV=(NSR_SERVER=denali.xxx.com, NSR_CLIENT=dndev.xxx.com)';
        allocate channel t2 type 'SBT_TAPE'
        parms 'ENV=(NSR_SERVER=denali.xxx.com, NSR_CLIENT=dndev.xxx.com)';
        allocate channel t3 type 'SBT_TAPE'
        parms 'ENV=(NSR_SERVER=denali.xxx.com, NSR_CLIENT=dndev.xxx.com)';
        allocate channel t4 type 'SBT_TAPE'
        parms 'ENV=(NSR_SERVER=denali.xxx.com, NSR_CLIENT=dndev.xxx.com)';
 
        set until time = 'JUL 08 2002 10:22:28';
 
        restore controlfile to '/u02/oradata/dsdn/control01.ctl';
 
        replicate controlfile from '/u02/oradata/dsdn/control01.ctl';
 
        sql 'alter database mount';
 
        set newname for datafile 1 to '/u02/oradata/dsdn/system01.dbf';
        set newname for datafile 2 to '/u02/oradata/dsdn/rollback01.dbf';
        set newname for datafile 3 to '/u02/oradata/dsdn/temp01.dbf';
        set newname for datafile 4 to '/u02/oradata/dsdn/users01.dbf';
        set newname for datafile 5 to '/u02/oradata/dsdn/tools01.dbf';
        set newname for datafile 6 to '/u02/oradata/dsdn/inv_data01.dbf';
        set newname for datafile 7 to '/u02/oradata/dsdn/inv_index01.dbf';
        set newname for datafile 8 to '/u02/oradata/dsdn/inv_data_2_01.dbf';
        set newname for datafile 9 to '/u02/oradata/dsdn/inv_index_2_01.dbf';
        set newname for datafile 10 to '/u02/oradata/dsdn/asset_mgmt_dat01.dbf';
        set newname for datafile 11 to '/u02/oradata/dsdn/asset_mgmt_idx01.dbf';
        set newname for datafile 12 to '/u02/oradata/dsdn/asset_mgmt_hist_dat01.dbf';
        set newname for datafile 13 to '/u02/oradata/dsdn/asset_mgmt_hist_idx01.dbf';
 
        restore database;
        switch datafile all;
        recover database;

}

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mandal, Ashoke
  INET: ashoke.k.mandal_at_medtronic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Wed Jul 10 2002 - 13:23:31 CDT