Schema restore in RMAN

Can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?

Questions by sreenio

Showing Answers 1 - 2 of 2 Answers

jp1985verma

  • Oct 14th, 2009
 

RMAN gives the command to find all the tablespaces and hence the datafiles belonging to different schemas as:

REPORT SCHEMA;

This command lists all the schemas, tablespace names and the corresponding data files.

After listing, we can restore the datafiles or the tablespaces corresponding to a particular schema.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions