Shulou(Shulou.com)05/31 Report--

Editor to share with you how to open Oracle, close archiving, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1) in stand-alone mode

Log_archive_start=true enables automatic archiving, otherwise it can only be archived manually. If archiving is closed, set this parameter to false.

Note: if it is an OPS/RAC environment, you need to comment out parallel_server = true first, then perform the following steps, and finally restart with this parameter.

a. Shut down the database shutdown immediate

B. Startup mount

C. Alter database archivelog

D. Alter database opne

The archived information can be viewed with the following statement

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination E:oracleora92databasearchive

Oldest online log sequence 131

Next log sequence to archive 133

Current log sequence 133

2) in RAC mode

1. Turn off all instance

CLUSTER_DATABASE=FALSE.

Log_archive_dest= Archive path

Log_archive_start=true

Log_archive_format= archive file format

4. Start archive mode

SQL > Alter database archivelog

6. Close the database and modify the initialization parameters

SQL > shutdown immediate

CLUSTER_DATABASE=TRUE

8. Check the archive, whether the mode is started or not

SQL > archive log list

The above is all the contents of the article "how to turn Oracle on and off archiving". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.