Friday 20 January 2023

Netbackup RMAN backup restore

cd $ORACLE_HOME/lib

ln -s /usr/openv/netbackup/bin/libobk.so64 ./libobk.so



 RUN 

{

startup force mount;

set until time="to_date('18012023 10:00:00','ddmmyyyy hh24:mi:ss')";

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch04 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch05 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

restore database;

recover database;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

alter database open resetlogs;

}


No comments:

Post a Comment

Number of Visitors