RE: RMAN Question

Are the tables you are loading in direct mode in the same tablespace as your other tables ?
If this is the case, then you will not be able to perform a complete recovery on the tablespace
affecting the other logged tables. Whenever I have a mix like you have, some logged and some not,
I keep the tables/indexes seperate. I hope this helps

-----Original Message-----
Sent: 10 May 2001 18:16
To: Multiple recipients of list ORACLE-L

DBAs,

I have two of my tables and index in nologging mode as I am loading data using SQL*Loader direct path mode.

I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE, I am getting both the Data and Index datafiles are unrecoverable.

I know that I wont be able to recover the tables in nologging mode. What I would like to know is about the recovery possibility of other tables in logging mode. Will there be any problem during recovery as these datafiles are in unrecoverable status?

TIA Cheers

Raj

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
  INET: raj.gopalan_at_netdecisions.co.uk

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: holders
  INET: holders_at_holders.demon.co.uk

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