Rman restores Oracle database with NetBackup redirection

1. Create a database directory

2. Copy the Pfile file from the original host and change the ORACLE_SID

Vi. Bash_profilesource. Bash_profile

3. Start data to Nomount status

$ sqlplus/as sysdbasql> startup nomount pfile= ' pfile file absolute location '; ORACLE instance started. Sql> exit

4. View the backup Controlfile list

$/usr/openv/netbackup/bin/bplist-s Backup Server-c backup client-T 4-s 09/10/2000-e 09/11/2000-r-L/the-s parameter in the command is followed by the start date, the-e parameter to the end date, indicating the Take a list of control files for that time period

5. Recover Controlfile Files

$ Rman Target/rman>run{allocate Channel A0 type ' sbt_tape '; allocate channel A1 type ' sbt_tape '; send ' nb_ora_serv= backup server   , nb_ora_client= backup client '; restore Controlfile from ' cntrl_xxx_x_xxxxxxxxx '; #控制文件名由上一步骤中得到release Channel a0;release channel A1;} Rman> exit

Note: The error is here

RMAN-00571: ===========================================================rman-00569: =============== ERROR MESSAGE STACK follows ===============rman-00571: ===========================================================rman-03009:  Failure of allocate command on A0 channel at 06/14/2011 11:45:03ora-19554:error allocating device, device Type:sbt_tape, Device name:ora-27211:failed to load Media Management libraryrace file found no libobk.so caused, copy libobk.so to lib/under the Oracle installation directory CP/ Usr/openv/netbackup/bin/libobk.so64.1/opt/oracle/product/9.2/lib/libobk.so or make a soft link ln-s/usr/openv/netbackup/bin /libobk.so64/opt/oracle/product/9.2/lib/libobk.so

6. Start the database to Mount state

$ sqlplus/as sysdbasql> ALTER DATABASE mount;database altered. Sql> exit

7. Recovering a Database

$ Rman Target/run{allocate Channel A0 type ' sbt_tape '; allocate channel A1 type ' Sbt_tape '; allocate channel A2 type ' sbt_t Ape '; Allocate channel A3 type ' Sbt_tape '; send ' nb_ora_serv= backup server, nb_ora_client= backup client '; restore Database;recover Database;release Channel A0;release channel a1;release channel a2;release channel A3;}

8.Reset Log Open Database

$ sqlplus/as sysdbasql> ALTER DATABASE open resetlogs;

This article is from the "Hello World" blog, so be sure to keep this source http://nxyboy.blog.51cto.com/10511646/1940710

Rman restores Oracle database with NetBackup redirection