Backup Central

I backing up Oracle Data(9i) by Rman.
When I drop one table of User Tapespace. what method can i recover it?
I guess that use auxiliary database for recover.
Do you have the information that consist of auxiliary database ?
also. How can you restore table droppted by user ?
I have no idea . please tell me the method ?
Can you give me rman scripts for it ?

[My test specification]
database : oracle 9i
Backup Method : Use rman catalog
Networker verstion : Networker6.5.3
Oracle Backup : MMO of Networker

best regard.

Note: To sign off this list, send a "signoff networker" command via email
to listserv < at > listserv.temple.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu

Hi Snoop,

Oracle database recoveries are to be done only through RMAN scripts.

I have used the attached one for Oracle 9i on Solaris NMO 4.1. This script
is restoring two tablespaces.

Regards,
Anuj Mediratta
Phone: +919312634262
To know more about our services, do log on to www.ace-data.com
-----Original Message-----
From: Legato NetWorker discussion [mailto:NETWORKER < at > LISTSERV.TEMPLE.EDU] On
Behalf Of Snoop
Sent: Monday, April 04, 2005 8:05 AM
To: NETWORKER < at > LISTSERV.TEMPLE.EDU
Subject: [Networker] HI ALL

I backing up Oracle Data(9i) by Rman.
When I drop one table of User Tapespace. what method can i recover it?
I guess that use auxiliary database for recover.
Do you have the information that consist of auxiliary database ?
also. How can you restore table droppted by user ?
I have no idea . please tell me the method ?
Can you give me rman scripts for it ?

[My test specification]
database : oracle 9i
Backup Method : Use rman catalog
Networker verstion : Networker6.5.3
Oracle Backup : MMO of Networker

best regard.

Note: To sign off this list, send a "signoff networker" command via email
to listserv < at > listserv.temple.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu


Note: To sign off this list, send a "signoff networker" command via email
to listserv < at > listserv.temple.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu

------=_NextPart_000_0011_01C538FC.17F6A000
name="datest_restore_tb.txt"
Content-Transfer-Encoding: quoted-printable

<< 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.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu