Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while rman cloning (Segmentation fault)

poornaJan 24 2011 — edited Jan 24 2011
Hi All,

Oracle version :10.2.0.1
Operating system:linux

When we tried to do rman cloning through catalog we get the following error here my clon database is in server A and my target and clon database's are in server B.

Please find the error below.
[oracle@test1161 ~]$ rman catalog rman/rman target sys/qfund@test
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jan 23 22:24:05 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: TEST (DBID=2034916279)
connected to recovery catalog database

RMAN> connect auxiliary sys/poor123@poor

connected to auxiliary database: POOR (not mounted)

RMAN> duplicate target database to poor;

Starting Duplicate Db at 23-JAN-11
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK

contents of Memory Script:
{
   set until scn  22564684;
   set newname for datafile  1 to
 "/u02/poor/oradata/system01.dbf";
   set newname for datafile  2 to
 "/u02/poor/oradata/undotbs01.dbf";
   set newname for datafile  3 to
 "/u02/poor/oradata/sysaux01.dbf";
   set newname for datafile  4 to
 "/u02/poor/oradata/users01.dbf";
   set newname for datafile  5 to
 "/u02/poor/oradata/example01.dbf";
   set newname for datafile  6 to
 "/u02/poor/oradata/poorna.dbf";
   set newname for datafile  7 to
 "/u02/poor/oradata/bigtbs_01.dbf";
   set newname for datafile  8 to
 "/u02/poor/oradata/lak_tbs01.dbf";
   set newname for datafile  9 to
 "/u02/poor/oradata/vir2_01.dbf";
   set newname for datafile  10 to
 "/u02/poor/oradata/lak_tbs2_01.dbf";
   set newname for datafile  11 to
 "/u02/poor/oradata/vir_user01.dbf";
   set newname for datafile  12 to
 "/u02/poor/oradata/vir_bigf01.dbf";
   set newname for datafile  17 to
 "/u02/poor/oradata/hrscott.dbf";
   restore
   check readonly
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 23-JAN-11
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
restoring datafile 00003 to /u02/poor/oradata/sysaux01.dbf
restoring datafile 00004 to /u02/poor/oradata/users01.dbf
restoring datafile 00005 to /u02/poor/oradata/example01.dbf
restoring datafile 00006 to /u02/poor/oradata/poorna.dbf
restoring datafile 00007 to /u02/poor/oradata/bigtbs_01.dbf
restoring datafile 00008 to /u02/poor/oradata/lak_tbs01.dbf
restoring datafile 00009 to /u02/poor/oradata/vir2_01.dbf
restoring datafile 00010 to /u02/poor/oradata/lak_tbs2_01.dbf
restoring datafile 00011 to /u02/poor/oradata/vir_user01.dbf
restoring datafile 00012 to /u02/poor/oradata/vir_bigf01.dbf
restoring datafile 00017 to /u02/poor/oradata/hrscott.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0/db_1/dbs/1pm2tq5e_1_1
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/1pm2tq5e_1_1 tag=TAG20110124T124846
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:45
Finished restore at 23-JAN-11
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "POOR" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( '/u02/poor/oradata/redo1a.log' ) SIZE 50 M  REUSE,
  GROUP  2 ( '/u02/poor/oradata/redo2a.log', '/u02/poor/oradata/redo2b.log' ) SIZE 50 M  REUSE,
  GROUP  3 ( '/u02/poor/oradata/redo3a.log', '/u02/poor/oradata/redo1b.log', '/u02/poor/oradata/redo3b.log' ) SIZE 50 M  REUSE
 DATAFILE
  '/u02/poor/oradata/system01.dbf'
 CHARACTER SET WE8ISO8859P1


contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=741272711 filename=/u02/poor/oradata/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=741272711 filename=/u02/poor/oradata/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=741272711 filename=/u02/poor/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=741272711 filename=/u02/poor/oradata/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=741272711 filename=/u02/poor/oradata/poorna.dbf
datafile 7 switched to datafile copy
input datafile copy recid=6 stamp=741272711 filename=/u02/poor/oradata/bigtbs_01.dbf
datafile 8 switched to datafile copy
input datafile copy recid=7 stamp=741272711 filename=/u02/poor/oradata/lak_tbs01.dbf
datafile 9 switched to datafile copy
input datafile copy recid=8 stamp=741272711 filename=/u02/poor/oradata/vir2_01.dbf
datafile 10 switched to datafile copy
input datafile copy recid=9 stamp=741272711 filename=/u02/poor/oradata/lak_tbs2_01.dbf
datafile 11 switched to datafile copy
input datafile copy recid=10 stamp=741272711 filename=/u02/poor/oradata/vir_user01.dbf
datafile 12 switched to datafile copy
input datafile copy recid=11 stamp=741272711 filename=/u02/poor/oradata/vir_bigf01.dbf
datafile 17 switched to datafile copy
input datafile copy recid=12 stamp=741272711 filename=/u02/poor/oradata/hrscott.dbf

contents of Memory Script:
{
   set until scn  22563972;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 23-JAN-11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=158 devtype=DISK

starting media recovery

archive log thread 1 sequence 23 is already on disk as file /u02/archive/1_23_741021347.dbf
archive log thread 1 sequence 24 is already on disk as file /u02/archive/1_24_741021347.dbf
archive log thread 1 sequence 25 is already on disk as file /u02/archive/1_25_741021347.dbf
archive log thread 1 sequence 26 is already on disk as file /u02/archive/1_26_741021347.dbf
archive log thread 1 sequence 27 is already on disk as file /u02/archive/1_27_741021347.dbf
archive log thread 1 sequence 28 is already on disk as file /u02/archive/1_28_741021347.dbf
archive log thread 1 sequence 29 is already on disk as file /u02/archive/1_29_741021347.dbf
archive log thread 1 sequence 30 is already on disk as file /u02/archive/1_30_741021347.dbf
archive log thread 1 sequence 31 is already on disk as file /u02/archive/1_31_741021347.dbf
archive log thread 1 sequence 32 is already on disk as file /u02/archive/1_32_741021347.dbf
archive log thread 1 sequence 33 is already on disk as file /u02/archive/1_33_741021347.dbf
archive log thread 1 sequence 34 is already on disk as file /u02/archive/1_34_741021347.dbf
archive log thread 1 sequence 35 is already on disk as file /u02/archive/1_35_741021347.dbf
archive log thread 1 sequence 36 is already on disk as file /u02/archive/1_36_741021347.dbf
archive log thread 1 sequence 37 is already on disk as file /u02/archive/1_37_741021347.dbf
archive log thread 1 sequence 38 is already on disk as file /u02/archive/1_38_741021347.dbf
archive log filename=/u02/archive/1_23_741021347.dbf thread=1 sequence=23
archive log filename=/u02/archive/1_24_741021347.dbf thread=1 sequence=24
archive log filename=/u02/archive/1_25_741021347.dbf thread=1 sequence=25
archive log filename=/u02/archive/1_26_741021347.dbf thread=1 sequence=26
archive log filename=/u02/archive/1_27_741021347.dbf thread=1 sequence=27
archive log filename=/u02/archive/1_28_741021347.dbf thread=1 sequence=28
archive log filename=/u02/archive/1_29_741021347.dbf thread=1 sequence=29
archive log filename=/u02/archive/1_30_741021347.dbf thread=1 sequence=30
archive log filename=/u02/archive/1_31_741021347.dbf thread=1 sequence=31
archive log filename=/u02/archive/1_32_741021347.dbf thread=1 sequence=32
archive log filename=/u02/archive/1_33_741021347.dbf thread=1 sequence=33
archive log filename=/u02/archive/1_34_741021347.dbf thread=1 sequence=34
archive log filename=/u02/archive/1_35_741021347.dbf thread=1 sequence=35
archive log filename=/u02/archive/1_36_741021347.dbf thread=1 sequence=36
archive log filename=/u02/archive/1_37_741021347.dbf thread=1 sequence=37
archive log filename=/u02/archive/1_38_741021347.dbf thread=1 sequence=38
media recovery complete, elapsed time: 00:00:04
Finished recover at 23-JAN-11

contents of Memory Script:
{
   shutdown clone;
   startup clone nomount ;
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     524288000 bytes

Fixed Size                     1220384 bytes
Variable Size                134217952 bytes
Database Buffers             385875968 bytes
Redo Buffers                   2973696 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "POOR" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( '/u02/poor/oradata/redo1a.log' ) SIZE 50 M  REUSE,
  GROUP  2 ( '/u02/poor/oradata/redo2a.log', '/u02/poor/oradata/redo2b.log' ) SIZE 50 M  REUSE,
  GROUP  3 ( '/u02/poor/oradata/redo3a.log', '/u02/poor/oradata/redo1b.log', '/u02/poor/oradata/redo3b.log' ) SIZE 50 M  REUSE
 DATAFILE
  '/u02/poor/oradata/system01.dbf'
 CHARACTER SET WE8ISO8859P1


contents of Memory Script:
{
   set newname for tempfile  1 to
 "/u02/poor/oradata/temp.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "/u02/poor/oradata/undotbs01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/sysaux01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/users01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/example01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/poorna.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/bigtbs_01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/lak_tbs01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/vir2_01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/lak_tbs2_01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/vir_user01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/vir_bigf01.dbf";
   catalog clone datafilecopy  "/u02/poor/oradata/hrscott.dbf";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /u02/poor/oradata/temp.dbf in control file

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/undotbs01.dbf recid=1 stamp=741272727

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/sysaux01.dbf recid=2 stamp=741272727

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/users01.dbf recid=3 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/example01.dbf recid=4 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/poorna.dbf recid=5 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/bigtbs_01.dbf recid=6 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/lak_tbs01.dbf recid=7 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/vir2_01.dbf recid=8 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/lak_tbs2_01.dbf recid=9 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/vir_user01.dbf recid=10 stamp=741272728

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/vir_bigf01.dbf recid=11 stamp=741272729

cataloged datafile copy
datafile copy filename=/u02/poor/oradata/hrscott.dbf recid=12 stamp=741272729

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=741272727 filename=/u02/poor/oradata/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=741272727 filename=/u02/poor/oradata/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=741272728 filename=/u02/poor/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=741272728 filename=/u02/poor/oradata/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=741272728 filename=/u02/poor/oradata/poorna.dbf
datafile 7 switched to datafile copy
input datafile copy recid=6 stamp=741272728 filename=/u02/poor/oradata/bigtbs_01.dbf
datafile 8 switched to datafile copy
input datafile copy recid=7 stamp=741272728 filename=/u02/poor/oradata/lak_tbs01.dbf
datafile 9 switched to datafile copy
input datafile copy recid=8 stamp=741272728 filename=/u02/poor/oradata/vir2_01.dbf
datafile 10 switched to datafile copy
input datafile copy recid=9 stamp=741272728 filename=/u02/poor/oradata/lak_tbs2_01.dbf
datafile 11 switched to datafile copy
input datafile copy recid=10 stamp=741272728 filename=/u02/poor/oradata/vir_user01.dbf
datafile 12 switched to datafile copy
input datafile copy recid=11 stamp=741272729 filename=/u02/poor/oradata/vir_bigf01.dbf
datafile 17 switched to datafile copy
input datafile copy recid=12 stamp=741272729 filename=/u02/poor/oradata/hrscott.dbf

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

*Segmentation fault*
Please help me to solve the problem.

Thanks & Regards,
Poorna Prasad.S

Edited by: SIDDABATHUNI on Jan 24, 2011 1:28 PM
This post has been answered by Chinar on Jan 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2011
Added on Jan 24 2011
#general-database-discussions
20 comments
3,248 views