RMAN Restore problem

[Mandal, Ashoke]

Title: converting fmt to fmb

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 [EMAIL PROTECTED] \
     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;
}