klo aku pake backup server / backup to tape ( dalam hal ini hp openview )
berikut scriptnya :
#!/bin/sh
# set limit channel d1 for limit backup piece into 500M each file
export ORACLE_SID=db1
export TARGET_CONN=/
export CATALOG_CONN=rman10g/r...@rmandb
# set ORACLE_HOME <must be set if using crontab>
export ORACLE_HOME=/u01/app/oracle/product/10.2.1/db_1
${ORACLE_HOME}/bin/rman target=${TARGET_CONN} catalog=${CATALOG_CONN} <<EOF
# connect target ${TARGET_CONN}
# connect catalog ${CATALOG_CONN}
# run backup
run{
allocate channel d1 type sbt_tape
PARMS='SBT_LIBRARY=/usr/omni/lib/libob2oracle8_64bit.so
ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=db1,OB2BARLIST=db1)' ;
allocate channel d2 type sbt_tape
PARMS='SBT_LIBRARY=/usr/omni/lib/libob2oracle8_64bit.so
ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=db2,OB2BARLIST=db2,OB2BARHOSTNAME=rac02.companydomain.co.id)'
connect 'sys_dba/x...@db2' ;
set limit channel d1 kbytes 502400;
set limit channel d2 kbytes 502400;
sql "alter system archive log current";
backup incremental level 0 tag openview_db_level0 format
'/sw/backup/rman/openview/rman_%d_%t_%U.bck' database ;
backup tag sunday_ctl format '/sw/backup/rman/openview/rman_ctl_%d_%t_%U.bck'
(current controlfile) ;
backup tag sunday_arc format '/sw/backup/rman/openview/rman_arch_%d_%t_%U.bck'
archivelog all delete input ;
release channel d1 ;
release channel d2 ;
}
kalau tidak menggunakan server backup atau backup to file maka scriptnya :
#!/bin/sh
# set limit channel d1 for limit backup piece into 500M each file
export ORACLE_SID=db1
export TARGET_CONN=/
export CATALOG_CONN=rman10g/r...@rmandb
# set ORACLE_HOME <must be set if using crontab>
export ORACLE_HOME=/u01/app/oracle/product/10.2.1/db_1
${ORACLE_HOME}/bin/rman target=${TARGET_CONN} catalog=${CATALOG_CONN} <<EOF
# connect target ${TARGET_CONN}
# connect catalog ${CATALOG_CONN}
# run backup
run{
allocate channel d1 type disk ;
allocate channel d2 type disk connect 'sys_dba/x...@db2' ;
set limit channel d1 kbytes 502400;
set limit channel d2 kbytes 502400;
sql "alter system archive log current";
backup incremental level 0 tag openview_db_level0 format
'/sw/backup/rman/sunday/rman_%d_%t_%U.bck' database ;
backup tag sunday_ctl format '/sw/backup/rman/sunday/rman_ctl_%d_%t_%U.bck'
(current controlfile) ;
backup tag sunday_arc format '/sw/backup/rman/sunday/rman_arch_%d_%t_%U.bck'
archivelog all delete input ;
release channel d1 ;
release channel d2 ;
}
--- In [email protected], Andes Febrian <pejanta...@...> wrote:
>
> Dear gurus,
>
> mohon sharing link atau ada yang punya script bagaimana cara untuk backup
> database RAC 2 node dengan ASM menggunakan rman ?
>
> Saya sudah backup database RAC dengan ASM menggunakan script rman yang biasa
> saya pake untuk backup database single instance dengan filesystem. jadi saya
> taruh script rman untuk backup database RAC tersebut di instance/node 1,
> backup database berjalan sukses.
> Ketika saya mau restore hasil RMAN tersebut di mesin baru dengan single
> instance dan menggunakan ASM storage, saya mendapatkan ternyata controlfile
> di restore ke filesystem mesin baru tersebut. jadi saya agak bingung untuk
> melakukan step berikut nya, yaitu alter database mount kemudian restore
> database dan recover.
>
> Mohon bantuan guru2 sekalian, Thanks.
>
> --
> Best Regards,
> Andes
>
>
> [Non-text portions of this message have been removed]
>
