Home » RDBMS Server » Backup & Recovery » Incremental level 1 merge backup (Oracle 10gR1, SLES9)
Incremental level 1 merge backup [message #295393] Tue, 22 January 2008 04:30 Go to next message
mkb08
Messages: 4
Registered: January 2008
Junior Member
Hi all,

My level 0 backup script is:
run {
configure controlfile autobackup off;
backup incremental level 0 tag level_0 
   format '/bkup1/rbackup/%d_full_bkup_%t.bak' (database);
backup current controlfile format '/bkup1/rbackup/%d_%s_%T_CNTRL' tag CONTRLFL;
backup spfile format '/bkup1/rbackup/%d_%s_%T_SPFILE' tag SPFILE;
sql 'alter system archive log current;
backup archivelog all format '/bkup1/rbackup/%d_%s_%T_ARC' tag ARCLOG;
configure controlfile autobackup on;
}


This works fine without any problem. My level 1 incremental merge backup script is:

run {
configure controlfile autobackup off;
recover copy of database with level_0;
backup incremental level 1 for recover of copy with tag level_0 database;
backup current controlfile format '/bkup1/rbackup/%d_%s_%T_CNTRL' tag CONTRLFL;
backup spfile format '/bkup1/rbackup/%d_%s_%T_SPFILE' tag SPFILE;
sql 'alter system archive log current;
backup archivelog all format '/bkup1/rbackup/%d_%s_%T_ARC' tag ARCLOG;
configure controlfile autobackup on;


When I run the level 1 backup i am getting the following error:
MAN> run
2> {
3> backup incremental level 1 for recover of copy with tag level_0 database;
4> recover copy of database with tag level_0;
5> backup current controlfile format '/bkup1/rbackup/%d_%s_%T_CONTROL' tag "CNTRLFL";
6> backup spfile format '/bkup1/rbackup/%d_%s_%T_SPFILE' tag "SPFILE";
7> sql 'alter system switch logfile';
8> backup archivelog all format '/bkup1/rbackup/%d_%s_%T_ARCHIVE' tag "ARCLOG";
9> }
Starting backup at 22-JAN-08
using channel ORA_DISK_1
Before in kgllkdl(), hd=1a4e5f8.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/22/2008 14:00:55
RMAN-00600: internal error, arguments [13215] [INVALID] [] [] []

RMAN> **end-of-file**

Why the script fails.

Manoj
Re: Incremental level 1 merge backup [message #295402 is a reply to message #295393] Tue, 22 January 2008 04:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This is a known bug. Please check metalink for exact information.
Upgrade to 10.2 or apply latest patchsets.
Re: Incremental level 1 merge backup [message #295407 is a reply to message #295402] Tue, 22 January 2008 05:01 Go to previous messageGo to next message
mkb08
Messages: 4
Registered: January 2008
Junior Member
Thank you for your reply. I don't have access to metalink because i am using Oracle ASFU license. Also it is not possible for upgradation atleast for 6 months.

So, is there any other way to achieve this. Normal incremental level backups work fine. But it will create many files and will occupy lot of space. So I want to avoid that method.
Re: Incremental level 1 merge backup [message #295449 is a reply to message #295407] Tue, 22 January 2008 06:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just apply latest patchsets in the release you are using.
This is a documented Oracle bug which I encountered a while back. I did not investigate much around it as it was already known to be a bug. Well, disk space is cheap. You need to get compromised somewhere. Either add more space, upgrade/patch, reduce the local retention...
Re: Incremental level 1 merge backup [message #295462 is a reply to message #295449] Tue, 22 January 2008 06:44 Go to previous messageGo to next message
mkb08
Messages: 4
Registered: January 2008
Junior Member
agreed. I will go for patch updates. But I don't find the patches in the oracle's site. Should I require a metalink account to download the patches?
Re: Incremental level 1 merge backup [message #295798 is a reply to message #295462] Wed, 23 January 2008 08:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>Should I require a metalink account to download the patches?
Yes, you must have metalink account to download patchset and CPU patches.

for metalink account you have VALID CSI number.

Re: Incremental level 1 merge backup [message #295911 is a reply to message #295798] Wed, 23 January 2008 22:17 Go to previous message
mkb08
Messages: 4
Registered: January 2008
Junior Member
Thank you all for the clarification. As Mr.Mahesh advised, I am going to download the release 2 of Oracle 10g. I will update the status once I get the result.

Manoj.
Previous Topic: datafile copy error.
Next Topic: Recovery Catalog
Goto Forum:
  


Current Time: Wed May 15 19:14:50 CDT 2024