Home » RDBMS Server » Backup & Recovery » Rman Backup (Oracle 9i, windows 2003)
Rman Backup [message #476012] Mon, 20 September 2010 12:34 Go to next message
elangodba
Messages: 6
Registered: October 2008
Location: Chennai
Junior Member
Hi all,

I have set up RMAN Backup in my system which takes daily full backup as it is Standara Edition 9i.

My db size is 35GB.

As is see in the backup folder that there are three backup files each of 35GB.

I don't know why there are three peices.

I have given my RMAN Configuration below:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'H:\OCTO backup\%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'H:\OCTO backup\OCTO_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'H:\OCTO backup\SNCFOCTO.ORA';

Can Anybody explain me how come it take Three 35GB files. and why.

Thanks in Advance....

Elango
Re: Rman Backup [message #476013 is a reply to message #476012] Mon, 20 September 2010 12:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Could be useful you can post the directory/file listing (output of Dir).
Also post the exact command/script you used to backup and log file/session output.
Re: Rman Backup [message #476320 is a reply to message #476013] Wed, 22 September 2010 10:29 Go to previous messageGo to next message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
I guess it could be result from 'CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;'. Oracle would try to keep all info in recovery window, that means it would keep all in 7 days.
Re: Rman Backup [message #476323 is a reply to message #476320] Wed, 22 September 2010 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
that means it would keep all in 7 days.

or more, depending on the frequency of the backups.

Regards
Michel

[Updated on: Wed, 22 September 2010 11:04]

Report message to a moderator

Re: Rman Backup [message #476329 is a reply to message #476323] Wed, 22 September 2010 10:46 Go to previous message
elangodba
Messages: 6
Registered: October 2008
Location: Chennai
Junior Member
Folks,

Thanks Everybody.

I found the solution.
Surprised Cool Laughing
Previous Topic: what diffrence between 'delete input' and 'change xxx delete'
Next Topic: RMAN Corruption
Goto Forum:
  


Current Time: Tue Apr 16 17:24:00 CDT 2024