Re: Critical data recovery 10gR2

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 23 Dec 2010 15:46:57 -0300
Message-ID: <AANLkTinV7qCfWuci3KqxoAgGrABiZZD-To-22jgwDs5C_at_mail.gmail.com>

I don´t have access to my scripts right now, but as far as I remember it went something like this:

1. create new pfile for new db (init_newdb.ora)
2. startup nomount the new instance
3. set new db as ORACLE_SID
4. rman target sys/manager_at_original auxiliary=/ catalog=I_hope_i_have_this/rman_at_rmancatalogdatabasewiiiiiii
5. duplicate database until sysdate-4 (you can exclude tablespaces here)
6. export/import wooohooo! (you may need to create the controlfiles manually before the duplicate, but I'm not sure, and you can use the set newname to remap datafile names and redolog files)

I hope this helps... and I'm sorry I cannot give you a set of scripts (of course I scripted this after the second time I had to do it)

just as a curiosity, what kind of backup do you have? are you using flashback? how far back do your flashback logs go?

Alan.-

On Thu, Dec 23, 2010 at 3:14 PM, <Sarabjit_Toor_at_cooperators.ca> wrote:

>
> You can use rman duplicate command with skip tablespaces command.
>
>
>
> From: Sandra Becker <sbecker6925_at_gmail.com> To: oracle-l <
> oracle-l_at_freelists.org> Date: 23/12/2010 01:00 PM Subject: Critical data
> recovery 10gR2 Sent by: oracle-l-bounce_at_freelists.org
> ------------------------------
>
>
>
> Oracle 10.2.0.4
>
> We have lost critical data in four different tables. I need to recover the
> data from 4 days ago but cannot do a restore of the production database.
> Once many years ago, a coworker created a new database restoring only the
> tablespaces we needed but neither of us took notes on what we did. Does
> anyone have a whitepaper or script to get me going in the right direction?
> I also am researching Metalink but haven't found an answer yet.
>
> --
> Sandy
> Transzap, Inc.
>
>
>
>
>
>
> Please consider the environment before printing this email
>
> This message, including any attached documents, is intended for the
> addressees only. It may contain information that is confidential, privileged
> and/or exempt from disclosure. No rights to privilege or confidentiality
> have been waived. Any unauthorized use or disclosure is prohibited. If you
> have received this message in error, please reply to the sender by e-mail
> and delete or destroy all copies of this message.
>
> Avant d'imprimer ce courriel, pensez à l'environnement
>
> Ce message, incluant tous les documents joints, est à l'intention des
> destinataires visés seulement. Il peut contenir des renseignements
> confidentiels, protégés et/ou ne pouvant pas être divulgués. Aucune
> renonciation n'est faite quant à sa nature confidentielle et privilégiée.
> Par conséquent, toute diffusion ou utilisation non autorisée est strictement
> interdite. Si vous avez reçu ce message par erreur, veuillez en aviser
> immédiatement l’expéditeur par retour de courriel et en détruire toutes les
> copies existantes.
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 23 2010 - 12:46:57 CST