随锐旗下互动传媒：

Oracle rman数据迁移测试

http://www.weaseek.com  2008-05-12 16:44:46  来源：IT专家网

1.以oracle用户身份，备份源数据库，脚本如下：

以下是引用片段：

run{

allocatechannelc1typedisk

format'/oracle/rman_bk/lev_0_%d_%T%s%p%u.bak';

BACKUPdatabase;

sql'altersystemswitchlogfile';

}

备份完毕后，修改备份集文件的权限为777.

chmod 777 lev_0_PROD_200802236106j9e8fo.bak

2.创建新用户ora9208，并以该用户身份安装oracle软件。安装完毕后，参照oracle用户的初始化参数文件，为ora9208用户创建初始化参数文件。如下：

以下是引用片段：

*.background_dump_dest='/ora9208/admin/prod/bdump'

*.compatible='9.2.0.4'

*.control_files='/ora9208/oradata/prod/control01.ctl','/ora9208/oradata/prod/control02.ctl'

*.core_dump_dest='/ora9208/admin/prod/cdump'

*.db_16k_cache_size=30M

*.db_block_size=8192

*.db_cache_size=30M#DEMO

*.db_file_multiblock_read_count=16

*.db_name='prod'

*.job_queue_processes=1

*.log_archive_dest='/ora9208/arch'

*.log_archive_max_processes=2

*.log_archive_start=TRUE

*.max_dump_file_size='100000'

*.nls_date_format='yyyy-mm-ddhh24:mi:ss'

*.optimizer_mode='CHOOSE'

*.oracle_trace_enable=TRUE

*.parallel_automatic_tuning=true

*.parallel_threads_per_cpu=4#SMALL

*.partition_view_enabled=true

*.pga_aggregate_target=30M#DEMO

*.query_rewrite_enabled='true'

*.query_rewrite_integrity='trusted'

*.remote_login_passwordfile='exclusive'

*.shared_pool_size=20M#DEMO

*.sql_trace=FALSE

*.star_transformation_enabled='true'

*.undo_management='auto'

*.undo_retention=180

*.undo_tablespace='UNDOTBS'

*.user_dump_dest='/ora9208/admin/prod/udump'

*.utl_file_dir='/oracle/admin/log'

#*.db_file_name_convert='/oracle/oradata/prod','/ora9208/oradata/prod'

*.log_file_name_convert='/oracle/oradata/prod','/ora9208/oradata/prod'

创建完毕后，将oracle用户下的密码文件copy到ora9208用户的相应目录下。

[1] [2] [3] [下一页]
[责任编辑：梧桐]热门关键词： Oracle rman 数据迁移

相关文章