Home » RDBMS Server » Backup & Recovery » RMAN Backup Question (Oracle 10.2.0.4 / Redhat Linux)
RMAN Backup Question [message #385714] Tue, 10 February 2009 14:14 Go to next message
maria.maskell@phh.com
Messages: 3
Registered: February 2009
Location: Sparks, MD
Junior Member
Hello,
I'm new to Oracle and RMAN. I've just set up RMAN backups as follows:
* Full backup every week on Sunday
* Incremental backups on the other nights
* Retention is to keep 2 backups (CONFIGURE RETENTION POLICY TO REDUNDANCY 2;)
* File system backups (outside of Oracle) copy the backup files to tape after the backup has completed.
* Issue the "delete noprompt obsolete" command to clean up the file system

Basically, I want the ability to restore to the latest 4 backups, but I only have storage to keep 2 sets of backups on disk. Will the above strategy support this? Do I need to set any other configuration parameters?
Thanks,
Maria
Re: RMAN Backup Question [message #385907 is a reply to message #385714] Wed, 11 February 2009 19:11 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It's going to depend on what you mean by "latest 4 backups". Do you mean 4 backups to include full and incremental ?

If you only have space for 2 backups on disk, you'll have to check your retention to REDUNDANCY 1.
Re: RMAN Backup Question [message #386044 is a reply to message #385907] Thu, 12 February 2009 05:51 Go to previous messageGo to next message
maria.maskell@phh.com
Messages: 3
Registered: February 2009
Location: Sparks, MD
Junior Member
I actually have space for 3 backups. I understand that the REDUNDANCY 2 will allow me to keep 2 backups, and I need space for 3 because it won't delete the backup until it's successful. My question centers around recovery. Can I recover the latest 4 backups if the parameter is set to 2.
Re: RMAN Backup Question [message #386057 is a reply to message #386044] Thu, 12 February 2009 06:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Well if you have space for 3, then REDUNDANCY 2 is fine.

However, for your question "Can I recover the latest 4 backups..." you still have to answer:

ebrian wrote on Wed, 11 February 2009 20:11
It's going to depend on what you mean by "latest 4 backups". Do you mean 4 backups to include full and incremental ?

Re: RMAN Backup Question [message #386067 is a reply to message #386057] Thu, 12 February 2009 07:45 Go to previous messageGo to next message
maria.maskell@phh.com
Messages: 3
Registered: February 2009
Location: Sparks, MD
Junior Member
The backups need to include full and incremental.
Re: RMAN Backup Question [message #386076 is a reply to message #386067] Thu, 12 February 2009 09:14 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If you can afford some additional CPU load,
try RMAN compression. May be you can squeeze a little more.
Previous Topic: Changing 'Log on' option and getting error
Next Topic: Restore compatibility
Goto Forum:
  


Current Time: Sat Dec 10 03:23:04 CST 2016

Total time taken to generate the page: 0.12380 seconds