RMAN Restore

[Nirmalkumar]

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.

[Yogeeraj_1]

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

[Nirmalkumar]

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.