Networker

Re: [Networker] HI ALL

2005-04-04 01:34:54
Subject: Re: [Networker] HI ALL
From: Sang Deuk Kwon <snoop AT BECSOLUTIONS DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Mon, 4 Apr 2005 01:29:14 -0400
<< Backup Diagram>>

       (10/100 Network)
-------------------------------------
   |              |             |
   |

  SEVER A       SERVER B      SERVER C
Oracle 9i                     Rman Catalog DB

<< Backup Time >>
-----------------------------------------------
<<Backup Time>>  << Date>>   << Backup Level >>
   01:00:00       03/31/2005   Level 0
   01:00:00       04/01/2005   Level 1
   01:00:00       04/02/2005   Level 1
   01:00:00       04/03/2005   Level 1
   01:00:00       04/04/2005   Level 1

<< Oracle 9i TABLESPACE, DATAFILE, TABLE >

TABLESPACE = TEST
DATAFILE   = TEST.DBF
TABLE      = AAA  <=== important table


I backing up Server A by Oracle RMAN catalog DB.
All Database File of Server A  is backuped on 01:00 by Daily Policy
but, anybody delete table "AAA" on 04/02/2005 14:00:00
I have to recover table "AAA"
Because Target Oracle DB can't shutdown and only recover one table "AAA"
I wish the table "AAA" is recovered on Server B

if see Oracle RMAN manual, used duplicate on auxiliary database
but the method is difficult thing .

what best method consist auxiliary database for recover table "AAA"  ?
do you have experience ? if you have . send me progress method !
and. I have to imcomplete recover of Oracle Table..

Regards.

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listserv.temple DOT edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
also view and post messages to the list. Questions regarding this list
should be sent to stan AT temple DOT edu
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>