RE: RMAN Report question

From: Mike Killough <mwkillough_at_hotmail.com>
Date: Wed, 14 Jul 2004 00:03:05 +0000
Message-ID: <BAY17-F15vwa2SydHsn0002ec84@hotmail.com>

It works for me (9.2.0.4 / Sun):

R7ORACLE:system:r7orcl1> create table scott.emp_tmp2 tablespace users nologging as select * from scott.emp;

Table created.

R7ORACLE:system:r7orcl1> SELECT name, status, UNRECOVERABLE_CHANGE#,   2 TO_CHAR(UNRECOVERABLE_TIME, 'mm-dd-yyyy hh:mi:ss') unrecoverable_time
  3 FROM V$DATAFILE
  4 WHERE unrecoverable_time > sysdate - 1;

NAME                                               STATUS

UNRECOVERABLE_CHANGE# UNRECOVERABLE_TIME

-------------------------------------------------- ------- 
--------------------- -------------------
/oraclefs-perf/R7ORACLE/users01.dbf                ONLINE

1530452425 07-13-2004 06:57:33

RMAN> report unrecoverable database;

Report of files that need backup due to unrecoverable operations File Type of Backup Required Name

---- ----------------------- -----------------------------------
6    full or incremental     /oraclefs-perf/R7ORACLE/users01.dbf

>From: Michael Thomas <mhthomas_at_yahoo.com>
>Reply-To: oracle-l_at_freelists.org
>To: Multiple recipients of list ORACLE-L <oracle-l_at_freelists.org>
>Subject: RMAN Report question
>Date: Tue, 13 Jul 2004 15:29:25 -0700 (PDT)
>
>Hi,
>
>Version 9.2.0.4
>
>Does anyone get the following RMAN command to work for
>a nologging operation in target db?
>
>RMAN> report unrecoverable;
>
>Mine does not seem to return anything.
>
>I'm told rebuild index command might work. But, the
>standard 'create table as select *' and 'create index'
>with nologging did not seem to produce any results in
>RMAN.
>
>I have to wait to tomorrow to test the rebuild index
>idea.
>
>Regards,
>
>Mike Thomas
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Mail - 50x more storage than other providers!
>http://promotions.yahoo.com/new_mail
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------

FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 13 2004 - 18:59:45 CDT