Скачать или смотреть How to enable archivelog mode

[email protected] Chirag's Oracle DBA Tutorial https://www.chirags.in
*****************************************************************************************
How to enable archivelog mode in Oracle *
*****************************************************************************************
Running a Database in ARCHIVELOG Mode

When you run a database in ARCHIVELOG mode, you enable the archiving of the redo log. The database control file indicates that a group of filled redo log files cannot be reused by LGWR until the group is archived. A filled group becomes available for archiving immediately after a redo log switch occurs.

Steps: ---
Log in as user oracle and enter the following commands:
Open cmd in Windows.

$ export ORACLE_SID=orcl
(if your database is already orcl the no need to export.)
where orcl is the name of the database.

$ sqlplus /nolog
SQL⇒ connect / as sysdba

Check the ARCHIVELOG mode.
SQL⇒ archive log list;

So archivelog is Disabled here. lets flow the below command to enable archivelog mode.

To enable ARCHIVELOG mode status, enter the following SQL commands:

SQL⇒ Shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL⇒ startup mount
ORACLE instance started.

Total System Global Area 3390558208 bytes
Fixed Size 2180464 bytes
Variable Size 1996491408 bytes
Database Buffers 1375731712 bytes
Redo Buffers 16154624 bytes
Database mounted.

SQL⇒ Alter database archivelog;
Database altered.

SQL⇒ alter database open;

To check the ARCHIVELOG mode status, enter the following SQL command:
SQL⇒ archive log list;

Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 29
Next log sequence to archive 31
Current log sequence 31

So database arhivelog is enabled now.

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
   / @chiragtutorial  
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags
#ChiragTutorial
#ChiragsTutorial
#Chirags
#Chirag
#ChittRanjanMahto
#ChiragMahto
#HowToEnableArchivelogModeInOracle
#EnableArchivelogMode
#OracleArchivelogMode
#ArchivelogMode
#OracleDatabase
#OracleTutorial
#OracleDBA
#OracleBackup
#OracleRecovery
#OracleDatabaseAdministration
#OracleArchiving
#OracleLogs
#DatabaseArchivelog
#Archivelog
#OracleBackupStrategy
#OracleRecoveryMode
#OracleDatabaseBackup
#OracleDatabaseRecovery
#Oracle19c
#Oracle12c
#Oracle11g
#Oracle10g
#Oracle9i
#Oracle8i
#OracleDatabaseTutorial
#OracleDBATutorial
#OracleDatabaseManagement
#OracleDatabaseTips
#OracleDatabaseTricks
#OracleDatabaseGuide
#OracleDatabaseHelp
#OracleDatabaseSupport
#OracleDatabaseTraining
#OracleDatabaseCourse
#OracleDatabaseLessons
#OracleDatabaseEducation
#OracleDatabaseLearning
#OracleDatabaseSkills
#OracleDatabaseExpert
#OracleDatabaseProfessional
#OracleDatabaseCertification
#OracleDatabaseExam
#OracleDatabaseInterview
#OracleDatabaseJobs
#OracleDatabaseCareer
#OracleDatabaseOpportunities
#OracleDatabaseMarket
#OracleDatabaseIndustry
#OracleDatabaseCommunity
#OracleDatabaseForum
#OracleDatabaseDiscussion
#OracleDatabaseQandA
#OracleDatabaseResources
#OracleDatabaseMaterials
#OracleDatabaseDocs
#OracleDatabaseDocumentation
#OracleDatabaseReference
#OracleDatabaseManual
#OracleDatabaseGuidebook
#OracleDatabaseInstructions
#OracleDatabaseProcedures
#OracleDatabaseMethods
#OracleDatabaseTechniques
#OracleDatabaseApproach
#OracleDatabaseStrategies
#OracleDatabasePlans
#OracleDatabaseBlueprint
#OracleDatabaseArchitecture
#OracleDatabaseDesign
#OracleDatabaseStructure
#OracleDatabaseFramework
#OracleDatabaseModel
#OracleDatabaseSchema
#OracleDatabaseTables
#OracleDatabaseViews
#OracleDatabaseIndexes
#OracleDatabaseSequences
#OracleDatabaseSynonyms
#OracleDatabaseTriggers
#OracleDatabaseProcedures
#OracleDatabaseFunctions
#OracleDatabasePackages