In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
1. Change from non-archiving mode to archiving mode:
1) Connect to the database as DBA to see if it is in archive mode
SQL > conn / as sysdba
SQL > archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 31
Current log sequence 33
2) close the database immediately
SQL > shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
3) start the instance and load the database into the mount state
SQL > startup mount
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 318770144 bytes
Database Buffers 889192448 bytes
Redo Buffers 14753792 bytes
Database mounted.
4) change the database to archive mode
SQL > alter database archivelog
Database altered.
5) Open the database
SQL > alter database open
SQL > SELECT NAME,created,log_mode FROM v$database
NAME CREATED LOG_MODE
ORCL 04-JUN-12 ARCHIVELOG Database altered. 6) before enabling automatic archiving 10G, you need to operate SQL > alter system archive log start; 8) View the path and directory of the archive log SQL > show parameter db_recovery_file_dest NAME TYPE VALUE-db_recovery_file_dest string / data/app/oracle/flash_recovery_area db_recovery_file_dest _ size big integer 2G 9) modify method location and size of archive log: SQL > alter system set db_recovery_file_dest_size=20g SQL > alter system set db_recovery_file_dest='/app/arc'
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.