Friday, 22 February 2013

Application Clone Automation Script

Modify Pfile:

bash-3.2$ cat modify_initfile.sh
. ORA.env

#change to dbs directory
cd ${oracle_home}/dbs

cp -f init${oracle_sid}.ora init${oracle_sid}.ora_bkp

sed  's,^\(.*db_name.*\)$,\#\1,g'  init${oracle_sid}.ora_bkp > init${oracle_sid}.ora
echo "*.db_name='PROD'" >> init${oracle_sid}.ora

diff init${oracle_sid}.ora_bkp init${oracle_sid}.ora
bash-3.2$ sh modify_initfile.sh
36c36
< *.db_name='PFCUKRUN'
---
> #*.db_name='PFCUKRUN'
83a84
> *.db_name='PROD'
bash-3.2$


Restore Control file and Mount Database

bash-3.2$ cat create_controlfile.sh
. ORA.env

rman target / log=$log_home/create_controlfile.log << EOF
run {
startup nomount pfile="${oracle_home}/dbs/init${oracle_sid}.ora"
restore controlfile from "${ctrl_file}";
alter database mount;

}
exit
EOF

No comments:

Post a Comment