Home » RDBMS Server » Backup & Recovery » Changing backup location in RMAN backups (9i,windows 2003 server)
Changing backup location in RMAN backups [message #322622] Sun, 25 May 2008 05:16 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi All,
I have devised an RMAN strategy for a database which is around 125 gb size. i have decided to use RMAN incremental backups. I tested my script which is,
RUN
{
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
ALLOCATE CHANNEL C1 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C2 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL C3 DEVICE TYPE DISK MAXPIECESIZE 100M
format 'C:\RMANBKP\%U';
BACKUP INCREMENTAL LEVEL 0 DATABASE TAG Weekly_Friday_0_Hotpsms_bkp;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
ALLOCATE CHANNEL B1 DEVICE TYPE DISK MAXPIECESIZE 100M;
ALLOCATE CHANNEL B2 DEVICE TYPE DISK MAXPIECESIZE 100M
format 'C:\RMANBKP\%U';
BACKUP DATABASE ARCHIVELOG ALL DELETE ALL INPUT TAG Weekly_Friday_0_Hotpsms_bkp;
BACKUP VALIDATE DATABASE;
BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
}

whenever i run the above script, the backups are taken to 'C:\RMANBKP\%U' as specified in FORMAT command and in addition backups are also taken to the default location 'D:\oracle\ora92\database\%U'

But , i want the backups to be taken to 'C:\RMANBKP\%U' alone...pls give me a solution

thank you ,
Arun
Re: Changing backup location in RMAN backups [message #322624 is a reply to message #322622] Sun, 25 May 2008 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Add location in all your channels (see C3).

Regards
Michel
Re: Changing backup location in RMAN backups [message #322626 is a reply to message #322624] Sun, 25 May 2008 06:13 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi Michel,
thank you for the tip now its working fine except for an error

The formatted script is (as per your tip):
RUN
{
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
ALLOCATE CHANNEL C1 DEVICE TYPE DISK MAXPIECESIZE 100M format 'C:\RMANBKP\%U';
ALLOCATE CHANNEL C2 DEVICE TYPE DISK MAXPIECESIZE 100M format 'C:\RMANBKP\%U';
ALLOCATE CHANNEL C3 DEVICE TYPE DISK MAXPIECESIZE 100M format 'C:\RMANBKP\%U';
BACKUP INCREMENTAL LEVEL 0 DATABASE TAG Weekly_Friday_0_Hotpsms_bkp;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
ALLOCATE CHANNEL B1 DEVICE TYPE DISK MAXPIECESIZE 100M format 'C:\RMANBKP\%U';
ALLOCATE CHANNEL B2 DEVICE TYPE DISK MAXPIECESIZE 100M format 'C:\RMANBKP\%U';
BACKUP DATABASE ARCHIVELOG ALL DELETE ALL INPUT TAG Weekly_Friday_0_Hotpsms_bkp;
BACKUP VALIDATE DATABASE;
BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
}

when above was executed i get,



RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
no obsolete backups found

using channel ORA_DISK_1

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=15 devtype=DISK
specification does not match any archive log in the recovery catalog

using channel ORA_DISK_1

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=15 devtype=DISK
specification does not match any archive log in the recovery catalog

released channel: ORA_DISK_1
allocated channel: C1
channel C1: sid=15 devtype=DISK

allocated channel: C2
channel C2: sid=18 devtype=DISK

allocated channel: C3
channel C3: sid=19 devtype=DISK

Starting backup at 25-MAY-08
channel C1: starting incremental level 0 datafile backupset
channel C1: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLE\ORADATA\ARUN\EXAMPLE01.DBF
input datafile fno=00010 name=D:\ORACLE\ORADATA\ARUN\XDB01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\ARUN\INDX01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\ARUN\CWMLITE01.DBF
channel C1: starting piece 1 at 25-MAY-08
channel C2: starting incremental level 0 datafile backupset
channel C2: specifying datafile(s) in backupset
input datafile fno=00002 name=D:\ORACLE\ORADATA\ARUN\UNDOTBS01.DBF
input datafile fno=00009 name=D:\ORACLE\ORADATA\ARUN\USERS01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\ARUN\DRSYS01.DBF
input datafile fno=00007 name=D:\ORACLE\ORADATA\ARUN\ODM01.DBF
channel C2: starting piece 1 at 25-MAY-08
channel C3: starting incremental level 0 datafile backupset
channel C3: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\ARUN\SYSTEM01.DBF
input datafile fno=00008 name=D:\ORACLE\ORADATA\ARUN\TOOLS01.DBF
channel C3: starting piece 1 at 25-MAY-08
channel C1: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4IJH97CT_1_1 comment=NONE
channel C1: starting piece 2 at 25-MAY-08
channel C2: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4JJH97CT_1_1 comment=NONE
channel C2: backup set complete, elapsed time: 00:00:22
channel C1: finished piece 2 at 25-MAY-08
piece handle=C:\RMANBKP\4IJH97CT_2_1 comment=NONE
channel C1: backup set complete, elapsed time: 00:00:30
channel C3: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4KJH97D3_1_1 comment=NONE
channel C3: starting piece 2 at 25-MAY-08
channel C3: finished piece 2 at 25-MAY-08
piece handle=C:\RMANBKP\4KJH97D3_2_1 comment=NONE
channel C3: starting piece 3 at 25-MAY-08
channel C3: finished piece 3 at 25-MAY-08
piece handle=C:\RMANBKP\4KJH97D3_3_1 comment=NONE
channel C3: starting piece 4 at 25-MAY-08
channel C3: finished piece 4 at 25-MAY-08
piece handle=C:\RMANBKP\4KJH97D3_4_1 comment=NONE
channel C3: backup set complete, elapsed time: 00:00:49
Finished backup at 25-MAY-08

Starting Control File and SPFILE Autobackup at 25-MAY-08
piece handle=C:\RMANBKP\C-898546274-20080525-17 comment=NONE
Finished Control File and SPFILE Autobackup at 25-MAY-08

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

allocated channel: B1
channel B1: sid=20 devtype=DISK

allocated channel: B2
channel B2: sid=21 devtype=DISK

Starting backup at 25-MAY-08
channel C1: starting full datafile backupset
channel C1: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\ORADATA\ARUN\INDX01.DBF
input datafile fno=00009 name=D:\ORACLE\ORADATA\ARUN\USERS01.DBF
channel C1: starting piece 1 at 25-MAY-08
channel C2: starting full datafile backupset
channel C2: specifying datafile(s) in backupset
input datafile fno=00010 name=D:\ORACLE\ORADATA\ARUN\XDB01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\ARUN\CWMLITE01.DBF
channel C2: starting piece 1 at 25-MAY-08
channel C3: starting full datafile backupset
channel C3: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLE\ORADATA\ARUN\EXAMPLE01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\ARUN\DRSYS01.DBF
channel C3: starting piece 1 at 25-MAY-08
channel B1: starting full datafile backupset
channel B1: specifying datafile(s) in backupset
input datafile fno=00002 name=D:\ORACLE\ORADATA\ARUN\UNDOTBS01.DBF
input datafile fno=00007 name=D:\ORACLE\ORADATA\ARUN\ODM01.DBF
channel B1: starting piece 1 at 25-MAY-08
channel B2: starting full datafile backupset
channel B2: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\ARUN\SYSTEM01.DBF
input datafile fno=00008 name=D:\ORACLE\ORADATA\ARUN\TOOLS01.DBF
channel B2: starting piece 1 at 25-MAY-08
channel C1: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4MJH97EQ_1_1 comment=NONE
channel C1: backup set complete, elapsed time: 00:00:16
channel C2: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4NJH97EQ_1_1 comment=NONE
channel C2: backup set complete, elapsed time: 00:00:16
channel C1: starting archive log backupset
channel C1: specifying archive log(s) in backup set
input archive log thread=1 sequence=68 recid=67 stamp=655662550
channel C1: starting piece 1 at 25-MAY-08
channel C3: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4OJH97ES_1_1 comment=NONE
channel C3: starting piece 2 at 25-MAY-08
channel B1: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4PJH97EU_1_1 comment=NONE
channel B1: backup set complete, elapsed time: 00:00:19
channel C1: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4RJH97FC_1_1 comment=NONE
channel C1: backup set complete, elapsed time: 00:00:09
channel C1: deleting archive log(s)
archive log filename=D:\ORACLE\ORA92\RDBMS\ARC00068.001 recid=67 stamp=655662550
channel B2: finished piece 1 at 25-MAY-08
piece handle=C:\RMANBKP\4QJH97F1_1_1 comment=NONE
channel B2: starting piece 2 at 25-MAY-08
channel C3: finished piece 2 at 25-MAY-08
piece handle=C:\RMANBKP\4OJH97ES_2_1 comment=NONE
channel C3: backup set complete, elapsed time: 00:00:28
channel B2: finished piece 2 at 25-MAY-08
piece handle=C:\RMANBKP\4QJH97F1_2_1 comment=NONE
channel B2: starting piece 3 at 25-MAY-08
channel B2: finished piece 3 at 25-MAY-08
piece handle=C:\RMANBKP\4QJH97F1_3_1 comment=NONE
channel B2: starting piece 4 at 25-MAY-08
channel B2: finished piece 4 at 25-MAY-08
piece handle=C:\RMANBKP\4QJH97F1_4_1 comment=NONE
channel B2: backup set complete, elapsed time: 00:00:48
Finished backup at 25-MAY-08

Starting Control File and SPFILE Autobackup at 25-MAY-08
piece handle=C:\RMANBKP\C-898546274-20080525-18 comment=NONE
Finished Control File and SPFILE Autobackup at 25-MAY-08

Starting backup at 25-MAY-08
channel C1: starting full datafile backupset
channel C1: specifying datafile(s) in backupset
input datafile fno=00006 name=D:\ORACLE\ORADATA\ARUN\INDX01.DBF
input datafile fno=00009 name=D:\ORACLE\ORADATA\ARUN\USERS01.DBF
channel C2: starting full datafile backupset
channel C2: specifying datafile(s) in backupset
input datafile fno=00010 name=D:\ORACLE\ORADATA\ARUN\XDB01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\ARUN\CWMLITE01.DBF
channel C3: starting full datafile backupset
channel C3: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLE\ORADATA\ARUN\EXAMPLE01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\ARUN\DRSYS01.DBF
channel B1: starting full datafile backupset
channel B1: specifying datafile(s) in backupset
input datafile fno=00002 name=D:\ORACLE\ORADATA\ARUN\UNDOTBS01.DBF
input datafile fno=00007 name=D:\ORACLE\ORADATA\ARUN\ODM01.DBF
channel B2: starting full datafile backupset
channel B2: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\ARUN\SYSTEM01.DBF
input datafile fno=00008 name=D:\ORACLE\ORADATA\ARUN\TOOLS01.DBF
channel C1: backup set complete, elapsed time: 00:00:10
channel C2: backup set complete, elapsed time: 00:00:09
channel C3: backup set complete, elapsed time: 00:00:08
channel B1: backup set complete, elapsed time: 00:00:07
channel B2: backup set complete, elapsed time: 00:00:11
Finished backup at 25-MAY-08

Starting backup at 25-MAY-08
released channel: C1
released channel: C3
released channel: C2
released channel: B1
released channel: B2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/25/2008 16:30:34
RMAN-20242: specification does not match any archive log in the recovery catalog

RMAN>


I'm not sure about the error,pls help me out..i suppose its something to do with BACKUP VALIDATE DATABASE ARCHIVELOG ALL; ...

Thnx,
Arun.
Re: Changing backup location in RMAN backups [message #322652 is a reply to message #322626] Sun, 25 May 2008 16:02 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You deleted all the archive logs, therefore BACKUP VALIDATE DATABASE ARCHIVELOG ALL will fail unless another archive log gets generated prior to executing this command.
Previous Topic: why can not recover this datafile?
Next Topic: how to recreate confil without any bkp
Goto Forum:
  


Current Time: Mon Dec 05 12:38:13 CST 2016

Total time taken to generate the page: 0.06955 seconds