OraFAQ Forum: Backup & Recovery » How long can we keep backed up files in RMAN NOCATALOG?

Home » RDBMS Server » Backup & Recovery » How long can we keep backed up files in RMAN NOCATALOG? (Oracle 12c, Oracle Linux Enterprise 7.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How long can we keep backed up files in RMAN NOCATALOG? [message #649975]

Mon, 11 April 2016 21:58

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

Hi,

Currently I am testing Oracle 12c standard edition 2 on Oracle Linux Enterprise 7.2.
As I know the Oracle standard edition cannot support RMAN as CATALOG MODE, that why I use RMAN as NOCATALOG MODE with CONTROLFILE.

In my setting RMAN configuration, If I set the "CONFIGURE RETENTION POLICY TO RECOVERY WINDOWS OF 7", Can I restore any old backed up file before of 7 days? Because sometime I need to restore old data from last month to another server.

Thank you!

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649978 is a reply to message #649975]

Tue, 12 April 2016 00:40

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you need this then change your recovery windows!
Why do you set it to 7 days when your need is 1 month?

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649979 is a reply to message #649975]

Tue, 12 April 2016 00:41

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Quote:

As I know the Oracle standard edition cannot support RMAN as CATALOG MODE,

There is no restriction on using a catalog with SE. Create it anywhere you want. No charge.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649985 is a reply to message #649979]

Tue, 12 April 2016 02:46

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

John Watson wrote on Tue, 12 April 2016 12:41

Quote:
As I know the Oracle standard edition cannot support RMAN as CATALOG MODE,

There is no restriction on using a catalog with SE. Create it anywhere you want. No charge.

I tried many times to upgrade catalog by create virtual private catalog, but it error "ORA-00439: feature not enabled: Partitioning" like below picture.

Could you tell me how to create catalog mode in Oracle 12c SE?

thank in advance,

Attachment: 2016-04-12 14_43_25-10.178.212.200 - Remote Desktop Connection.png
(Size: 37.13KB, Downloaded 1865 times)

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649986 is a reply to message #649978]

Tue, 12 April 2016 03:04

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

Michel Cadot wrote on Tue, 12 April 2016 12:40

If you need this then change your recovery windows!
Why do you set it to 7 days when your need is 1 month?

Thank you!

From below reference, it is not recommended to keep longer backup retention policy.
I think there are 2 different cases.
1. For Production Error: we will need to restore recent new backed up.
2. But for testing or UAT enviroment: we need to restore any old backed up database that sometime are longer than 2 months to check some issue of pre or post COB.

-----------------------------------------------------------------
Storing backup data in only the control file has some limitations:
• By default, Oracle stores seven days of backup data in the control file. The database parameter control file_record_keep_time can change the length of time. Still, it isn't recommended that you use your control file for long backup retention periods. It causes control file growth, and if you ever lose your control files, you've lost all your recovery information. It's doesn't make recovery impossible, but it's a real pain.
• Limits the type of reporting you can do on your backups. You can query only one database at a time, after which you have to manually aggregate all the reports for multiple databases together.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649987 is a reply to message #649986]

Tue, 12 April 2016 03:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

From below reference,

Which comes from?
And it is wrong.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649988 is a reply to message #649985]

Tue, 12 April 2016 03:23

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

but it error "ORA-00439: feature not enabled: Partitioning" like below picture.

So recreate the catalog with no partition.
It is not mandatory to have partitioned catalog tables.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649991 is a reply to message #649987]

Tue, 12 April 2016 03:54

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

Michel Cadot wrote on Tue, 12 April 2016 15:22

Quote:
From below reference,

Which comes from?
And it is wrong.

I research from this website: http://www.dummies.com/how-to/content/basics-of-the-oracle-12c-recovery-manager-rman-cat.html
Anyway, how long that we can set retention policy on control file?

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649993 is a reply to message #649988]

Tue, 12 April 2016 03:55

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

Michel Cadot wrote on Tue, 12 April 2016 15:23

So recreate the catalog with no partition.
It is not mandatory to have partitioned catalog tables.

Cadot, could you tell detail me how to create catalog for RMAN on Oracle SE?

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649994 is a reply to message #649991]

Tue, 12 April 2016 03:59

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Puthearith wrote on Tue, 12 April 2016 10:54

Michel Cadot wrote on Tue, 12 April 2016 15:22

Quote:
From below reference,

Which comes from?
And it is wrong.

I research from this website: http://www.dummies.com/how-to/content/basics-of-the-oracle-12c-recovery-manager-rman-cat.html
Anyway, how long that we can set retention policy on control file?

As long as your requirements need it.
If you need a recovery window of 1 month then set it to 31.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649995 is a reply to message #649993]

Tue, 12 April 2016 04:01

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Puthearith wrote on Tue, 12 April 2016 10:55

Michel Cadot wrote on Tue, 12 April 2016 15:23

So recreate the catalog with no partition.
It is not mandatory to have partitioned catalog tables.

Cadot, could you tell detail me how to create catalog for RMAN on Oracle SE?

Not using upgrade catalog but CREATE CATALOG.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649997 is a reply to message #649995]

Tue, 12 April 2016 04:32

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

[/quote]

Not using upgrade catalog but CREATE CATALOG.

[/quote]
I still cannot create the catalog.

Attachment: 2016-04-12 16_29_48-10.178.212.200 - Remote Desktop Connection.png
(Size: 46.59KB, Downloaded 1758 times)

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #649999 is a reply to message #649997]

Tue, 12 April 2016 04:49

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Open a SR to Oracle.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #650000 is a reply to message #649997]

Tue, 12 April 2016 04:56

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Puthearith wrote on Tue, 12 April 2016 10:32

Not using upgrade catalog but CREATE CATALOG.

I still cannot create the catalog.

Create an Enterprise Edition database, and create your catalog in that. Then register your SE databases. As I said, there is no charge.

[Updated on: Tue, 12 April 2016 04:57]

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #650004 is a reply to message #649994]

Tue, 12 April 2016 06:36

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

[/quote]
I research from this website: http://www.dummies.com/how-to/content/basics-of-the-oracle-12c-recovery-manager-rman-cat.html
[/quote]

Why not research from the official docs?
Create Catalog
Managing A Recovery Catalog

And for what it's worth, my rman catalog is in a Standard Edition One database.

Report message to a moderator

Re: How long can we keep backed up files in RMAN NOCATALOG? [message #650168 is a reply to message #650004]

Mon, 18 April 2016 03:45

Puthearith
Messages: 10
Registered: April 2016
Location: Phnom Penh

Junior Member

EdStevens wrote on Tue, 12 April 2016 18:36

I research from this website: http://www.dummies.com/how-to/content/basics-of-the-oracle-12c-recovery-manager-rman-cat.html
[/quote]

Why not research from the official docs?
Create Catalog
Managing A Recovery Catalog

And for what it's worth, my rman catalog is in a Standard Edition One database.[/quote]

Thank, I will try to install it again.

Report message to a moderator

Previous Topic:	Rman backup performance issue
Next Topic:	issue in Monitoring RMAN job Progress (multiple channels)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 01:47:06 CST 2024