Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN restore tablespace

RMAN restore tablespace

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 18 Apr 2005 10:08:50 -0700 (PDT)
Message-ID: <20050418170850.50909.qmail@web60806.mail.yahoo.com>


> Then, why do all the examples in every manual show
restoring and
> recovery form the RMAN> prompt?
>

restore is first (the physical part), then comes recovery.
Again, your error message shows the command was not expected.
Even more, your next example that does work, shows you restore,
and then recover.
Oh - and about your every manual shows it from the prompt:

For example, to restore tablespace USER_DATA to disk you might issue:
run {
sql 'ALTER TABLESPACE user_data OFFLINE TEMPORARY'; allocate channel ch1 type disk;
restore tablespace user_data;
}

Quoted from the 8i Recovery Manager User's Guide and Reference,
part A76990-01, issued December 1999 (time to upgrade!),
Ch 6 "Restoring Datafiles, Control Files, and Archived Redo Logs",
sub section "Restoring Tablespaces and Datafiles"                 



Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 18 2005 - 13:13:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US