reduce the database log file
use DatabaseName
go
checkpoint
DBCC SHRINKFILE('DBlogName', 1)
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY DBCC SHRINKFILE('DBlogName', 1)[@more@]
go
checkpoint
DBCC SHRINKFILE('DBlogName', 1)
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY DBCC SHRINKFILE('DBlogName', 1)[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/208722/viewspace-1053592/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- OGG-01453 Database login information not specified in parameter fileDatabaseORM
- log file sync 和 log file parallel writeParallel
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- log file switch
- Could not find first log file name in binary log index fileIndex
- Specifying the Database Time Zone File (81)Database
- Oracle之 等待事件log file sync + log file parallel write (awr優化)Oracle事件Parallel優化
- Catalog archivelog from file system to Asmdg;HiveASM
- log file sync等待事件事件
- 【等待事件】log file sync事件
- redo log file 優化優化
- LOG FILE SWITCH等待事件事件
- log file sync" 等待事件事件
- Oracle Dump Redo Log FileOracle
- RMAN-05517: temporary file conflicts with file used by target database(zt)Database
- 建立 Logical Standby DatabaseDatabase
- manage logical standby databaseDatabase
- alter database open resetlogs;Database
- Unload data to a flat file from Oracle databaseOracleDatabase
- _use_adaptive_log_file_sync設定 降低log_file_sync等待APT
- log file sync(日誌檔案同步) 與 Log file parallel write 等待事件Parallel事件
- Log check error: Log file /var/log/messages is not readable!Error
- Oracle Database 11gR2引入的DBFS(Database File System)OracleDatabase
- redo的等待log file sync和log file parallel write和redo size設定Parallel
- db_recovery_file_dest_size, v$flashback_database_logfile,v$restore_point引發的血案.DatabaseREST
- "log file sync"等待事件-2事件
- "log file sync"等待事件-1事件
- 等待事件 log file sync 小解事件
- recover database using backup control fileDatabase
- Migrate database to Exadata with DBMS_FILE_TRANSFERDatabase
- Database Clone by rebuilding control file.DatabaseRebuild
- 1.1 Logical Structure of Database ClusterStructDatabase
- ALTER DATABASE RESETLOGS 的作用Database
- 監控Logical standby databaseDatabase
- 042-Your database is having two control files, three redo log file groups with two members in each gDatabase
- DBMS_FILE_TRANSFER Package in Oracle Database 10gPackageOracleDatabase
- Oracle Database on NFS : unable to lock file - already in use" ErrorOracleDatabaseNFSError
- _use_adaptive_log_file_syncAPT