May I run "shrink DB/truncate free space from the end of file" at PROD?

[Former Member]

We have a SAP/MSS production system.

The disk is full.

We want to truncate the log file by:

"shrink DB/truncate free space from the end of file"

on the log file.

How risk is it? Can we do it during production is running?

Thanks! Points!

[Former Member]

Backup the log file (to save the data and keep a consistent backup) Then shrink the file. Its normal for the log not to shrink down to the size you want. Do not shrink past 1GB.

DO NOT TRUNCATE - you are losing/dropping data and recovery will only be possible to the last on-line, or on-line plus last log/s.

You can avoid a full log file by setting a 9002 trap - this will trigger a backup (like oraarch when you back up based on % full). Else you need to change the frequency of the backups for the logs to ensure the system never fills ups.

You can Also add a second log file on a separate F/S if this occurs regular - which it shouldn't if you have a correct backup strategy.

[former_member193399]

Jennifer,

It is not recommended to shrink the database file unless you are moving your files to different location or you are extremely running in low disk space. If you still want to shrink then you can use the script i posted in the thread

RT

Message was edited by:

R.T.