Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Once the database is changed to ARCHIVELOG mode, what must be done for complete recovery?

April 26, 2017ARCHIVELOG changed COMPLETE database mode recovery

0

Posted

Once the database is changed to ARCHIVELOG mode, what must be done for complete recovery?

1 Answer

0

Posted

The database must be shut down and a full backup performed. To place the database in ARCHIVELOG mode: 1. Shut down the database. 2. Start the database in MOUNT state. 3. Issue the ALTER DATABASE ARCHIVELOG command. 4. Open the database. 5. Shut down the database. 6. Take a full closed backup. A new full backup is taken because your previous backup is no longer usable because the database was in NOARCHIVELOG mode. This new backup will be used for recovery and the archived logs will be applied to it.