| Changing backup location in RMAN backups [message #322622] |
Sun, 25 May 2008 05:16  |
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 #322626 is a reply to message #322624] |
Sun, 25 May 2008 06:13  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
