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