Enable/Disable Archive Log Mode Oracle 10g/11g

-
A very very very good and clear explanation from here : http://www.oracledistilled.com/oracle-database/backup-and-recovery/enabledisable-archive-log-mode-10g11g/

To Disable:

sqlplus / as sysdba
shutdown immediate
startup mount
alter database noarchivelog;
alter database open;
archive log list;

 To Enable:

 sqlplus / as sysdba
archive log list
show parameter recovery_file_dest
alter system set log_archive_dest_1='LOCATION=/path/orcl/arch' scope = both;
shutdown immediate
startup mount
alter database archivelog;
alter database open;
archive log list

 //alak

Comments

Post a Comment

Popular posts from this blog

Quick Dirty Script for Checking Oracle Data Gurad Gap and Emailing it

-
 Situation: primary DB: prd_CCC standby DB: prd_WWW file 1: gap-check.bat @echo off cls echo. echo. echo This script checks for Archive Logs at prd_ccc and Applied Logs at prd_www echo. echo Querying prd_ccc (Primary) echo select max(sequence#) "Primary" from v$archived_log where archived='YES';|sqlplus -s / as sysdba echo Querying prd_www (Standby) echo select max(sequence#) "Standby" from v$archived_log where applied='YES';|sqlplus -s / as sysdba echo. DGMGRL / "show configuration" date /t && time /t && hostname && whoami file 2: emailer.ps1 $Username      = "username" $EmailPassword = "password" $today = Get-Date $Username = $Username $EmailTo = "adam@jasabyte.com"  $EmailFrom = "server@jasabyte.com" $Body = Get-Content .\status.log -Raw $Subject = "PRIMARY/STANDBY DB GAP - $today" $SMTPServer = "mail.smtp2go.com"  $SMTPMessage = New-Object System.Net.Mai...
Read more

SAP MAXDB Log Overwrite

-
  Logon as SIDadm in my case is windows run elevated command prompt Microsoft Windows [Version 10.0.17763.2366] (c) 2018 Microsoft Corporation. All rights reserved. C:\Windows\system32>color f1 C:\Windows\system32>dbmcli -d XYZ -u SUPERDBA,Pass#1 -c db_execute set log auto overwrite on OK C:\Windows\system32>dbmcli -d XYZ -u SUPERDBA,Pass#1 -c sql_execute select automaticoverwrite from loginformation OK END 'YES' C:\Windows\system32> //alak
Read more