Re: RMAN Incrementals
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: TESTAJ3@xxxxxxxxxxxxxx
- Date: Thu, 4 Jun 2009 21:49:24 +0800
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:
