摘要：
rman_bak.shrman target / nocatalog log=/d01/rmanbak/bak_`date +%m%d%H%M`.log<< EOF run { configure device type disk parallelism 1; configure channel C1 device type disk format='/d01/rmanbak/fu1%u.%p' maxpiecesize 4G; configure controlfile autobackup on; configure controlfile autobackup 阅读全文
摘要：
第一步：查看ORACLE表空间的使用情况：SELECT DBF.TABLESPACE_NAME, DBF.TOTALSPACE "总量(M)", DBF.TOTALBLOCKS AS 总块数, DFS.FREESPACE "剩余总量(M)", DFS.FREEBLOCKS "剩余块数", (DFS.FREESPACE / DBF.TOTALSPACE) * 100 "空闲比例" FROM (SELECT T.TABLESPACE_NAME, SUM(T.BYTES) / 1024 / 1024 TOTALSPACE 阅读全文