使用迅雷新建任务下载地址填写
ftp://updates.oracle.com/<patch_num>/p<patch_num>_<version>_<os>.zip 就可以下载到你想要的补丁了。 9.2.0.4 = 3095277 9.2.0.5 = 3501955 9.2.0.6 = 3948480 9.2.0.7 = 4163445 9.2.0.8 = 4547809(9i最终) 10.1.0.3 = 3761843 10.1.0.4 = 4163362 10.1.0.5 = 4505133 10.2.0.2 = 4547817 10.2.0.3 = 5337014 10.2.0.4 = 6810189 10.2.0.5 = 8202632 下载补丁时,可进入cmd,使用ftp命令直接登录网站下载。相同版本,针对不同的操作系统,会有不同的补丁。每个补丁大小约在500MB~1.3GB之间。下面以oracle 10.2.0.2 补丁为例: ftp updates.oracle.com user metalib_user 输入密码 cd 4547817 dir p4547817_10202_AIX64-5L.zip p4547817_10202_HP64.zip p4547817_10202_HPUX-IA64.zip p4547817_10202_LINUX.zip p4547817_10202_Linux-IA64.zip p4547817_10202_Linux-x86-64.zip p4547817_10202_MVS.zip p4547817_10202_SOLARIS.zip p4547817_10202_SOLARIS64.zip p4547817_10202_WINNT.zip p4547817_10202_WINNT64.zip 使用mget命令下载即可。 结合迅雷,可以取得事半功倍的效果,链接如下: oracle 9206 patchset: ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip ftp://updates.oracle.com/3948480/p3948480_9206_HPUX-IA64.zip ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip ftp://updates.oracle.com/3948480/p3948480_9206_Linux-x86-64.zip ftp://updates.oracle.com/3948480/p3948480_9206_MVS.zip ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS.zip ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS64.zip ftp://updates.oracle.com/3948480/p3948480_9206_TRU64.zip ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip ftp://updates.oracle.com/3948480/p3948480_9206_WINNT64.zip oracle 9207patchset: ftp://updates.oracle.com/4163445/p4163445_92070_AIX64-5L.zip ftp://updates.oracle.com/4163445/p4163445_92070_HP64.zip ftp://updates.oracle.com/4163445/p4163445_92070_HPUX-IA64.zip ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip ftp://updates.oracle.com/4163445/p4163445_92070_Linux-IA64.zip ftp://updates.oracle.com/4163445/p4163445_92070_Linux-x86-64.zip ftp://updates.oracle.com/4163445/p4163445_92070_MVS.zip ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS.zip ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS64.zip ftp://updates.oracle.com/4163445/p4163445_92070_WINNT.zip ftp://updates.oracle.com/4163445/p4163445_92070_WINNT64.zip (无) oracle 9208 patch: ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip 下载OTN上的这些软件,你需要一个OTN免费帐号,不过如果通过迅雷进行下载,就不用登陆OTN了: Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit) http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64) http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_database.zip http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_client.zip http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86 http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zip http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux32.zip Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64 http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux_x86_64.cpio.gz http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux_x86_64.cpio.gz http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_64.cpio.gz http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux_x86_64.cpio.gz Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_database.cpio.gz http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_client.cpio.gz http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_cluster.cpio.gz http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_gateways.cpio.gz Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86) http://download.oracle.com/otn/solaris/oracle10g/10202/10202_database_solx86.zip http://download.oracle.com/otn/solaris/oracle10g/10202/10202_client_solx86.zip http://download.oracle.com/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64) http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip oracle 10.2.0.4 patch: ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip Oracle Database 10g、11g Release http://www.oracle.com/technology/software/products/database/index.html Oracle Database 11g Release 1(11.1.0.6.0) 下载地址: http://www.oracle.com/technology/software/products/database/index.html 文档:http://www.oracle.com/technology/global/cn/documentation/index.html Oracle9i下载地址 Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit) http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk1.zip http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk2.zip Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk1.cpio.gz http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk2.cpio.gz http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk3.cpio.gz Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64 http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk1.cpio.gz http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk2.cpio.gz http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk3.cpio.gz Oracle9i Database Release 2 Enterprise/Standard Edition for AIX - Based 4.3.3 Systems (64-bit) http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk1.cpio.gz http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk2.cpio.gz http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk3.cpio.gz http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk4.cpio.gz Oracle9i Database Release 2 Enterprise/Standard Edition for AIX- Based 5L Systems http://download.oracle.com/otn/aix/oracle9i/9201/A99331-01.zip http://download.oracle.com/otn/aix/oracle9i/9201/A99332-01.zip http://download.oracle.com/otn/aix/oracle9i/9201/A99333-01.zip http://download.oracle.com/otn/aix/oracle9i/9201/A99334-01.zip Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit) http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk1.cpio.gz http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk2.cpio.gz http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk3.cpio.gz Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (64-bit) http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk1.cpio.gz http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk2.cpio.gz http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk3.cpio.gz ########################### oracle 11g 11.2.0.2 patch ########################### AIX 64bit (6.8G) ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_1of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_2of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_3of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_4of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_5of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_6of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_7of7.zip HP-UX IA64 (6.6G) ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_1of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_2of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_3of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_4of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_5of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_6of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_7of7.zip Linux 32bit (4.8G) ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_1of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_2of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_3of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_4of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_5of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_6of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_7of7.zip Linux 64bit (4.7G) ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_1of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_2of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_3of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_4of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_5of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_6of7.zip ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_7of7.zip ########################### oracle 11g 11.1.0.7 patch ########################### ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86.zip ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_1of2.zip ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_2of2.zip ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-64_1of2.zip ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-64_2of2.zip ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-IA64_1of2.zip ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-IA64_2of2.zip ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86-64.zip ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86.zip ftp://updates.oracle.com/6890831/p6890831_111070_MSWIN-x86-64.zip ########################### oracle 10.2.0.5 patch ########################### ftp://updates.oracle.com/8202632/p8202632_10205_AIX64-5L_1of2.zip ftp://updates.oracle.com/8202632/p8202632_10205_AIX64-5L_2of2.zip ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-64_1of2.zip ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-64_2of2.zip ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-IA64_1of2.zip ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-IA64_2of2.zip ftp://updates.oracle.com/8202632/p8202632_10205_Linux-x86-64.zip ftp://updates.oracle.com/8202632/p8202632_10205_Linux-x86.zip ftp://updates.oracle.com/8202632/p8202632_10205_MSWIN-x86-64.zip ftp://updates.oracle.com/8202632/p8202632_10205_WINNT.zip ########################### ooracle 10.2.0.4 patch ########################### ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip ftp://updates.oracle.com/6810189/p6810189_10204_LINUX.zip ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip ftp://updates.oracle.com/6810189/p6810189_10204_Win64.zip ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip ########################### ooracle 10.2.0.3 patch ########################### ftp://updates.oracle.com/5337014/p5337014_10203_WINNT.zip ftp://updates.oracle.com/5337014/p5337014_10203_WINNT64.zip ftp://updates.oracle.com/5337014/p5337014_10203_AIX5L.zip ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86-64.zip ftp://updates.oracle.com/5337014/p5337014_10203_HPUX-IA64.zip ftp://updates.oracle.com/5337014/p5337014_10203_LINUX.zip ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86.zip ########################### ooracle 10.2.0.2 patch ############################ ftp://updates.oracle.com/4547817/p4547817_10202_AIX64-5L.zip ftp://updates.oracle.com/4547817/p4547817_10202_HP64.zip ftp://updates.oracle.com/4547817/p4547817_10202_HPUX-IA64.zip ftp://updates.oracle.com/4547817/p4547817_10202_LINUX.zip ftp://updates.oracle.com/4547817/p4547817_10202_Linux-IA64.zip ftp://updates.oracle.com/4547817/p4547817_10202_Linux-x86-64.zip ftp://updates.oracle.com/4547817/p4547817_10202_MVS.zip ftp://updates.oracle.com/4547817/p4547817_10202_SOLARIS.zip ftp://updates.oracle.com/4547817/p4547817_10202_SOLARIS64.zip ftp://updates.oracle.com/4547817/p4547817_10202_WINNT.zip ftp://updates.oracle.com/4547817/p4547817_10202_WINNT64.zip ########################### oracle 9208 patch ########################### ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip ############################ oracle 9207 patch ########################### ftp://updates.oracle.com/4163445/p4163445_92070_AIX64-5L.zip ftp://updates.oracle.com/4163445/p4163445_92070_HP64.zip ftp://updates.oracle.com/4163445/p4163445_92070_HPUX-IA64.zip ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip ftp://updates.oracle.com/4163445/p4163445_92070_Linux-IA64.zip ftp://updates.oracle.com/4163445/p4163445_92070_Linux-x86-64.zip ftp://updates.oracle.com/4163445/p4163445_92070_MVS.zip ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS.zip ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS64.zip ftp://updates.oracle.com/4163445/p4163445_92070_WINNT.zip ########################### oracle 9206 patch ########################### ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip ftp://updates.oracle.com/3948480/p3948480_9206_HPUX-IA64.zip ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip ftp://updates.oracle.com/3948480/p3948480_9206_Linux-x86-64.zip ftp://updates.oracle.com/3948480/p3948480_9206_MVS.zip ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS.zip ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS64.zip ftp://updates.oracle.com/3948480/p3948480_9206_TRU64.zip ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip ftp://updates.oracle.com/3948480/p3948480_9206_WINNT64.zip
******************
更多参考
******************
有关基于用户管理的备份和备份恢复的概念请参考:
Oracle 基于用户管理恢复的处理(详细描述了介质恢复及其处理)
有关RMAN的恢复与管理请参考:
有关Oracle体系结构请参考:
Oracle 实例和Oracle数据库(Oracle体系结构)
Oracle 联机重做日志文件(ONLINE LOG FILE)
转自:http://blog.csdn.net/zxx2403/article/details/12691639