OraFAQ Forum: Data Guard » Data Gurad in NOLOGGING Environment

Home » Server Options » Data Guard » Data Gurad in NOLOGGING Environment

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Data Gurad in NOLOGGING Environment [message #251898]

Tue, 17 July 2007 02:09

majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan

Member

Can Data Guard feature work in NOLOGGING Environment. Suppose we create table using nologging mode can data guard work or not

Report message to a moderator

Re: Data Gurad in NOLOGGING Environment [message #251906 is a reply to message #251898]

Tue, 17 July 2007 02:20

Michel Cadot
Messages: 54672
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What does Data Guard documentation say?

Regards
Michel

Report message to a moderator

Re: Data Gurad in NOLOGGING Environment [message #251919 is a reply to message #251906]

Tue, 17 July 2007 02:56

majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan

Member

Well according to my knowledge DATA GUARD is not work in NOLOGGING mode. Is there any other way, I just want to get a second opinion.

Report message to a moderator

Re: Data Gurad in NOLOGGING Environment [message #251978 is a reply to message #251898]

Tue, 17 July 2007 10:38

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

majid tahir wrote on Tue, 17 July 2007 01:09

Can Data Guard feature work in NOLOGGING Environment. Suppose we create table using nologging mode can data guard work or not

yes your dataguard work in both modes logging and nologging but in nologging some of the tables .anbd transaction would be miss.

Nologging means no redo if no redo no redo would transfer to standby .

As you know dataguard get data from archiveslogs or standbylogfiles so its really really important for your database should be in logging mode.

And this is the ist command in dataguard configuyration steps

• SQL> Alter database Force Logging;

Report message to a moderator

Re: Data Gurad in NOLOGGING Environment [message #251979 is a reply to message #251919]

Tue, 17 July 2007 10:42

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

majid tahir wrote on Tue, 17 July 2007 01:56

Well according to my knowledge DATA GUARD is not work in NOLOGGING mode. Is there any other way, I just want to get a second opinion.

Quote:

NOLOGGING or Unrecoverable Operations
When you perform a DML or DDL operation using the NOLOGGING or
UNRECOVERABLE clause, the standby database is invalidated and might require
substantial DBA administrative activities to repair. You can specify the SQL ALTER
DATABASE or SQL ALTER TABLESPACE statement with the FORCELOGGING clause to
override the NOLOGGING setting. However, this statement will not repair an already
invalidated database.

Quote:

Oracle� Data Guard
Concepts and Administration
10g Release 2 (10.2)
B14239-04

Report message to a moderator