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).
