Oracle Media Recovery Not Started

[Former Member]

Hi,

Need help

I've just performed system copy in HP-UX & Oracle as database using backup restore method.

I'm using online backup for this system copy. Control file has been created successfully. Now I'm trying to start the media recover using below cmd

"recover database using backup controlfile until cancel"

After applying this command system is not starting the media recovery. From alert log file I can see the msg Media Recovery Start but oracle is not giving any further message, it is stuck on the below screen.

aigas:oraaeq 2> sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 13 08:42:39 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 5284823040 bytes

Fixed Size 2051424 bytes

Variable Size 2650800800 bytes

Database Buffers 2617245696 bytes

Redo Buffers 14725120 bytes

Database mounted.

SQL>

SQL> recover database using backup controlfile until cancel;

• output of tail -f alert.log file **********

parallel_threads_per_cpu = 1

optimizer_index_cost_adj = 20

query_rewrite_enabled = FALSE

optimpeek_user_binds = FALSE

pga_aggregate_target = 3469486325

workarea_size_policy = AUTO

statistics_level = typical

optimizermjc_enabled = FALSE

bloomfilter_enabled = FALSE

PMON started with pid=2, OS id=5447

PSP0 started with pid=3, OS id=5449

MMAN started with pid=4, OS id=5451

DBW0 started with pid=5, OS id=5453

DBW1 started with pid=6, OS id=5455

LGWR started with pid=7, OS id=5457

CKPT started with pid=8, OS id=5459

SMON started with pid=9, OS id=5461

RECO started with pid=10, OS id=5463

CJQ0 started with pid=11, OS id=5465

MMON started with pid=12, OS id=5467

MMNL started with pid=13, OS id=5469

Thu May 13 09:17:26 2010

ALTER DATABASE MOUNT

Thu May 13 09:17:30 2010

Setting recovery target incarnation to 1

Thu May 13 09:17:30 2010

Successful mount of redo thread 1, with mount id 680883430

Thu May 13 09:17:30 2010

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Thu May 13 09:18:19 2010

ALTER DATABASE RECOVER database using backup controlfile

Thu May 13 09:18:19 2010

Media Recovery Start

We have mounted two nfs file system which are part of oracle file system

Regards,

Neehir Bhatt

[JPReyes]

Usually after that you just need to CANCEL.

then,

alter database archivelog;

and

alter database open resetlogs;

Regards

Juan

[Former Member]

Hi Juan,

Thanks for your replay.

Problem has been resolved, in fact we have mounted two /oracle/<sid>/sapdata dir. through NFS partitioning and some parameters are missing in FSTAB hence oracle is not able to read/write in those mount point and as a results data recovery is not updating any status.

Regards,

Neehir Bhatt

[Former Member]

Hi Neehir,

How did you create the control file ?

Did you use start the DB with source SID and generated a control file trace and then excutede the control file trace sql with the SID change in ordrer to create actual control files with ORACLE_SID reset to actual DBSID. .

Also i use:

recover database until cancel using backup controlfile;

and not :

"recover database using backup controlfile until cancel"

Not sure though if that should make difference because if yours was erroneous oracle should have let you known.

What message comes when you try

alter database open

.

Regards.

Ruchit.

[Former Member]

Thanks Ruchit,

Problem has been resolved, in fact we have mounted two /oracle/<sid>/sapdata dir. through NFS partitioning and some parameters are missing in FSTAB hence oracle is not able to read/write in those mount point and as a results data recovery is not updating any status.

Regards,

Neehir Bhatt