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