创建物理备用

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

 

创建物理备用数据库

在创建物理备用数据库之前先查看主数据库的一些信息和对主数据库做好配置.

将主数据库置为FORCELOGGING模式.在主数据库创建之后做如下操作:

SQL>ALTERDATABASEFORCELOGGING;

确认主数据库是归档的并定义好本地归档.如下:

SQL>ALTERSYSTEMSETLOG_ARCHIVE_DEST_1='LOCATION=e:/oracle/oradata/orcl/archive MANDATORY'SCOPE=BOTH;

 在主节点a确认主数据库的数据文件的位置和文件名.

  SQL>selectnamefromv$datafile;

NAME

-----------------------------------------------------------------------------------------------------------

E:/ORACLE/ORA92/ORCLYSTEM01.DBF

E:/ORACLE/ORA92/ORCL/UNDOTBS01.DBF

E:/ORACLE/ORA92/ORCL/CWMLITE01.DBF

E:/ORACLE/ORA92/ORCL/DRSYS01.DBF

E:/ORACLE/ORA92/ORCL/EXAMPLE01.DBF

E:/ORACLE/ORA92/ORCL/INDX01.DBF

E:/ORACLE/ORA92/ORCL/ODM01.DBF

E:/ORACLE/ORA92/ORCL/TOOLS01.DBF

E:/ORACLE/ORA92/ORCL/USERS01.DBF

E:/ORACLE/ORA92/ORCL/XDB01.DBF

 做上面查询得出来的数据文件的物理备份.将其备份到一个临时的位置中.

 SQL>SHUTDOWNIMMEDIATE;

 SQL>EXIT

 将E:/ORACLE/ORA92/ORCL整个目录COPY到a节点的F盘的oracle目录下.

 在拷贝完之后再启动数据库

 SQL>STARTUP;

 SQL>ARCHIVELOGLIST;

 在主节点a为备用数据库创建备用控制文件

SQL>ALTERDATABASECREATESTANDBYCONTROLFILEAS‘f:/oracletdbycon.ctl’;

创建初始化参数文件

SQL>CREATEPFILE=’f:/oracle/initstdbyorcl.ora’FROMSPFILE;

将上面几步所得到的文件从主节点a拷贝到备用节点b上.

修改并添加一些参数后如下:

 

*.aq_tm_processes=1

*.background_dump_dest='e:/oracle/admin/orcl/bdump'

*.compatible='9.2.0.0.0'

*.control_files='e:/oracle/ora92TANDBYTDBYCON.CTL','e:/oracle/ora92TANDBYTDBYCON02.CTL','e:/oracle/ora92TANDBYTDBYCON03.CTL'

*.core_dump_dest='e:/oracle/adminTANDBY/cdump'

*.db_block_size=16384

*.db_cache_size=137363456

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='orcl'

*.dispatchers='(PROTOCOL=TCP)(SERVICE=orclXDB)'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.instance_name='orcl2'

*.java_pool_size=33554432

*.job_queue_processes=10

*.large_pool_size=27262976

*.log_archive_dest_1='LOCATION=e:/oracle/oradataTANDBY/archiveMANDATORY'

*.log_archive_format='log%d_%t_%s.arc'

*.log_archive_start=true

*.open_cursors=300

*.pga_aggregate_target=80000000

*.processes=150

*.query_rewrite_enabled='FALSE'

*.remote_login_passwordfile='EXCLUSIVE'

*.shared_pool_size=45088768

*.sort_area_size=524288

*.sql_trace=FALSE

*.star_transformation_enabled='FALSE'

*.timed_statistics=TRUE

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='e:/oracle/adminTANDBY/udump'

*.workarea_size_policy='AUTO'

*.standby_file_management='AUTO'

*.fal_server='ORCL'

*.fal_client='ORCL2'

*.standby_archive_dest='e:/oracle/oradatatandbytdarch'

*.utl_file_dir='e:/oracle'

*.remote_archive_enable='TRUE'

 

 

在备用数据库一端创建一个新的实例.如下操作:

 

c:/>oradim–new–sidorcl2–startmodem

 

将拷贝过来的文件放到e:/oracle/ora92底下,并修改文件夹名为orcl2

修改e:/oracle/ora92/orcl2下的控制文件,将其中的control01.ora,control02.ora,control03.ora删掉,将f:/oracletdbycon01.ora文件拷贝到e:/oracle/ora92/orcl2目录下.并复制和修改其名为stdbycon02.ora,stdbycon03.ora1<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>