| Overriding an RMAn backup set/pieces [message #332188] |
Mon, 07 July 2008 15:57  |
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  |
 |
BlackSwan
Messages: 26766
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 |
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 |
 |
Mahesh Rajendran
Messages: 10707
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 #332427 is a reply to message #332188] |
Tue, 08 July 2008 09:06 |
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 #332467 is a reply to message #332188] |
Tue, 08 July 2008 11:04 |
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...
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
