RMAN Core dumps while restoring datafile

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Wed, 03 Apr 2002 13:13:21 -0800
Message-ID: <F001.0043A687.20020403131321@fatcity.com>

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: 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-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). Received on Wed Apr 03 2002 - 15:13:21 CST