Home » RDBMS Server » Server Administration » $ORACLE_HOME/admin/ora/arch
$ORACLE_HOME/admin/ora/arch [message #369307] Thu, 10 August 2000 09:29 Go to next message
will at interactivefunds.
Messages: 1
Registered: August 2000
Junior Member
question: i've got a whole messload of files in
$ORACLE_HOME/admin/ora/arch (sequential archive logs,
maybe?).. that are chewing up roughly 4gigs now.
what's the process to reclaim this space?
Re: $ORACLE_HOME/admin/ora/arch [message #369309 is a reply to message #369307] Thu, 10 August 2000 23:07 Go to previous message
allen
Messages: 15
Registered: August 2000
Junior Member
Just delete the files (These are the files generated by oracle when your online redo log is full and your database is in ARCHIVELOG mode. Oracle switches to the next re-do log file and automatically migrate the redo log to the dir you specified.) You should have a procedure setup to delete these files when backup is done, but make sure you don't delete the most current one, you may have problem when you do recovery).
Previous Topic: Acces CGI Environment variables from PL /SQL
Next Topic: ABOUT SEQUENCE IN PL/SQL
Goto Forum:
  


Current Time: Wed Oct 21 11:53:45 CDT 2020