| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN Core dumps while restoring datafile
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" <ORACLE-L_at_fatcity.com>
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> }
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-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 200214: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_40dl0215tag=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 destinationRMAN-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: ashoke.k.mandal_at_medtronic.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Apr 04 2002 - 07:43:26 CST
(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: rgramolini_at_tax.state.vt.us 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: ListGuru_at_fatcity.com (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).
 |
 |