Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Oracle DBA Tutorial 6 - How to enable archivelog mode. That video is uploaded by Chirags Tutorial at 2022-06-05T08:55:18-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [upFrVq-wH08]
| Name | Oracle DBA Tutorial 6 - How to enable archivelog mode |
| Video Uploader | Video From Chirags Tutorial |
| Upload Date | This Video Uploaded At 05-06-2022 15:55:18 |
| Video Discription | inchirags@gmail.com Chirag's Oracle DBA Tutorial https://www.chirags.in ***************************************************************************************** * How to enable archivelog mode * ***************************************************************************************** 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. The archiving of filled groups has these advantages: A database backup, together with online and archived redo log files, guarantees that you can recover all committed transactions in the event of an operating system or disk failure. If you keep an archived log, you can use a backup taken while the database is open and in normal system use. You can keep a standby database current with its original database by continuously applying the original archived redo logs to the standby. ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. Archive logs are archived redo(online) log files. In redo log files are all changes that happened to your data. If your database is in archivelog mode, than redo logs can't be overwritten, they are archived in some other location when they are full. Redo and archive logs are used in various database recovery scenarios. 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: https://www.youtube.com/channel/UCLdaO4-i_gxQMi87JwjKOwA 💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment Tutorial Link : https://www.chirags.in/tutorials/oracle_database Thanks & Regards, Chitt Ranjan Mahto "Chirag" _________________________________________________________________________________________ Note: All scripts used in this demo will be avilable in our website. Link will be available in description. #oracle #oracletutorial #chiragstutorial #chiragsdatabasetutorial #oracledatabase #chiragsdbatutorial #databasetutorial #bestDatabaseTutorial #oracletutorialchirags upFrVq-wH08 |
| Category | Education |
| Tags | Oracle 11g R2 | Chirag's Tutorials | Chirag's DBA Tutorials | Chirag's Oracle DBA Tutorials | Oracle 11g R2 Tutorial | Oracle 11g R2 Installation | Oracle 11g R2 Installation Process | Oracle 11g R2 Installation Process Step by Step | Oracle 11g R2 in Windows | Oracle 11g R2 Tutorial in Windows | Oracle 11g R2 Installation in Windows | Oracle 11g R2 Installation Process in Windows | Oracle 11g R2 Installation Process Step by Step in Windows |
