一次SPA数据库的OFFLINE备份的恢复测试

Oracle数据库客户端的安装和配置
数据库人员面试：SQL Server常用测试
用JSP从数据库中读取图片并显示在网页
PHP连接数据库的方法(3)
Oracle数据库网络的安装和配置(1)
利用外部命令Oralce数据库导入导出
PHP中使用类对数据库进行操作
VB连接SQL数据库的模块
图解MySQL数据库的安装和操作 （1）
DB2 9数据库免费版下载地址
su - oracle
export ORACLE_SID=PRD

vi init.ora:
*.compatible='9.2.0.0.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/PRD/origlogA/cntrlPRD.dbf'
*.core_dump_dest='/orasys/oracle/admin/PRD/cdump'
*.db_block_size=8192
*.db_cache_size=17179869
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PRD'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.java_pool_size=0
*.job_queue_processes=2
*.large_pool_size=524288000
*.LOG_ARCHIVE_FORMAT='log_%t_%s.arc'
*.nls_date_format='YYYY-MM-DD'
*.open_cursors=10000
*.optimizer_mode='FIRST_ROWS_10'
*.pga_aggregate_target=838860800
*.processes=900
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='exclusive'
*.shared_pool_size=2147483648
*.sort_area_size=52428800
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.user_dump_dest='/orasys/oracle/admin/PRD/udump'
*.LOG_ARCHIVE_DEST_1='LOCATION=/oracle/PRD/oraarch'

orapwd file='/orasys/oracle/product/9.2.5/dbs/orapwPRD' password=sys entries=5

SQL>startup mount pfile='init.ora'
SQL>alter database open;

Database altered.