Copying files from A to B is fine, but from B to A "kills" the server

[MCubitt]

Running AIX 5.1 on fairly powerful machine.

I have a script to copy large files from one area to another. This goes through steadily and without concern.

However, when I copy them back the entire server comes to a grinding halt.

I am not terribly technical (with UNIX) so any questions, please advise how to get the result!

The following is a disk allocation, I am copying from oracledata, oracleindex, oracle, redologs1, redologs2 and archive logs to ifsdoc.

Then back again.

          Filesystem 512-blocks      Free %Used     Iused %Iused Mounted on
            /dev/hd4     65536      30080  55%       2555    16% /
            /dev/hd2   8060928     440552  95%      69468     7% /usr
         /dev/hd9var     65536      17528  74%       1001    13% /var
            /dev/hd3    851968     789416   8%        330     1% /tmp
            /dev/hd1     65536      48944  26%        273     4% /home
               /proc         -          -    -          -      - /proc
        /dev/hd10opt     65536       3904  95%       1214    15% /opt
       /dev/redo1_lv  32768000   15755592  52%         59     1% /redolog1
       /dev/redo2_lv  32768000   19032760  42%         58     1% /redolog2
     /dev/archive_lv  65536000   63478832   4%         26     1% /archivelogs
     /dev/oradata_lv 170393600   45191152  74%        116     1% /oracledata
    /dev/oraindex_lv 170393600  115034720  33%         75     1% /oracleindex
      /dev/ifsdoc_lv 403701760  264880536  35%       4210     1% /ifsdoc
    /dev/oraclefs_lv  32768000   18731144  43%      78378     2% /oracle

Many thanks


Applications Support
UK

 

[KenCunningham]

Perhaps an obvious question, but you are closing the database down before doing the copy back?

 

[MCubitt]

Ken,

That's a fair question but yes, it is.

cheers


Applications Support
UK

 

[alexhu]

How are you copying - one at a time or parallel ?

Alex

 

[MCubitt]

Individually..

echo rm -fe /oracledata/IFSD/control01.ctl
echo rm -fe /oracledata/IFSD/control01.ctl >> /home/oracle/km/Backup/restoreIFSD.log
rm -fe /oracledata/IFSD/control01.ctl >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/control01.ctl /oracledata/IFSD/control01.ctl
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/control01.ctl /oracledata/IFSD/control01.ctl >> /home/oracle/km/Backup/restoreIFSD.log
#cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/control01.ctl /oracledata/IFSD/control01.ctl >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo rm -fe /oracledata/IFSD/control03.ctl
echo rm -fe /oracledata/IFSD/control03.ctl >> /home/oracle/km/Backup/restoreIFSD.log
rm -fe /oracledata/IFSD/control03.ctl >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/control03.ctl /oracledata/IFSD/control03.ctl
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/control03.ctl /oracledata/IFSD/control03.ctl >> /home/oracle/km/Backup/restoreIFSD.log
#cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/control03.ctl /oracledata/IFSD/control03.ctl >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_archive_data01.dbf /oracledata/IFSD/ifsapp_archive_data01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_archive_data01.dbf /oracledata/IFSD/ifsapp_archive_data01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_archive_data01.dbf /oracledata/IFSD/ifsapp_archive_data01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data01.dbf /oracledata/IFSD/ifsapp_data01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data01.dbf /oracledata/IFSD/ifsapp_data01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data01.dbf /oracledata/IFSD/ifsapp_data01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data02.dbf /oracledata/IFSD/ifsapp_data02.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data02.dbf /oracledata/IFSD/ifsapp_data02.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data02.dbf /oracledata/IFSD/ifsapp_data02.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data03.dbf /oracledata/IFSD/ifsapp_data03.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data03.dbf /oracledata/IFSD/ifsapp_data03.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data03.dbf /oracledata/IFSD/ifsapp_data03.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data04.dbf /oracledata/IFSD/ifsapp_data04.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data04.dbf /oracledata/IFSD/ifsapp_data04.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data04.dbf /oracledata/IFSD/ifsapp_data04.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data05.dbf /oracledata/IFSD/ifsapp_data05.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data05.dbf /oracledata/IFSD/ifsapp_data05.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data05.dbf /oracledata/IFSD/ifsapp_data05.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data06.dbf /oracledata/IFSD/ifsapp_data06.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data06.dbf /oracledata/IFSD/ifsapp_data06.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data06.dbf /oracledata/IFSD/ifsapp_data06.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data07.dbf /oracledata/IFSD/ifsapp_data07.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data07.dbf /oracledata/IFSD/ifsapp_data07.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data07.dbf /oracledata/IFSD/ifsapp_data07.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data08.dbf /oracledata/IFSD/ifsapp_data08.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data08.dbf /oracledata/IFSD/ifsapp_data08.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data08.dbf /oracledata/IFSD/ifsapp_data08.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data09.dbf /oracledata/IFSD/ifsapp_data09.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data09.dbf /oracledata/IFSD/ifsapp_data09.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data09.dbf /oracledata/IFSD/ifsapp_data09.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data10.dbf /oracledata/IFSD/ifsapp_data10.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data10.dbf /oracledata/IFSD/ifsapp_data10.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data10.dbf /oracledata/IFSD/ifsapp_data10.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data11.dbf /oracledata/IFSD/ifsapp_data11.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data11.dbf /oracledata/IFSD/ifsapp_data11.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_data11.dbf /oracledata/IFSD/ifsapp_data11.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_report_data01.dbf /oracledata/IFSD/ifsapp_report_data01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_report_data01.dbf /oracledata/IFSD/ifsapp_report_data01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/ifsapp_report_data01.dbf /oracledata/IFSD/ifsapp_report_data01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/oem_repository01.dbf /oracledata/IFSD/oem_repository01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/oem_repository01.dbf /oracledata/IFSD/oem_repository01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracledata/IFSD/oem_repository01.dbf /oracledata/IFSD/oem_repository01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo rm -fe /oracleindex/IFSD/control02.ctl
echo rm -fe /oracleindex/IFSD/control02.ctl >> /home/oracle/km/Backup/restoreIFSD.log
rm -fe /oracleindex/IFSD/control02.ctl >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/control02.ctl /oracleindex/IFSD/control02.ctl
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/control02.ctl /oracleindex/IFSD/control02.ctl >> /home/oracle/km/Backup/restoreIFSD.log
#cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/control02.ctl /oracleindex/IFSD/control02.ctl >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_archive_index01.dbf /oracleindex/IFSD/ifsapp_archive_index01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_archive_index01.dbf /oracleindex/IFSD/ifsapp_archive_index01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_archive_index01.dbf /oracleindex/IFSD/ifsapp_archive_index01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index01.dbf /oracleindex/IFSD/ifsapp_index01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index01.dbf /oracleindex/IFSD/ifsapp_index01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index01.dbf /oracleindex/IFSD/ifsapp_index01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index02.dbf /oracleindex/IFSD/ifsapp_index02.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index02.dbf /oracleindex/IFSD/ifsapp_index02.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index02.dbf /oracleindex/IFSD/ifsapp_index02.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index03.dbf /oracleindex/IFSD/ifsapp_index03.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index03.dbf /oracleindex/IFSD/ifsapp_index03.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index03.dbf /oracleindex/IFSD/ifsapp_index03.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index04.dbf /oracleindex/IFSD/ifsapp_index04.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index04.dbf /oracleindex/IFSD/ifsapp_index04.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index04.dbf /oracleindex/IFSD/ifsapp_index04.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index05.dbf /oracleindex/IFSD/ifsapp_index05.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index05.dbf /oracleindex/IFSD/ifsapp_index05.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index05.dbf /oracleindex/IFSD/ifsapp_index05.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index06.dbf /oracleindex/IFSD/ifsapp_index06.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index06.dbf /oracleindex/IFSD/ifsapp_index06.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_index06.dbf /oracleindex/IFSD/ifsapp_index06.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_report_index01.dbf /oracleindex/IFSD/ifsapp_report_index01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_report_index01.dbf /oracleindex/IFSD/ifsapp_report_index01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/ifsapp_report_index01.dbf /oracleindex/IFSD/ifsapp_report_index01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/users01.dbf /oracleindex/IFSD/users01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/users01.dbf /oracleindex/IFSD/users01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/oracleindex/IFSD/users01.dbf /oracleindex/IFSD/users01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo01.log /redolog1/IFSD/redo01.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo01.log /redolog1/IFSD/redo01.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo01.log /redolog1/IFSD/redo01.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo02.log /redolog1/IFSD/redo02.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo02.log /redolog1/IFSD/redo02.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo02.log /redolog1/IFSD/redo02.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo03.log /redolog1/IFSD/redo03.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo03.log /redolog1/IFSD/redo03.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo03.log /redolog1/IFSD/redo03.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo04.log /redolog1/IFSD/redo04.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo04.log /redolog1/IFSD/redo04.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo04.log /redolog1/IFSD/redo04.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo05.log /redolog1/IFSD/redo05.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo05.log /redolog1/IFSD/redo05.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/redo05.log /redolog1/IFSD/redo05.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/system01.dbf /redolog1/IFSD/system01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/system01.dbf /redolog1/IFSD/system01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog1/IFSD/system01.dbf /redolog1/IFSD/system01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo01a.log /redolog2/IFSD/redo01a.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo01a.log /redolog2/IFSD/redo01a.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo01a.log /redolog2/IFSD/redo01a.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo02a.log /redolog2/IFSD/redo02a.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo02a.log /redolog2/IFSD/redo02a.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo02a.log /redolog2/IFSD/redo02a.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo03a.log /redolog2/IFSD/redo03a.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo03a.log /redolog2/IFSD/redo03a.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo03a.log /redolog2/IFSD/redo03a.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo04a.log /redolog2/IFSD/redo04a.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo04a.log /redolog2/IFSD/redo04a.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo04a.log /redolog2/IFSD/redo04a.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo05a.log /redolog2/IFSD/redo05a.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo05a.log /redolog2/IFSD/redo05a.log >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/redo05a.log /redolog2/IFSD/redo05a.log >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/undotbs01.dbf /redolog2/IFSD/undotbs01.dbf
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/undotbs01.dbf /redolog2/IFSD/undotbs01.dbf >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/redolog2/IFSD/undotbs01.dbf /redolog2/IFSD/undotbs01.dbf >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/product/9.2.0.1.0/dbs/initIFSD.ora /oracle/app/oracle/product/9.2.0.1.0/dbs/initIFSD.ora
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/product/9.2.0.1.0/dbs/initIFSD.ora /oracle/app/oracle/product/9.2.0.1.0/dbs/initIFSD.ora >> /home/oracle/km/Backup/restoreIFSD.log
#cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/product/9.2.0.1.0/dbs/initIFSD.ora /oracle/app/oracle/product/9.2.0.1.0/dbs/initIFSD.ora >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/admin/IFSD/pfile/initIFSD.ora /oracle/app/oracle/admin/IFSD/pfile/initIFSD.ora
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/admin/IFSD/pfile/initIFSD.ora /oracle/app/oracle/admin/IFSD/pfile/initIFSD.ora >> /home/oracle/km/Backup/restoreIFSD.log
#cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/admin/IFSD/pfile/initIFSD.ora /oracle/app/oracle/admin/IFSD/pfile/initIFSD.ora >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/product/9.2.0.1.0/dbs/lkIFSD /oracle/app/oracle/product/9.2.0.1.0/dbs/lkIFSD
#echo cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/product/9.2.0.1.0/dbs/lkIFSD /oracle/app/oracle/product/9.2.0.1.0/dbs/lkIFSD >> /home/oracle/km/Backup/restoreIFSD.log
#cp -p /ifsdoc/Backuptest/BackupofIFSD/oracle/app/oracle/product/9.2.0.1.0/dbs/lkIFSD /oracle/app/oracle/product/9.2.0.1.0/dbs/lkIFSD >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/home/oracle/km/Backup/controlIFSD.sql /home/oracle/km/Backup/controlIFSD.sql
echo cp -p /ifsdoc/Backuptest/BackupofIFSD/home/oracle/km/Backup/controlIFSD.sql /home/oracle/km/Backup/controlIFSD.sql >> /home/oracle/km/Backup/restoreIFSD.log
cp -p /ifsdoc/Backuptest/BackupofIFSD/home/oracle/km/Backup/controlIFSD.sql /home/oracle/km/Backup/controlIFSD.sql >> /home/oracle/km/Backup/restoreIFSD.log 2>> /home/oracle/km/Backup/restoreIFSD.log

That's my restore script.



Applications Support
UK

 

[letis]

hello,

my turn to ask a question )
do you have any entries in the AIX error log which could be related to the copy operation ?

errpt | more for a summary, errpt -a | more for a detailed report.


regards,

 

[MCubitt]

Hi Letis,

There are no reported errors at the time of the copy.

The UNIX server has 6 Oracle Databases loaded on it, I shut one down while I copy the files back to it. It's users of the other DBs that suffer.

It's not like a slight drop in performance, the server almost stops!




Applications Support
UK

 

[MCubitt]

One notable difference between the copy from and the copy back, is that the copy from is to a blank aream whereas the copy back overwrites existing files.

I can change my script to remove existing files first, as a test?

I appreciate overwriting existing files would be a longer operation, perhaps, checking permissions, links, etc.


Applications Support
UK

 

[MCubitt]

Well, removing the files first did not work. Within 10 seconds of starting the copy back, I received a call that the system had died.





Applications Support
UK

 

[kierong]

Hi

I'm thinking your backups work fine because /ifsdoc is probably on seperate disks than the databases. When restoring a database the sustained writes to the database disks will have a great impact on the response time to the other databases, particularly if all the databases share the same disks. Maybe you should consider relocating some of the databases across specific series to disks to isolate the impact when doing restores.


Just some thoughts.

Kieron

 

[RodKnowlton]

I agree with kierong.

It would be especially bad if all the filesystems concerned are built on RAID-5 arrays. With your backup, the limiting factor would be the write speed of /ifsdoc, so the long sequential reads of the oracle files wouldn't have much impact on the other databases. On the restore, /ifsdoc could be read faster than the oracle files could be written, saturating the oracle disks with writes and killing overall performance of anything else using the same array.

Rod Knowlton
IBM Certified Advanced Technical Expert pSeries and AIX 5L
CompTIA Linux+
CompTIA Security+

 

[MCubitt]

Kieron/Rod,

Thank you for your suggestion and apologies for my delay in responding.

It would appear to make sense, writing to disk obviously has a higher overheard (so reading from for the copy has less affect).

I believe the disk is mirrored, but unsure if ifsdoc is. Assuming it is not, this is clearly part of my problem.

Unfortunately by the nature of what I am doing (restoring backup files to an Oracle database) it is not really an option for me to copy them elsewhere.

I know this is going to sound stupid (probably!) but is there a way to copy back "slowly"?







Applications Support
UK