RE: RMAN Backup piece being placed in wrong directory

Thu, 07 Aug 2003 11:01:10 -0700

Title: Message
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-----
From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L
Subject: FW: RMAN Backup piece being placed in wrong directory

Robert? Dennis?  Anyone?
 
-----Original Message-----
From: Stefick Ronald S Contr ESC/HRIDD
Sent: Thursday, August 07, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RMAN Backup piece being placed in wrong directory

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]

Reply via email to