Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Linux Oracle delete archived logs     - Oracle procedure or function Empty Table (Database)

- Zabbix installation and configuration process (Server)

- Use LKM change the default linux security level (Linux)

- Dual system Linux (Ubuntu) into the Windows NTFS partition's mount error (Linux)

- Nginx-1.9.7 TCP reverse proxy (Server)

- Raspberry Pi configuration wireless hotspot (Linux)

- Use source packages compiled and installed GCC5.1 in Mac OS X 10.10.3 (Linux)

- Secondary exponential smoothing prediction method implemented in Python (Programming)

- Python maketrans () method (Programming)

- The security configuration of Linux (Linux)

- How to find out a Unix system library files are 32-bit or 64-bit (Linux)

- Close and limit unused ports computer server security protection (Linux)

- SA weak password security system of the security risks posed (Linux)

- To install the Oracle 10.2.0.1.0 process notes on Oracle Linux 4u4 (Database)

- Wireshark basic introduction and learning TCP three-way handshake (Linux)

- GitLab issued Merge Request return error 500 when the two solutions log (Linux)

- Oracle inverted reverse function (Database)

- Shuffle Process Arrangement in MapReduce (Server)

- Testing Oracle 11g RMAN replicate database (Database)

- Java learning problems encountered (Programming)

 
         
  Linux Oracle delete archived logs
     
  Add Date : 2018-11-21      
         
         
         
  Oracle today reported experiencing this error: ORA-00257

See the next, the original Oracle archive log full, two solutions

A: Increase the log file size two: Remove unnecessary archive logs (we chose this option)

He said nothing on the Linux command:

Linux delete archived files
-> Su - oracle
-> Rman
-> RMAN> connect target sys / sys_passwd
-> RMAN> crosscheck archivelog all;
-> RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
or
-> RMAN> delete expired archivelog all;

Red statement is executed more slowly, patiently waiting for the next. Finally, click OK Yes to perform on it

Then use the next statement following verification, can not log in normally

---> Sqlplus / nolog
SQL> conn / as sysdba

or

-> Sqlplus user / pwd @ AXXX
     
         
         
         
  More:      
 
- JavaScript original values and complex values (Programming)
- CentOS How quickly customize kernel binary RPM package (Linux)
- Linux distributed message queue RocketMQ deployment and monitoring - Dual Master (Server)
- OpenSSL for secure transmission and use of skills of files between Windows and Linux (Linux)
- Install NetBeans IDE 8.0 on Ubuntu, Linux Mint, Elementary OS, and Debian (Linux)
- Use mysqldump backup performed MariaDB (Database)
- Production environment Linux bonding method standby mode slave card switch (Server)
- How dependent on Fedora, CentOS, RHEL check RPM packages (Linux)
- MySQL my.cnf sql_mode schema modifications (Database)
- Modify MySQL character encoding under Linux (Database)
- Java NIO in the world (Programming)
- Installation and configuration to compile MySQL 5.6.10 under CentOS 5.9 (Database)
- Inject script commands manually annotated summary (Linux)
- Use C program in JavaScript (Programming)
- RedHat Linux 5.5 installation process SVN Service Notes (Server)
- KVM add virtual disks (Linux)
- CentOS 5.5 install ntop (Linux)
- DVD production using CentOS installation source within the company Yum (Linux)
- Android application simulates the phone keypad (Programming)
- Linux / Raspberry Pi using the following command-line based web browser (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.