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

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

RE: RMAN Backup piece being placed in wrong directory

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Thu, 07 Aug 2003 12:04:24 -0800
Message-ID: <F001.005C9821.20030807120424@fatcity.com> 





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:Ronald.Stefick_at_RANDOLPH.AF.MIL]


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 


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: Freeman Robert - IL
  INET: FREEMANR_at_tusc.com

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 - 15:04:24 CDT












Original text of this message













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