Home » RDBMS Server » Backup & Recovery » Oracle 9i RMAN/Redo log files Problem
Oracle 9i RMAN/Redo log files Problem [message #217333] Thu, 01 February 2007 14:27 Go to next message
Ista
Messages: 14
Registered: January 2007
Junior Member
Greetings,

I am having a problem when trying to delete the archived redo log files on our 9.2.0.3 database.
When the following script is run, the errors listed below are displayed.
The archived redo logs number is very large and the logs are utilizing almost 30GB of disk space.
Is there another way of clearing them if this one does not work (e.g. manually deleting them) and what is the impact?
I presume that the db should be shutdown before deleting them.Is this correct.
Please advise.

Thanks and best regards,


{

echo "run {
ALLOCATE CHANNEL C1 TYPE DISK;
DELETE ARCHIVELOG ALL;
}
EXIT;" > $LOG_PATH_DB/rman_commands2
if [ "$?" -gt "0" ]
then
Log_Event "ERROR: Cannot create $LOG_PATH_DB/rman_commands2 file. The script will exit."
exit 1
fi

Log_Event "Running the Oracle RMAN tool to delete the Oracle Archive Log files."
$ORACLE_HOME/bin/rman TARGET / log=$LOG_PATH_DB/rman2.log cmdfile=$LOG_PATH_DB/rman_commands2

cat $LOG_PATH_DB/rman2.log >> $LOG_FILE

return 0

}


\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
Re: Oracle 9i RMAN/Redo log files Problem [message #217359 is a reply to message #217333] Thu, 01 February 2007 17:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should ensure that a password file has been created for the database and that REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE in the parameter file.
Re: Oracle 9i RMAN/Redo log files Problem [message #217598 is a reply to message #217333] Fri, 02 February 2007 23:29 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

DELETE ARCHIVELOG ALL;
are you sure you want to delete all archive log files.?


Previous Topic: how to cross check /test weather the backup is fine
Next Topic: need oracle 10g adming guide (pdf)
Goto Forum:
  


Current Time: Mon Dec 05 08:44:37 CST 2016

Total time taken to generate the page: 0.13220 seconds