As title, database archive logs are often full, I know is that "the alter database noarchivelog" instruction database can be set to the archive mode, but this all table operation log will not persist, unsafe, can set the specified table to the archive mode???????

CodePudding user response:

Have a great god for help to reassure??????????

CodePudding user response:

No, this file is the configuration of the instance,

Archive full you can backup to other position,,

CodePudding user response:

Want to security will have to open the archive mode, want more secure, have forced logs: the alter database force logging;
But, in fact, if you don't want to safety data, simply open the archive log and force, more importantly, you have to make a backup, backup not open the file is meaningless,

CodePudding user response:

reference minsic78 reply: 3/f

want to security will have to open the archive mode, want more secure, have forced logs: the alter database force logging;
But, in fact, if you don't want to safety data, simply open the archive log and force, more importantly, you have to make a backup, backup not open the file is meaningless,

Supplement: if your database as the main library of DG, or become OGG source libraries, so don't open backup archive and meaningful,
You said the closure of the table of log said is this? The alter table & lt; Table_name & gt; Nologging; This change in the force on the logging database doesn't matter, want to cool think security you must choose

CodePudding user response:

The original poster to estimate is:
The alter table tablename nologging;