Seeking help with RMAN
- From: "William Wagman" <wjwagman@xxxxxxxxxxx>
- To: "freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 2 Jul 2007 16:08:32 -0700
Greetings,
I am running Oracle 9.2.0.8.0 on Solaris 9. I am working on a set of
scripts to automate cloning of my production database to a second
server. The cloning is to give developers a playground. I have gotten
part way through the process. RMAN backup pieces and archived redo logs
are copied nightly to the second server and the restore script runs to a
point and that is where I am stuck, I'm sure do to my lack of
understanding of RMAN. On the second server the script I run to clone
the database is called from a shell script and...
connect target sys/pwd@pinnacle
connect auxiliary sys/pwd@pinnacle_stage
connect catalog rmanusr/pwd@cr04_rmancat
run {
# set until time = "to_date(to_char(sysdate, 'yyyymmdd') || ' 02:00',
'YYYYMMDD HH24:MI')";
set until time "to_date('2007-06-28 00:10:00','YYYY-MM-DD:HH24:MI:SS')";
configure auxname for datafile 1 to
'/u02/oracle/pinnstag/o1_mf_system_zbclfwvx_.dbf';
.
.
.
configure auxname for datafile 10 to
'/u02/oracle/pinnstag/o1_mf_data_ts_2nyz8qb8_.dbf';
duplicate target database to 'pinnstag'
pfile=/home/oracle/920/dbs/initpinnstag.ora
logfile
'/u02/oracle/pinnstag/o1_mf_1_zbcl9op4_.log' SIZE 250M,
'/u02/oracle/pinnstag/o1_mf_2_zbclbjcc_.log' SIZE 250M,
'/u02/oracle/pinnstag/o1_mf_3_zbclccfn_.log' SIZE 250M,
'/u02/oracle/pinnstag/o1_mf_4_zbcld65j_.log' SIZE 250M,
'/u02/oracle/pinnstag/o1_mf_5_zbclf0lc_.log' SIZE 250M;
}
Exit
The time in the set until time is some point after the backups are
completed. The log looks like this...
printing stored script: Memory Script
{
set until time "to_date('2007-06-28
00:10:00','YYYY-MM-DD:HH24:MI:SS')";
recover
clone database
delete archivelog
;
}
executing script: Memory Script
executing command: SET until clause
Starting recover at 2007-06-28:11:43:51
using channel ORA_AUX_DISK_1
starting media recovery
archive log thread 1 sequence 7715 is already on disk as file
/u02/ora_bkp/pinnacle/arch0000007715.arc
archive log thread 1 sequence 7716 is already on disk as file
/u02/ora_bkp/pinnacle/arch0000007716.arc
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01194: file 4 needs more recovery to be consistent
ORA-01110: data file 4:
'/u02/oracle/pinnstag/o1_mf_indexes_zbcm8zx4_.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/28/2007 11:43:52
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 7717 scn 3110146550330 found
to restore
I can do this...
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 3110146012833 generated at 06/27/2007 22:00:06 needed
for
thread 1
ORA-00289: suggestion : /u02/ora_bkp/pinnacle/arch0000007715.arc
ORA-00280: change 3110146012833 for thread 1 is in sequence #7715
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
Database altered.
I am puzzled as to what I must do to get this to work without manual
intervention. I'd appreciate any suggestions.
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
--
//www.freelists.org/webpage/oracle-l
Other related posts:
