Re: Critical data recovery 10gR2
- From: Sarabjit_Toor@xxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 23 Dec 2010 13:14:06 -0500
You can use rman duplicate command with
skip tablespaces command.
From:
| Sandra Becker <sbecker6925@xxxxxxxxx>
|
To:
| oracle-l <oracle-l@xxxxxxxxxxxxx>
|
Date:
| 23/12/2010 01:00 PM
|
Subject:
| Critical data recovery 10gR2
|
Sent by:
| oracle-l-bounce@xxxxxxxxxxxxx |
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.
Other related posts: