Note: It is recommended to perform a backup of the database (after a shutdown normal or immediate) prior to changing the archive status of a database.
- Alter Database Add File
- Alter System Archivelog Disable
- Alter Database Sql Server
- Alter Database Archivelog Enable Ssh
Alter Database Add File
Total System Global Area 417546240 bytes Fixed Size 2213936 bytes Variable Size 301991888 bytes Database Buffers 109051904 bytes Redo Buffers 4288512 bytes Database mounted. SQL alter database archivelog; Database altered. Open the database and check the result. SQL alter database open; Database altered. SQL SQL select logmode from v. Step 8) Enable Archivemode on DB. SQL alter database archivelog; Database altered. Step 9) Stop and Start the DB. oracle@prddb01 $ srvctl stop database -d PRDDB oracle@prddb01 $ srvctl start database -d PRDDB oracle@prddb01 $ sqlplus ‘/ as sysdba’ SQL archive log list; Database log mode Archive Mode Automatic archival Enabled. Enabling archive mode is simple, just connect to your database in mounted but closed mode (startup mount) and alter the database. But if you don't tune alittle you'll run into problems down the road, so lets specify some parameters too.
If you would like to perform these tasks using Database Console see the post Enable/Disable Archive Log Mode 10g/11g using Database Console.
In this is the article we are going to see Enabling Archive Log Mode In Oracle 19c RAC Database Step:-1 Before Changing the archivelog mode check the status. SQL select logmode,name from v$database. Now we enable the archive log mode by issuing this command and open the database SQL alter database archivelog; Database altered. SQL alter database open; Database altered.
Enable Archive Log Mode
The following are the steps required to enable archive log mode on an Oracle 10g or 11g database.
Verify the database log mode.
The log mode is No Archive Mode. Note that Archive destination is
USE_DB_RECOVERY_FILE_DEST
. You can determine the path by looking at the parameter RECOVERY_FILE_DEST
.By default, archive logs will be written to the flash recovery area. If you do not want to write archive logs to the flash recovery area you can set the parameter
LOG_ARCHIVE_DEST_n
to the location in which you wish to write archive logs.Now we shutdown the database and bring it backup in mount mode.
Lastly all that is needed it set archive log mode and open the database.
We can now see that archive log mode is enabled. Notice that Automatic archive is enabled as well. In Oracle 9i an earlier another parameter needed to be set in order to enable automatic archiving. This in no longer the case in 10g and 11g as automatic archiving is enabled when the database is placed in archive log mode.
You can switch to the log file to see that an archive is written to archive log location.
Alter System Archivelog Disable
Disable Archive Log Mode
Note: It is recommended to perform a backup of the database (after a shutdown normal or immediate) prior to changing the archive status of a database.
The following are the steps required to disable archive log mode on an Oracle 10g or 11g database.
Verify the database log mode.
The Database log mode is Archive mode. Next we shut down the database and bring up back up in mount mode.
Alter Database Sql Server
All that is left is to disable archive log mode and open the database.
Alter Database Archivelog Enable Ssh
As you can see,
ARCHIVELOG
mode has been disabled.