Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN Backup piece being placed in wrong directory

RMAN Backup piece being placed in wrong directory

From: Stefick Ronald S Contr ESC/HRIDD <Ronald.Stefick_at_RANDOLPH.AF.MIL>
Date: Thu, 07 Aug 2003 06:24:23 -0800
Message-ID: <F001.005C9752.20030807062423@fatcity.com>


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
scott.stefick_at_randolph.af.mil <mailto:scott.stefick_at_randolph.af.mil>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefick Ronald S Contr ESC/HRIDD
  INET: Ronald.Stefick_at_RANDOLPH.AF.MIL

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: ListGuru_at_fatcity.com (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).
Received on Thu Aug 07 2003 - 09:24:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US