-
question
Good Morning
you have a current control file and SPFILE but all datafiles are
damaged or lost. You must restore and recover the whole database.
The database has one read-only tablespace(ITEM_TS), which must be restored
from backup but which does not need media recovery.
Write the commands and scripts needed to restore and recover the
database when the current control file is available.
thx
-
Assuming that your environment variables are correct and you are using Linux and logged in as the Oracle user.
Code:
rman
connect target /
startup nomount;
catalog start with '/u01/orabackup/mydatabasebackup';
RESTORE CONTROLFILE;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
Do you have a valid backup? Do you have access to all of the archive logs that you need?
Will you need to do an incomplete restore given that you don't have all of the redo?
I don't know, since you did not say. But the answer is in the url below.
http://docs.oracle.com/cd/E11882_01/...e10642/toc.htm
As a DBA doing a restore is something that you test and practice so that if you ever need
to do a restore in a real situation you aren't then trying to learn how to do it and hoping
that you have what you need. Practice in advance and know that you have what you need.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|