Re: Is it possible to recover just one datafile/tablespace "until cancel"?

In <255db8b61d67e8c3b996027a907cc6dd.20305_at_mygate.mailgate.org> "Thomas Schwickert" <schwickert_at_yahoo.com> writes:

>"Stan Brown" <stanb_at_panix.com> wrote in message
>news:blbst1$i45$1_at_reader2.panix.com
 

>> Not meaning to challenge your GURUness :-) but is this an issue of my
>> Oracle version being to old (7.3.4.5)? As some other people have sugested
>> that I can do a recover until cancel on a specific datafile.
 

>Hi,
 

>it's so in 7.3.x as also in 9.2.x ... :-)
 

>Part of the docu (9.2)
>(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1010523)
>----- snip ----
>RECOVER {general | managed | END BACKUP}
 

>where the general clause has the following syntax:
 

>[AUTOMATIC] [FROM location]
>{ {full_database_recovery | partial_database_recovery |LOGFILE filename}
>[ {TEST | ALLOW integer CORRUPTION } [TEST | ALLOW integer CORRUPTION
>]...]
>|CONTINUE [DEFAULT]|CANCEL}
 
>where the full_database_recovery clause has the following syntax:
 

>[STANDBY] DATABASE
>[ {UNTIL {CANCEL | TIME date | CHANGE integer} | USING BACKUP
>CONTROLFILE}
>[UNTIL {CANCEL | TIME date | CHANGE integer} | USING BACKUP
>CONTROLFILE]...]
 
>where the partial_database_recovery clause has the following syntax:
 

>{TABLESPACE tablespace [, tablespace]... | DATAFILE datafilename [,
>datafilename]...
>| STANDBY
>{TABLESPACE tablespace [, tablespace]... | DATAFILE datafilename [,
>datafilename]...}
>UNTIL [CONSISTENT] [WITH] CONTROLFILE }
 
>--- snip ---
>As you can see, there ist no RECOVER DATAFILE ... UNTIL CANCEL
>But there IS a RECOVER DATABASE UNTIL CANCEL :-)
 

>As you wrote in another response, your RECOVER DATAFILE ... UNTIL CANCEL
>complained about the UNTIL key-word. Then you made a RECOVER DATABASE
>UNTIL CANCEL
 
>But like the name say, it a recovery of the DATABASE
 

>Quod erat demonstrandum :-)

OK, I'm goging to drop that tablespace, and it's datafile, and recreate it (the easy part). Then I get to figure out how to restore it's few K of data from my 10G dump. _Taht_ should be interesting.

Thanks for the education.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin