Home » Server Options » Data Guard » Logical dataguard - No-logging in force logging (10g, 10.2.0.4, hp unix)
Logical dataguard - No-logging in force logging [message #634606] Thu, 12 March 2015 00:11 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

Need clarification regarding the force logging.

We have logical standby database. During creation of table we are using syntax 
create table <tablename> as select * from <tablename>


Will this generate logs or it will happened with generating logs?

Regards,
Ashish Kumar Mahanta

Report message to a moderator

Re: Logical dataguard - No-logging in force logging [message #634611 is a reply to message #634606] Thu, 12 March 2015 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you see when you made a test?

Report message to a moderator

Re: Logical dataguard - No-logging in force logging [message #634622 is a reply to message #634611] Thu, 12 March 2015 03:50 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
It was done 2 days before and standby is logical. So we don't logs were generated or not.
Since in data-guard, we executed force logging so might be log were generated. It have queried just for clarification.

Regards,
Ashish

Report message to a moderator

Re: Logical dataguard - No-logging in force logging [message #634623 is a reply to message #634622] Thu, 12 March 2015 03:52 Go to previous message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No problem, you can redo the same test and now watch if and what log is generated.

Report message to a moderator

Previous Topic: deleting old archived log?
Next Topic: Sequence of archive log list show zero at physical standby
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 27 19:10:38 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.