Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use the nologing of oracle dataguard, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Management part

If database force logging is not enabled, the slave library will report bad blocks for / * + append * / operation and nologging operation.

Recommended tablespace force logging or database force logging

Test:

Select force_logging, tablespace_name from dba_tablespaces where tablespace_name in (select default_tablespace from dba_users where username = 'SCOTT');-- FORCE_LOGGING TABLESPACE_NAMENO TESTcreate table T1 noglogging as select * from user_tables

For database inquiries:

Select * from T1 * ORAmuri 01578: ORACLE data block corrupted (file # 8, block # 483) ORA-01110: data file 8:'/ data/db/test1.dbf'ORA-26040: Data block was loaded using the NOLOGGING option

But the following is fine.

Select * from T1 where rownum'SCOTT',tabname= > 'T1century Magazine cascade> TRUE); endselect table_name,num_rows,logging from user_tables where table_name='T1'

The statistics are also synchronized; that is, everything in the table structure is normal, that is, the data in this table cannot be synchronized.

Solution:

The main library deletes the table and rebuilds it, or restores the corresponding data files.

-- related sql

Alter database force logging;select force_logging from dba_tablespaces;select force_logging from vested database alter tablespace test force logging;select logging,table_name,tablespace_name from user_tables where table_name = 'TEST';alter tablespace test no force logging;select tablespace_name,logging,force_logging from dba_tablespaces; above is all the content of this article entitled "how to use nologing of oracle dataguard". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.