FROM gv$parameter
WHERE name = 'log_archive_max_processes';
ALTER SYSTEM SET log_archive_max_processes=3;
SELECT value
FROM gv$parameter
WHERE name = 'log_archive_max_processes';[/font][/td] [/tr] [tr] [td=2,1,100%] [/td] [/tr] [tr] [td=2,1,100%][font=Arial]Startup The Database In Archivelog Mode[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]Steps Required To Take A Database Not In Archive Log Mode And Alter It To Archive Log Mode[/font][/td] [td=1,1,75%][font=Courier]SHUTDOWN;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;[/font] [/td] [/tr] [tr] [td=2,1,100%] [/td] [/tr] [tr] [td=2,1,100%][font=Arial]Startup The Database In NoArchivelog Mode[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]Steps Required To Take A Database In Archive Log Mode And Alter It To No Archive Log Mode[/font] [/td] [td=1,1,75%][font=Courier]SHUTDOWN;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN;[/font] [/td] [/tr] [tr] [td=2,1,100%] [/td] [/tr] [tr] [td=2,1,100%][font=Arial]Restart After Archiving Logging Failure[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]Archive Logging Restart[/font][/td] [td=1,1,75%][font=Courier]SHUTDOWN;
STARTUP;
ARCHIVE LOG START;
ARCHIVE LOG ALL;[/font][/td] [/tr] [tr] [td=2,1,100%] [/td] [/tr] [tr] [td=2,1,100%][font=Arial]Archive Log Related Commands[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]Start Archive Logging[/font][/td] [td=1,1,75%][font=Courier]alter system archive log start;[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]Stop Archive Logging[/font][/td] [td=1,1,75%][font=Courier]alter system archive log stop;[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]Force archiving of all log files[/font][/td] [td=1,1,75%][font=Courier]alter system archive log all;[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]Force archiving of the current log file[/font][/td] [td=1,1,75%][font=Courier]alter system archive log current;[/font][/td] [/tr] [tr] [td=2,1,100%] [/td] [/tr] [tr] [td=2,1,100%][font=Arial]Shell scrīpts[/font][/td] [/tr] [tr] [td=1,1,25%][font=Arial]
Move Archive Logs[/font][/td] [td=1,1,75%][font=Courier]export ARCH_DIR="/tmp/rim"
NEW_DIR ="/tmp/rim/new_dir"
export FILE_EXT="arc"
export MOVELIST="/tmp/move.list"
export CALF="/tmp/calc.tmp"
export TMPF="/tmp/workfile.tmp"
CMD="ls -ltr $ARCH_DIR/*.$FILE_EXT | awk {'print $9'}
| sort -r > $TMPF"
export FILE_COUNT="
echo "Number of files foundis $FILE_COUNT"
cat $TMPF
echo $FILE_COUNT - 1" > $CALF
echo "quit" >> $CALF
MOVE ="/usr/bin/bc/ $CALF"
echo "Number of files to move is $MOVE"
/usr/bin/tail -$MOVE $TMPF > $MOVELIST
echo "File to be moved"
cat $MOVELIST
while read FILE
do
cho "Moving file $FILE to $NEW_DIR"
done < $MOVELIST[/font][/td][/tr][/table][/td][/tr][/table]