Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> filesystem_like_logging is not in ddl of table
Chadori2000
post May 15 2017, 07:09 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 8-December 16
Member No.: 51,682



Hi,

A table with blob column and filesystem_like_logging feature is created using following script:

CODE
create table contracts_sec_fs
(
        contract_id     number(12),
        contract_name   varchar2(80),
        file_size       number,
        orig_file       blob
)
tablespace users
lob (orig_file)
store as securefile
(
        tablespace users
        enable storage in row
        chunk 8192
        pctversion 20
        nocache
filesystem_like_logging
)

But filesystem_like_logging is not in ddl of table( also in toad, filesystem_like_logging feature is unchecked in properties of blob column )

CODE
CREATE TABLE "CHAD"."CONTRACTS_SEC_FS"
   (    "CONTRACT_ID" NUMBER(12,0),
    "CONTRACT_NAME" VARCHAR2(80 BYTE),
    "FILE_SIZE" NUMBER,
    "ORIG_FILE" BLOB
   ) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
  TABLESPACE "users"
LOB ("ORIG_FILE") STORE AS SECUREFILE (
  TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE NOLOGGING  NOCOMPRESS  KEEP_DUPLICATES );


Any help on this would be very helpful.
Thanks in advance.
Go to the top of the page
 
+Quote Post
burleson
post May 22 2017, 09:35 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,416
Joined: 26-January 04
Member No.: 13



Hi Chadori,

>> filesystem_like_logging is not in ddl of table( also in toad, filesystem_like_logging feature is unchecked in properties of blob column )

This may help:

http://www.dba-oracle.com/t_11g_new_shared_io_pool.htm

Securefile lobs can be created with different LOGGING options.

The default is LOGGING which creates redo records for the creation of the lob segment as well as for the subsequent changes.

Another alternative is FILESYSTEM_LIKE_LOGGING. This only created redo for the metadata of the securefile lob. This reduces the mean time to recover in case of an instance crash. At the same time full data recoverability is ensured. The drawback here is that data can change during an online backup which would lead to inconsistency in. This would be fatal in case of media recovery being necessary.

% Make sure that LOGGING is enforced for the lob storage during online backups!

% Make sure that all redo which was generated during the online backup is archived!

Here is the syntax to enforce logging and to disable it again:

LUTZ AS SYSDBA @ orcl SQL> ALTER DATABASE FORCE LOGGING;
?
LUTZ AS SYSDBA @ orcl SQL> ALTER DATABASE NO FORCE LOGGING;





--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Chadori2000
post May 23 2017, 05:58 AM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 8-December 16
Member No.: 51,682



I'm so grateful for your great reply. Thank you so much.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 30th May 2017 - 02:26 AM