Steps to change the database to Archivelog Mode:
1. Login to the database server. Connect to sqlplus as sysdba
$sqlplus / as sysdba
2. Shutdown the database
SQL> shutdown immediate
3. Take a full database Backup (Cold Backup in this case)
4. Startup the database in mount stage
SQL> startup mount
5. Enable Archivelog mode
SQL> alter database archivelog;
6. Open the Database.
SQL> Alter database open;
7. Verify the changes.
SQL> archive log list;
1. Login to the database server. Connect to sqlplus as sysdba
$sqlplus / as sysdba
2. Shutdown the database
SQL> shutdown immediate
3. Take a full database Backup (Cold Backup in this case)
4. Startup the database in mount stage
SQL> startup mount
5. Enable Archivelog mode
SQL> alter database archivelog;
6. Open the Database.
SQL> Alter database open;
7. Verify the changes.
SQL> archive log list;
Nice post. I learn something totally new and challenging on websites
I’m often to blogging and i really appreciate your content. The article has actually peaks my interest. I’m going to bookmark your web site and maintain checking for brand spanking new information.
Pretty! This has been a really wonderful post. Many thanks for providing these details.
I really like reading through a post that can make men and women think. Also, thank you for allowing me to comment!
I truly appreciate your technique of writing a blog. I added it to my bookmark site list and will
This helped me a lot, thank you.
This was very enlightening.
Really well-researched and written.
Clear, concise, and effective.