get content from bad gzip files (using Perl build-in Package)

当你用gunzip/gzip -d不能解开.gz打包的文件时， 可以用Perl的Build-in Package:Compress::Zlib来用程序读出文件内容。这对内容是文本的打包文件特别有用。

用法：
use Compress::Zlib;

$gz = gzopen("$fn", "rb") ;
while ($gz->gzread($buffer) > 0)
{ print O $buffer ; ##or using other means deal with $buffer
};
$gz->gzclose() ;

Multi control files on 10G Oracle

Method 1
1.conn username/pwd@server
2.create pfile='dir\inifile.ini' from spfile='%oracle_home%\db_1\dbs\spfilesid.ora'
3.shutdown db system
4.edit inifile.ini file for add lines of new control file location.
5.copy control files to multi locaition.
6. startup db nomount.
7. copy spfile='%oracle_home%\dbs\spfile_sid.ora.new' from pfile='dir\inifile.ini'
8.alter database mount;
9. alter database open;

get txt version of control file:
alter database backup controlfile to trace
------------------------------------------
Method 2

1.SQL> ALTER SYSTEM SET CONTROL_FILES ='C:\ORA\DATA\CONTROL\CONTROL1.CTL','D:\ORA\DATA\CONTROL\CONTROL1.CTL'SCOPE = SPFILE;
2.SHUTDOWN NORMAL
3. COPY CONTROL FILE
4. STARTUP