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 DOT EDU]
On
Behalf Of Snoop
Sent: Monday, April 04, 2005 8:05 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT 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 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
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
--
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
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
datest_restore_tb.txt
Description: Text document
|