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';
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';