Archive Log - Revision history

Nicolas: /* Activate Archive Log */

2017-05-28T06:54:12Z

Activate Archive Log

2017-05-28T06:51:10Z

Activate ARchive Log

2017-05-28T06:50:53Z

← Older revision		Revision as of 06:50, 28 May 2017
Line 1:		Line 1:
	* Database mode		== Activate ARchive Log ==
			* Validate Database mode
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	SELECT LOG_MODE FROM SYS.V$DATABASE;		SELECT LOG_MODE FROM SYS.V$DATABASE;
Line 26:		Line 27:
	ALTER DATABASE ARCHIVELOG;		ALTER DATABASE ARCHIVELOG;
	</syntaxhighlight>		</syntaxhighlight>

2017-05-28T06:00:06Z

← Older revision		Revision as of 06:00, 28 May 2017
Line 6:		Line 6:
	* Get Archive information		* Get Archive information
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	archive log list		archive log list;
			show parameter recovery_file_dest
	</syntaxhighlight>		</syntaxhighlight>

Line 19:		Line 20:
	</syntaxhighlight>		</syntaxhighlight>

	* ~~Ativate~~ Archive log		* Activate Archive log
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	SHUTDOWN		SHUTDOWN
Line 25:		Line 26:
	ALTER DATABASE ARCHIVELOG;		ALTER DATABASE ARCHIVELOG;
	</syntaxhighlight>		</syntaxhighlight>


			==Reference File==
			* V$DATABASE : select log_mode from v$database;
			* V$ARCHIVED_LOG
			* V$ARCHIVE_DEST : select DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;
			* V$ARCHIVE_PROCESSES
			* V$BACKUP_REDOLOG
			* V$LOG
			* V$LOG_HISTORY

2017-05-28T05:50:34Z

@@ Line 2: / Line 2: @@
 <syntaxhighlight lang="sql">
 SELECT LOG_MODE FROM SYS.V$DATABASE;
 </syntaxhighlight>

2017-05-28T05:42:30Z

Created page with "* Database mode <syntaxhighlight lang="sql"> SELECT LOG_MODE FROM SYS.V$DATABASE; </syntaxhighlight>"

New page

* Database mode
<syntaxhighlight lang="sql">
SELECT LOG_MODE FROM SYS.V$DATABASE;
</syntaxhighlight>