Standby and NOLOGGING


Having a standby database is great until some developer sneaks in and puts NOLOGGING clauses throughout all of their scripts and you only find out that half your database is missing AFTER the disaster strikes...

Well, no you can protect your standby from such problems by issuing:

alter database force logging

and all subsequent changes will be logged (even if NOLOGGING is specified)