Home » RDBMS Server » Backup & Recovery » Overriding an RMAn backup set/pieces (RMAN version 10.2.0.2.0)
Overriding an RMAn backup set/pieces [message #332188] Mon, 07 July 2008 15:57 Go to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Hi DBA's,

I do take cold backups of my database (96G) using RMAN (to disk). My configuration parameter for disk storage is as follows:

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT $ORACLE_BASE/backup/db_name/%U';

This configuration creates a backup set with 3 pieces. Now, i need to set the configuration such that every time a backup is taken, it should override the present set/pieces & replace them with a new set/pieces, such that the old set/pieces would be automatically deleted.

Is there the possibility of doing this?

Please help...

divroro12
Re: Overriding an RMAn backup set/pieces [message #332190 is a reply to message #332188] Mon, 07 July 2008 16:01 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Now, i need to set the configuration such that every time a backup is taken, it should override the present set/pieces

So that when the system reboots in the middle of doing backups,
you are left WITHOUT any valid backups;
because the new set is incomplete and having overwritten the previous good copy.

This is a recipe for a premeditated DISASTER!

[Updated on: Mon, 07 July 2008 16:02] by Moderator

Report message to a moderator

Re: Overriding an RMAn backup set/pieces [message #332191 is a reply to message #332188] Mon, 07 July 2008 16:07 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Hi,

The disaster issue is already taken care of by having a separate exact copy of the database in question within the same server, such that i always have a valid backup on the copy, in case something bad (as you predict) was o go wrong along the way...
Re: Overriding an RMAn backup set/pieces [message #332195 is a reply to message #332191] Mon, 07 July 2008 16:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems you are looking into a retention policy.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1007.htm
>>Now, i need to set the configuration such that every time a backup is taken, it should override the present set/pieces

Well, usually it is not the case. Traditional shops with
traditional wisdom would like to generate unique backupsets and delete
them after the backup is done/verified.
You can easily script this in such a way that after backup is taken,
verify the log and delete previous days backup.
Search the forum. There are many examples.
And
>>CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT $ORACLE_BASE/backup/db_name/%U';
I would never write my backups to $ORACLE_BASE.
Disk is cheap. Look into NAS/NFS storage.

[Updated on: Mon, 07 July 2008 16:41]

Report message to a moderator

Re: Overriding an RMAn backup set/pieces [message #332198 is a reply to message #332188] Mon, 07 July 2008 16:54 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>having a separate exact copy of the database in question within the same server

Having all eggs in 1 basket is suboptimal choice.
Upon server going up in smoke, recovery could be problematic.
Re: Overriding an RMAn backup set/pieces [message #332427 is a reply to message #332188] Tue, 08 July 2008 09:06 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
I've got a proper DR plan in place, so this isn't any issue of concern to me right now. I just wish to know if there's a solution to my above request.
Mahesh, i don't think retention policy is waht i need. I did some research, & was thinking of adding "delete obsolete" to the backup script just before start of the new backup. Will test that shortly...

Thanks...
Re: Overriding an RMAn backup set/pieces [message #332433 is a reply to message #332427] Tue, 08 July 2008 09:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you even bother to read the piece of documentation i was referring to?
Quoting the URL I have already posted
A companion command, DELETE OBSOLETE, deletes all files which are obsolete according to the retention policy
Re: Overriding an RMAn backup set/pieces [message #332467 is a reply to message #332188] Tue, 08 July 2008 11:04 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Yes, i read it. Might be i miscommunicated. I think what i'll do is just run the RMAN "report obsolete" command (i have redundancy policy configured to 1) & delete some of the obsolete backup sets/pieces prior to taking fresh ones.

Thanks for your help...

Re: Overriding an RMAn backup set/pieces [message #332469 is a reply to message #332467] Tue, 08 July 2008 11:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Report Obsolete and delete obsolete will work based on policy set.
Re: Overriding an RMAn backup set/pieces [message #332474 is a reply to message #332188] Tue, 08 July 2008 11:23 Go to previous message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Sure. Again thanks...
Previous Topic: bakup
Next Topic: ORA-00054: resource busy and acquire with NOWAIT specified
Goto Forum:
  


Current Time: Sun Dec 04 12:52:47 CST 2016

Total time taken to generate the page: 0.05019 seconds