Shulou(Shulou.com)06/01 Report--

1. Create a database directory

two。 Copy the pfile file from the original host and change the oracle_sid

Vi .bash _ profilesource .bash _ profile

3. Boot data to nomount status

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

4. View backup controlfile list

/ usr/openv/netbackup/bin/bplist-S backup server-C backup client-t 4-s 09max 10max 2000-e 09max 11max 2000-R-l / in this command, the-s parameter is followed by the start date, and the-e parameter is followed by the end date, which indicates that the list of control files within the time period is obtained.

5. Restore controlfile Fil

$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'; # control file name from the previous step to get release channel a0 transition release channel A1;} RMAN > exit

Note: report an error here

RMAN-00571: = = RMAN-00569: = ERROR MESSAGE STACK FOLLOWS = RMAN-00571: = = RMAN-03009: failure of allocate command on a0 channel at 06x14 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 cause Copy libobk.so to cp / usr/openv/netbackup/bin/libobk.so64.1 / opt/oracle/product/9.2/lib/libobk.so under lib/ under oracle installation directory 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. Restore the database

$rman target / run {allocate channel a0 type 'sbt_tape';allocate channel A1 type' sbt_tape';allocate channel a2 type 'sbt_tape';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 opens the database

$sqlplus / as sysdbaSQL > alter database open resetlogs

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.