Good point Tom.... RF
-----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 1:29 PM Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -----Original Message----- [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Robert? Dennis? Anyone? -----Original Message----- Sent: Thursday, August 07, 2003 9:24 AM To: Multiple recipients of list ORACLE-L OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{ set archivelog destination to 'D:\backup\oracle\Hotbackup'; set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak'; backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; } Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=4 recid=2 stamp=500738572 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting archive log backupset channel ORA_DISK_2: specifying archive log(s) in backup set input archive log thread=1 sequence=5 recid=1 stamp=500738568 input archive log thread=1 sequence=6 recid=3 stamp=500738573 input archive log thread=1 sequence=7 recid=4 stamp=500738574 input archive log thread=1 sequence=8 recid=5 stamp=500815654 input archive log thread=1 sequence=9 recid=6 stamp=500824391 input archive log thread=1 sequence=10 recid=7 stamp=501340112 channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting archive log backupset channel ORA_DISK_3: specifying archive log(s) in backup set input archive log thread=1 sequence=11 recid=8 stamp=501343673 input archive log thread=1 sequence=12 recid=9 stamp=501343804 input archive log thread=1 sequence=13 recid=10 stamp=501347437 input archive log thread=1 sequence=14 recid=11 stamp=501347562 input archive log thread=1 sequence=15 recid=12 stamp=501407160 input archive log thread=1 sequence=16 recid=13 stamp=501407288 channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=17 recid=14 stamp=501407709 input archive log thread=1 sequence=18 recid=15 stamp=501407832 input archive log thread=1 sequence=19 recid=16 stamp=501407991 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00002 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF input datafile fno=00003 name=D:\ORACLE\EWFMS\CWMLITE01.DBF channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting full datafile backupset channel ORA_DISK_2: specifying datafile(s) in backupset input datafile fno=00008 name=D:\ORACLE\EWFMS\XDB01.DBF input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF input datafile fno=00009 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF input datafile fno=00006 name=D:\ORACLE\EWFMS\TOOLS01.DBF channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting full datafile backupset channel ORA_DISK_3: specifying datafile(s) in backupset input datafile fno=00001 name=D:\ORACLE\EWFMS\SYSTEM01.DBF input datafile fno=00004 name=D:\ORACLE\EWFMS\DRSYS01.DBF input datafile fno=00005 name=D:\ORACLE\EWFMS\INDX01.DBF input datafile fno=00007 name=D:\ORACLE\EWFMS\USERS01.DBF channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1FEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:46 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1EEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:41 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1GEU5O8D_1 _1.BAK comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:01:41 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=20 recid=17 stamp=501408115 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1HEU5OBJ_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 07-AUG-03 Starting Control File and SPFILE Autobackup at 07-AUG-03 piece handle=D:\BACKUP\ORACLE\HOTBACKUP\CF_C-1770609602-20030807-02.BAK co mment=NONE Finished Control File and SPFILE Autobackup at 07-AUG-03 RMAN> Thanks in Advance, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
