Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

recover tablespace

0 views
Skip to first unread message

mostv via DBMonster.com

unread,
Apr 7, 2008, 5:04:21 AM4/7/08
to
oracle 9.2 on win2003serv. Hello! I droped my non-system tablespace. Base in
archivelog mode.How I can restore it, if I have only backup of my tablespace
and logs, and don't have backup of system tablespace?

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200804/1

ora...@msn.com

unread,
Apr 7, 2008, 8:27:25 AM4/7/08
to

Define what you mean by the phrase 'backup of my tablespace and logs'.


David Fitzjarrell

joel garry

unread,
Apr 7, 2008, 1:38:24 PM4/7/08
to

google:
pitr oracle

Also see the docs, there are basic examples there.

As David indicated, the word backup can have many meanings. If you've
properly backed it up from Oracle's perspective, pitr isn't all that
difficult. If you haven't, you've violated the ONE THING that DBA's
HAVE to do correctly. Have you used RMAN or an explicit hot backup to
make the backup? What exactly have you done?

But of course, it's simple when you've learned about it and practiced
it. Asking a basic question about it here isn't a good sign. You
would be expected to know about the granularity of a backup, and the
"recover until" syntax. You shouldn't need a backup of your system
tablespace for this recovery, but that you don't have one is also a
bad sign.

You might consider asking Oracle support to help you. You have
support, right? Metalink also has docs that demonstrate how to
recover, some based on their classes.

jg
--
@home.com is bogus.
Happy Birthday http://www.ravishankar.org/bio.html

0 new messages