...
| No Format |
|---|
sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 20 18:00:32 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> |
b) . Unlock and alter the OE schema. Run the following SQL
...
5. Ensure the archive log files are managed and not filling up and stopping the database. Install a script that manages the archive logs
a. Logon as root and cd to /usr/local/bin
...
d. As user oracle, add it to the oracle crontab. Run it every 15 minutes and delete all archives older than 4.8 hours (0.2 days)
| No Format |
|---|
su - oracle
crontab -e
*/15 * * * * /usr/local/bin/del_arch.sh orcl 0.2 > /tmp/del_arch.txt 2>&1 |
...