Home » RDBMS Server » Backup & Recovery » Error while creating duplicate database with RMAN (ORACLE 10.2.0.4)
Error while creating duplicate database with RMAN [message #427995] Mon, 26 October 2009 12:56 Go to next message
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.Cool 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
Re: Error while creating duplicate database with RMAN [message #427997 is a reply to message #427995] Mon, 26 October 2009 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please suggest....

Wait for logins to complete......

Regards
Michel
Re: Error while creating duplicate database with RMAN [message #428004 is a reply to message #427997] Mon, 26 October 2009 14:01 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi Micheal,

Thanks for reply.

Can you tell me how much long time should i wait? Which logins?


Regards,
Vishal Pingale
Re: Error while creating duplicate database with RMAN [message #428008 is a reply to message #428004] Mon, 26 October 2009 15:12 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Those that are on the database, you have to wait until users disconnect.

Regards
Michel
Re: Error while creating duplicate database with RMAN [message #428009 is a reply to message #428008] Mon, 26 October 2009 15:20 Go to previous message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hello Michel,

just now i resolved an error. Actually, bymistake i was login in another session (i.e startup force nomount at duplicate db instance ). i log off from session and duplication process on RMAN got completed with out errors.

Thanks,
Vishal
Previous Topic: shell script for cold backup
Next Topic: RMAN convert used for user managed backup
Goto Forum:
  


Current Time: Sun Sep 25 07:48:58 CDT 2016

Total time taken to generate the page: 0.07820 seconds