Re: Unix Shell Script Help
- From: Mayen.Shah@xxxxxxxxxx
- To: m.haddon@xxxxxxxxx
- Date: Sun, 15 Feb 2009 15:52:37 -0500
Thanks for your comments, Mike.
I was responding to OP's requirement of how to "CANCEL" recovery. In old
days when I was cloning database outside of RMAN, I was using combination
of AUTO and CANCEL to perform recovery upto last available arch log.
#!/usr/bin/ksh
#
$ORACLE_HOME/bin/sqlplus -s /nolog <<eof1
connect /as sysdba;
startup mount;
RECOVER database using backup controlfile;
auto
exit 0;
eof1
echo "database recovered with available arch logs"
$ORACLE_HOME/bin/sqlplus -s /nolog <<eof2
connect /as sysdba;
RECOVER database using backup controlfile until cancel;
cancel
exit 0;
eof2
echo "database recovered with CANCEL"
$ORACLE_HOME/bin/sqlplus -s /nolog <<eof3
WHENEVER SQLERROR EXIT 1;
connect /as sysdba;
alter database open resetlogs;
exit 0;
eof3
Thanks
Mayen
"Mike Haddon" <m.haddon@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Feb 13 2009 06:47 PM
Please respond to
m.haddon@xxxxxxxxx
To
"oracle-l" <oracle-l@xxxxxxxxxxxxx>
cc
Subject
Re: Unix Shell Script Help
That will cancel before applying any archives
Mike
Mayen.Shah@xxxxxxxxxx wrote:
#!/usr/bin/ksh
#
$ORACLE_HOME/bin/sqlplus -s /nolog <<eof1
connect /as sysdba;
RECOVER database using backup controlfile until cancel;
cancel
exit 0;
eof1
HTH
Mayen
"Bala" <oratips@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Feb 12 2009 11:17 PM
Please respond to
oratips@xxxxxxxxx
To
"oracle-l" <oracle-l@xxxxxxxxxxxxx>
cc
Subject
Unix Shell Script Help
How do i supply "Cancel" in a Unix Shell script after the SQLPLUS command
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
any tips/ suggestions highly appreciated.
Thanks in Advance
( Hot backup, HP unix, Oracle 10.2.0.4)
--
Bala Rao
Other related posts:
