RE: Recover after rman restore asks for a VERY OLD archive log
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: <peter.schauss@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Oct 2007 07:22:12 -0600
Where did you source your control file from? How did you recover it?
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
BLOG: http://robertgfreeman.blogspot.com/
Sig V1.2
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Schauss, Peter
Sent: Monday, October 08, 2007 10:57 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Recover after rman restore asks for a VERY OLD archive log
Thanks for all of the suggestions. My original recovery script was:
export ORACLE_SID=dbname
export NLS_DATE_FORMAT='DD-MON-YYYY hh24:mi:ss'
export NLS_LANG='american_america.WE8MSWIN1252'
rman target $1/$2 nocatalog <<EOF
startup mount;
run{
set until time='24-APR-2007 22:55:00';
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
allocate channel ch5 type disk;
allocate channel ch6 type disk;
restore database;
}
exit
EOF
For whatever reason, this script worked for my 8.1.7.4 databases. I
removed the NLS_DATE_FORMAT, NLS_LANG, and "set until time" statements
and the "recover database..." command asked for the archive log that I
was expecting. The database is up and running.
Thanks again for the quick responses.
Peter Schauss
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Schauss, Peter
Sent: Monday, October 08, 2007 11:22 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Recover after rman restore asks for a VERY OLD archive log
This is Oracle 10.2.0.2 on HP-UX B.11.23.
I have an rman backup which was done in "nocatalog mode" and am
attempting to restore this database on another server. The backup was
done three days ago. I put the control files, int.ora, and password
files where the database expected them to be and used the following
script to restore:
#!/bin/ksh
#
export ORACLE_SID=peregrine
rman target sys/password nocatalog <<EOF
startup mount pfile='/opt/oracle/admin/dbname/pfile/initdbname.ora';
run{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
allocate channel ch5 type disk;
allocate channel ch6 type disk;
restore database;
}
exit
EOF
The script runs without errors, but when I give the command:
> recover database until cancel using backup controlfile;
It asks me for an archive log which was created back in March when I
first created the database.
What is going on here?
Thanks,
Peter Schauss
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
