Re: RMAN Incrementals
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: karlarao@xxxxxxxxx, TESTAJ3@xxxxxxxxxxxxxx
- Date: Thu, 4 Jun 2009 07:15:47 -0700 (PDT)
Only works for 10g and later databases...
RF
Robert G. Freeman
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
http://pages.sssnet.com/messndal/church/parachurch.pdf
________________________________
From: Karl Arao <karlarao@xxxxxxxxx>
To: TESTAJ3@xxxxxxxxxxxxxx
Cc: Richard Goulet <Richard.Goulet@xxxxxxxxxxx>; Oracle L
<oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, June 4, 2009 7:49:24 AM
Subject: Re: RMAN Incrementals
This makes level 0 backup the first time you execute it,
then subsequent runs will do a level 1,
and will recover the incremental backups of SYSDATE – 1
run {
RECOVER COPY OF DATABASE WITH TAG ‘IMG_COPY’ UNTIL TIME ‘SYSDATE – 1’;
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG ‘IMG_COPY’ DATABASE
PLUS ARCHIVELOG DELETE INPUT;
}
Then in case of emergency, you could...
SWITCH DATABASE TO COPY;
You could go to this blog for details..
http://oraclever.blogspot.com/2008_11_01_archive.html
Alejandro Vargas also has the RMAN hands on document on his blog..
- Karl Arao
http://karlarao.wordpress.com
On Thu, Jun 4, 2009 at 9:27 PM, <TESTAJ3@xxxxxxxxxxxxxx> wrote:
Level 0 then level 1 backups
Sent from the crackberry, so please excuse the typos and terseness.
________________________________
From: "Goulet, Richard" [Richard.Goulet@xxxxxxxxxxx]
Sent: 06/04/2009 09:22 AM AST
To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
Subject: RMAN Incrementals
All,
I'm having one heck of a brain dropout recently. I know that there is
a way to take a full backup on say Sunday and then incrementals throughout the
week and apply those to the original full backup, I just can't find it in the
manuals. Could someone please dump me a pointer??
Dick Goulet
Senior Oracle DBA
PAREXEL International
900 Chelmsford St, Suite 310
Lowell, MA 01821
978.614.2857
Richard.Goulet@xxxxxxxxxxx
The information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received this
in error, please destroy any copies, contact the sender and delete the material
from any computer.
Other related posts:
