Re: recover tablespace

On Apr 7, 2:04 am, "mostv via DBMonster.com" <u41215_at_uwe> wrote:
> 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.comhttp://www.dbmonster.com/Uwe/Forums.aspx/oracle/200804/1

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