Seeking help with RMAN

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Mon, 2 Jul 2007 16:08:32 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A033E9489@VEXBE2.ex.ad3.ucdavis.edu>

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_at_pinnacle
connect auxiliary sys/pwd_at_pinnacle_stage connect catalog rmanusr/pwd_at_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_at_ucdavis.edu
(530) 754-6208

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 02 2007 - 18:08:32 CDT