Ruth, As we are recovering only one datafile we should be able to restore and recover when the database is open.
I am not sure why it core dumps instead of reporting an error. Thanks, Ashoke -----Original Message----- Sent: Thursday, April 04, 2002 7:43 AM To: Multiple recipients of list ORACLE-L I don't think you need to take the tablespace offline. I never do when I restore a datafile. The database must be in mount state also. HTH, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 4:13 PM Greetings all, I was trying restore one data file but it core dumps. Following is the log file but didnot specify any error. Any idea. Thanks, Ashoke unix> Segmentation Fault - core dumped Recovery Manager: Release 8.1.7.0.0 - Production RMAN-06005: connected to target database: PTESTAKM (DBID=1408056539) RMAN-06008: connected to recovery catalog database RMAN> run { 2> allocate channel t1 type 'SBT_TAPE' 3> parms 'ENV=(NSR_SERVER=torra.pace.medtronic.com)'; 4> 5> sql "alter tablespace USERS offline immediate"; 6> 7> restore datafile '/u02/oradata/ptestakm/users01.dbf'; 8> recover datafile '/u02/oradata/ptestakm/users01.dbf'; 9> 10> sql "alter tablespace USERS online"; 11> } 12> 13> RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: t1 RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE RMAN-08526: channel t1: BMO v3.0 RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter tablespace USERS offline immediate RMAN-03023: executing command: sql RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel t1: starting datafile backupset restore RMAN-08502: set_count=128 set_stamp=458229797 creation_time=Apr 03 2002 14:03:17 RMAN-08089: channel t1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 00004 to /u02/oradata/ptestakm/users01.dbf RMAN-08023: channel t1: restored backup piece 1 RMAN-08511: piece handle=full_PTESTAKM_128_458229797_40dl0215 tag=FULL_PTESTAKM_BACKUP params=NULL RMAN-08024: channel t1: restore complete RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete RMAN-03022: compiling command: recover RMAN-03022: compiling command: recover(1) RMAN-03022: compiling command: recover(2) RMAN-03022: compiling command: recover(3) RMAN-03023: executing command: recover(3) RMAN-08054: starting media recovery RMAN-03022: compiling command: recover(4) RMAN-03023: executing command: recover(4) RMAN-08017: channel t1: starting archivelog restore to default destination RMAN-08022: channel t1: restoring archivelog RMAN-08510: archivelog thread=1 sequence=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).