NBU SAN 异机恢复ORACLE

 

0. touch a file for NBU redirect restore, /usr/openv/netbackup/db/altnames/No.Restrictions
1. add client entry in <server name> /etc/hosts
2. add server entry in <client name> /etc/hosts
3. edit /usr/openv/netbackup/bp.conf
        SERVER = <server name>
        CLIENT_NAME = <backup source client name>
4. run /usr/openv/netbackup/bin/bpclntcmd -pn
        expecting response from server <server name>
        <client name> *NULL* 172.16.35.110 32790
5. cp /usr/openv/netbackup/bin/libobk.so64.1 $ORACLE_HOME/lib/libobk.so
        NOTE:if there is 8i, You must backup old libobk.so file before
6. chown oracle:dba /export/oracle/product/lib/libobk.so
7. create restore.sh scripts
        scripts samples:/usr/openv/netbackup/ext/db_ext/oracle/samples/rman
8. restore file
        ~/.profile or recreate
        $ORACLE_HOME/dbs/initPROD.ora
        $ORACLE_HOME/dbs/orapwPROD
        $ORACLE_HOME/dbs/spfilePROD.ora
        $ORACLE_HOME/network/admin/listener.ora
9. look up file /export/oracle/product/dbs/initPROD.ora to determine control file path
mkdir
        /export/oracle/admin/PROD/udump
        /export/oracle/admin/PROD/bdump
        /export/home1/archive
10. restore control file /export/home2/backup/ctl_PROD_20040719.bak
11. copy control file to destination
cp ./ctl_PROD_20040719.bak /export/oracle/oradata/control01.ctl
cp ./ctl_PROD_20040719.bak /export/home1/oradata/control02.ctl
cp ./ctl_PROD_20040719.bak /export/home2/oradata/control03.ctl
12. startup mount
13. check datafile path and mkdir needed path
        /export/home1/redolog
        /export/home2/redolog
        /export/oracle/oradata
        /export/home1/oradata
        /export/home2/oradata
14. begin restore database using scripts
15. restore archive log file
16. restart database to mount status
17. SQL> recover database until cancel using backup controlfile;
18. SQL> alter database open resetlogs;


example rename datafile:
        alter database rename file '/u01/app/oracle/oradata/orcl/system01.dbf' to '/u02/oradata/orcl/system01.dbf';

 

 

from：http://bbs2.chinaunix.net/thread-1408249-1-4.html