| Error while creating duplicate database with RMAN [message #427995] |
Mon, 26 October 2009 12:56  |
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
|
Junior Member |
|
|
Hello,
I have tried many time to create a duplicate database with RMAN but it stuck at below mentioned command.
contents of Memory Script:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Script
I have attached the alert log file and below mentioned the contains of trace file.
Dump file d:\oracle\product\10.2.0\admin\auxdb\udump\auxdb_ora_2876.trc
Sun Oct 25 15:39:00 2009
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:51M/503M, Ph+PgF:205M/1251M, VA:1700M/2047M
Instance name: auxdb
Redo thread mounted by this instance: 0 <none>
Oracle process number: 16
Windows thread id: 2876, image: ORACLE.EXE (SHAD)
*** 2009-10-25 15:39:00.905
*** ACTION NAME:(0000014 FINISHED64) 2009-10-25 15:39:00.873
*** MODULE NAME:(rman.exe) 2009-10-25 15:39:00.873
*** SERVICE NAME:() 2009-10-25 15:39:00.873
*** SESSION ID:(157. 2009-10-25 15:39:00.873
Control file created with size 450 blocks
*** 2009-10-25 15:39:16.341
*** ACTION NAME:(0000026 FINISHED60) 2009-10-25 15:39:16.341
Recovery target incarnation = 1, activation ID = 0
Influx buffer limit = 3493 min(50% x 6986, 10000)
Start recovery at thread 1 ckpt scn 4145873 logseq 136 block 54
*** 2009-10-25 15:39:17.341
Media Recovery add redo thread 1
*** ACTION NAME:(0000028 FINISHED65) 2009-10-25 15:39:20.248
*** 2009-10-25 15:39:20.248
Media Recovery Log D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TESTRMAN\ARCHIVELOG\2009_10_25\O1_MF_1_136_5G838J3J_.ARC
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 604Kb in 4.11s => 0.14 Mb/sec
Total physical reads: 604Kb
Longest record: 21Kb, moves: 0/1373 (0%)
Change moves: 999/4255 (23%), moved: 0Mb
Longest LWN: 115Kb, moves: 0/67 (0%), moved: 0Mb
Last redo scn: 0x0000.003f4400 (4146176)
----------------------------------------------
*** 2009-10-25 15:39:21.466
Media Recovery drop redo thread 1
KCBR: Number of read descriptors = 1024
KCBR: Media recovery blocks read (ASYNC) = 282
KCBR: Redo cache copies/changes = 1723/1723
KCBR: Influx buffers flushed = 2 times
KCBR: Reads = 4 reap (2 no-op, 0 one), 8 all
*** 2009-10-25 15:44:27.314
*** ACTION NAME:(0000033 FINISHED88) 2009-10-25 15:44:27.298
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 15:49:27.459
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 15:54:27.557
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 15:59:27.623
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 16:04:27.768
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 16:09:27.897
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 16:14:27.932
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 16:19:28.015
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 16:24:28.097
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 16:29:28.116
SHUTDOWN: waiting for logins to complete.
*** 2009-10-25 16:34:28.182
SHUTDOWN: waiting for logins to complete.
Please suggest....
Regards,
Vishal Pingale
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
