cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN Restore

Nirmalkumar
Frequent Advisor

RMAN Restore

Hi,

i am in the process of Restoring the database in another server.

The instance name in another server is same as source.

i have created directory structure is also same as source

i have did the following steps

1.Started instance
2.Mount the database
3.Restored the controlfile
4.While restoring the datafiles it says that "one datafile is missing in the backup" but the that datafile entry is there in
controlfile.

Please provide me how to proceed my restoration.Is it possible to skip the particular datafile and restore the rest.

Thanks
Nirmal.
2 REPLIES
Yogeeraj_1
Honored Contributor

Re: RMAN Restore

Hi Nirmal,

When restoring the controlfile, it is important that the database NOT be mounted!

Step 1. Startup the instance (NOMOUNT)
SQL> startup nomount;

Step 2. Restore the control file using RMAN
RMAN> restore controlfile;

Step 3. Mount the database
SQL> alter database mount;

Step 4. Restore the database (datafiles etc)
RMAN> restore database;

Step 5. Restore the Archived Redologs

RMAN> restore force archivelog from logseq ;

NB. The next required logseq can be determined using the following query:
# 1 SELECT THREAD#, MAX(SEQUENCE#) AS "LAST_APPLIED_LOG"
# 2 FROM V$LOG_HISTORY
# 3* GROUP BY THREAD#
#

You can alternatively issue:
SQL> recover automatic database using backup controlfile;

and see which is the next archived log file it is asking for!


Step 6. Recover the database
SQL> recover automatic database using backup controlfile;


These steps should run without any glitches!

Hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Nirmalkumar
Frequent Advisor

Re: RMAN Restore

Hi yogeeraj,

Thanks for your response ..

i have mistakenly wrote

Mount the database and then restore the controlfile.

Acutally i have did

Restored the controlfile and then mounted the database only..

But while restoring datafiles ,iam facing

"one datafile is missing in the backup but the that datafile entry is there in
controlfile".

Thanks
Nirmal.