Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle archive log summary     - How to install Wine 1.7.20 under Ubuntu or Linux Mint (Linux)

- Lucene Getting Started Tutorial (Server)

- Hadoop - Task Scheduling System Comparison (Server)

- Comparison of sorting algorithms (Programming)

- Java how to achieve bubble sort the problem Arraylist (Programming)

- Linux development management utility command (Linux)

- Debian 7 and Debian 8 users how to install Oracle Java 8 (Linux)

- Binary Tree Traversal (Linux)

- What Java 8 fastest garbage collector (Programming)

- How to install Unbound and DNSCrypt in Archlinux (Server)

- CentOS yum install LAMP (Server)

- NIC configuration parameters under Linux (Linux)

- Using Linux stat command to view the files (Linux)

- Ubuntu 14.04 jdk Installation and Configuration (Linux)

- Getting the Linux shell expr use (Programming)

- Different between Linux file path and the windows (Linux)

- How to upgrade Docker 1.6 on Fedora / CentOS (Server)

- Linux Shell Scripting (Programming)

- Git uses a basic tutorial (Linux)

- MySQLbinlog combat on using data recovery (Database)

 
         
  Oracle archive log summary
     
  Add Date : 2018-11-21      
         
         
         
  1. Open the archive log

sqlplus / as sysdba
sql> shutdown immediate;
sql> startup mount; # Open the control file does not open the data file
sql> alter database archivelog; # to switch the database to archive mode
sql> alter database open; # the data file open
sql> archive log list; # to view at this time is in archive mode

View log mode

SQL> select log_mode from v $ database;

View archive is started

SQL> select archiver from v $ instance;

2. Disable archive log

sql> archive log list; # Check whether the archiving
sql> alter system set log_archive_start = false scope = spfile;
sql> shutdown immediate;
sql> startup mount; # Open the control file does not open the data file
sql> alter database noarchivelog; # to switch the database archiving mode non
sql> alter database open; # the data file open
sql> archive log list; # to view at this time will be in a non-archive mode

3. Check the path is not archiving and archiving

sql> archive log list; # View is not archiving

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 98

Next log sequence to archive 100

Current log sequence 100

According to the above USE_DB_RECOVERY_FILE_DEST, to find DB_RECOVERY_FILE_DEST

sys @ ora10g> show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE

--------------------- ----------- ------------------ --------------------

db_recovery_file_dest string / Oracle / app / oracle / flash_recovery_area

 

4. Modify the log file path

sql> archive log list; # View is not archiving
sql> alter system set log_archive_start = true scope = spfile; # Enable Active Archiving
sql> alter system set log_archive_dest = '' location = / oracle / ora9 / oradata / arch '' scope = spfile; # set the archive path
sql> alter system set log_archive_dest_1 = '' location = / oracle / ora9 / oradata / arch1 '' scope = spfile;
sql> alter system set log_archive_dest_2 = '' location = / oracle / ora9 / oradata / arch2 '' scope = spfile;
# If the archive to two locations, the method can be implemented on top
sql> alter system set log_archive_format = '' arch_% d_% t_% r_% s.log '' # config file diary style
 
Log switch
sql> alter system switch logfile;
The archive log switch will be written to two goals,
That is on top of / oracle / ora9 / oradata / arch1 and / oracle / ora9 / oradata / arch1,

 

5. Check now the size of the archive log

select sum (a.BLOCK_SIZE * a.BLOCKS) / 1024/1024 from v $ archived_log a where a.DELETED = 'NO';

6. Check the maximum size of the archive log

show parameter db_recovery_file_dest_size;

7. Set the maximum archive log, archive log full treatment can not start

startup nomount;
alter system set db_recovery_file_dest_size = 4G;
alter database mount;
alter database on;

8. View the archive log usage

select PERCENT_SPACE_USED from V $ FLASH_RECOVERY_AREA_USAGE where file_type LIKE 'ARCHIVED LOG';

9. Get usage flashback area

select sum (PERCENT_SPACE_USED) from V $ RECOVERY_AREA_USAGE;
     
         
         
         
  More:      
 
- Tor Browser: under Linux for anonymous Web browsing ultimate browser (Linux)
- Ubuntu cut screen method (Linux)
- Linux System Getting Started Learning: Statistical process a number of threads in Linux (Linux)
- C ++ inheritance and derived (induction principle) (Programming)
- Adjustment expand VMDK format VirtualBox disk space (Linux)
- Build the first ASP.NET 5 Web project in Mac OS X Yosemite 10.10.3 (Server)
- init level settings for Linux / etc / inittab file into six (restart) or does not support the level of solution (Linux)
- Use Tmux and Vim to make IDE (Linux)
- Linux text processing tool of sed (Linux)
- Linux start the process (Linux)
- Teach you how to synchronize Microsoft OneDrive in Linux (Linux)
- Using Python to find a particular file extension directory (Programming)
- Change the kernel boot sequence after CentOS 7 kernel upgrade (Linux)
- Oracle TAF Analysis (Database)
- Use smem visual display Linux memory usage (Linux)
- Android components save state series - Activity (Programming)
- 64-bit Windows Server 2012 R2 install Oracle 10g Second Edition (Database)
- Dell R710 server disk recovery database one case (record) (Server)
- The direct insertion sort algorithm (Programming)
- Loop arrays in C language is not easy to find a bug (Programming)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.