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)
Apply different policy on the same database [message #680129] Thu, 23 April 2020 04:32 Go to next message
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.




Re: Apply different policy on the same database [message #680130 is a reply to message #680129] Thu, 23 April 2020 06:21 Go to previous messageGo to next message
John Watson
Messages: 8348
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.
Re: Apply different policy on the same database [message #680131 is a reply to message #680129] Thu, 23 April 2020 07:37 Go to previous messageGo to next message
EdStevens
Messages: 1250
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.
Re: Apply different policy on the same database [message #680132 is a reply to message #680131] Thu, 23 April 2020 08:10 Go to previous messageGo to next message
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
Re: Apply different policy on the same database [message #680134 is a reply to message #680132] Thu, 23 April 2020 09:48 Go to previous messageGo to next message
John Watson
Messages: 8348
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
Re: Apply different policy on the same database [message #680135 is a reply to message #680134] Thu, 23 April 2020 09:56 Go to previous message
powlean
Messages: 3
Registered: April 2020
Junior Member
read the doc...
Previous Topic: Point In Time recovery with timestamp
Next Topic: issue with disabling block chnage tracking
Goto Forum:
  


Current Time: Mon Sep 28 02:08:16 CDT 2020