OraFAQ Forum: Backup & Recovery » Apply different policy on the same database

Home » RDBMS Server » Backup & Recovery » Apply different policy on the same database (Db 11.2.0.1.0 on Linux Rdh 2.6.18-194.el5)

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

Apply different policy on the same database [message #680129]

Thu, 23 April 2020 04:32

powlean
Messages: 3
Registered: April 2020

Junior Member

Hello ,

I have the following problem.
I manage my db with incremental backup using Rman with this schema:

Mon Level 0
Tue Level 1
Wed Level 1
Thu Level 0
Fri Level 1
Sat Level 1
Sun Level 1

ok , ask a comunity, it's possible apply a second policy for which
continue to generate level 1 from first level 0... also after the second Level 0.

in practice from Fri generate two level 1 ..one relate Mon and one relate Thu ?

Thank's in advance.

Report message to a moderator

Re: Apply different policy on the same database [message #680130 is a reply to message #680129]

Thu, 23 April 2020 06:21

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

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

You could use

BACKUP INCREMENTAL FROM SCN .... ;

but I don't see any point.

Report message to a moderator

Re: Apply different policy on the same database [message #680131 is a reply to message #680129]

Thu, 23 April 2020 07:37

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Like John Watson, I don't see any point. Please explain what you'd expect to achieve by doing so.

Report message to a moderator

Re: Apply different policy on the same database [message #680132 is a reply to message #680131]

Thu, 23 April 2020 08:10

powlean
Messages: 3
Registered: April 2020

Junior Member

I hope to be be understood.

I'd like create a "standby database" using rman backup...

Step 1 ...copy level 0 and open db in recover mode.
Step 2 ...every day copy/apply incremental level 1

..the problem is thursday ... when repeat level 0
and I have to re copy level 0 in standby machine
but if I continue to generate level 1 from first level 0
you don't need to copy

Report message to a moderator

Re: Apply different policy on the same database [message #680134 is a reply to message #680132]

Thu, 23 April 2020 09:48

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

Senior Member

I've already given you a technique that would work for that, but you shouldn't be doing this: it is standard functionality. Two ways:

Either copy your archive logs to the standby and apply them

Or use RMAN to generate and apply incrementals automatically,
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/getting-started-rman.html#GUID-F3E3B64C-E9B5-4493-83B1-5F7564A526 EB

Report message to a moderator

Re: Apply different policy on the same database [message #680135 is a reply to message #680134]

Thu, 23 April 2020 09:56

powlean
Messages: 3
Registered: April 2020

Junior Member

read the doc...

Report message to a moderator

Previous Topic:	Point In Time recovery with timestamp
Next Topic:	issue with disabling block chnage tracking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 05:43:58 CST 2024