Oracle RMAN Question: Download Questions PDF
Tell me can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?
Answer:
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.
Download RMAN Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to verify the integrity of the image copy in RMAN environment? | What are RTO, MTBF, and MTTR? |