| Oracle 9i RMAN/Redo log files Problem [message #217333] |
Thu, 01 February 2007 14:27  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
