分享
 
 
 

Create Standby Database

王朝other·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

This document describes how to create an Oracle standby database(PCB4) from a primary database(PCB5), what should be backed up on primary database in order to enable standby database recovery, how to sync the standby database with the primary database offline archives, and how to activate standby database at last. It also mentions the daily support notes on supporting Oracle standby database.

1. Actions to be performed on primary database

Hot-backup database datafiles on the primary system.

Create standby controlfile after hot-backup done

SVRMGR > ALTER DATABASE CREATE STANDBY CONTROLFILE AS <Backup control file > ;

Ensure all online archives are archived

SVRMGR > ALTER SYSTEM ARCHIVE LOG CURRENT ;

d) Backup the current init<SID>.ora of the database.

2.Create Oracle Service for Standby database

To create a new database as standby database with same <SID> as the primary database. We could create a small one with SYSTEM tablespace initially, using Oracle Database Assistant. It helps creation of the Oracle NT services.

Use the same Oracle version on creating the database

Ensure Oracle listener could serve the new Oracle service.

On NT service, change the oracleStart<SID>?service to manually mode, to avoid it automatically start-up on the NT reboot.

Shutdown the oracleStart<SID>?service once the above steps done, and ensure the 揙racleService<SID>?service is still running on.

3.Create DB Directories

Pls create the directories for holding the database datafiles, as same as the setting as on primary database.

You should follow the same drives mapping

Pls create the directories for logs, redo logs, pfile, bdump, udump etc, similar to the primary database also.

4.Transfer files to Standby Server

Transfer all of the hot-backup datafiles to the standby system.

The file list is

backup standby controlfile

Hot-backup datafiles

All offline archives available on archived directory

backup init<SID>.ora file

The destination of the transferred files should be specified as:

Backup standby control file:

Copied to all members of the control files, the exact directory path as specified in backup

init<SID>.ora file.

Hot-backup datafiles:

Copied to original datafiles location, exactly the same directory path as on primary system.

All offline archives:

Copied to the DB archive directory, exactly the same directory path as on primary system.

Backup init<SID>.ora file:

Copied to $ORACLE_HOME/dbs or the IFILE parameter refer to location.

5.Sync Standby Database

5.1 Turn Standby DB on recovery mode

a. Ensure oracleService<SID>?service started.

b. Mount the DB

SVRMGR > CONNECT INTERNAL/ <PASSWD>

SVRMGR > STARTUP NOMOUNT PFILE=<path>/init<SID>.ora

SVRMGR > ALTER DATABASE MOUNT STANDBY DATABASE;

SVRMGR > EXIT;

We could place the above commands into a STARTUP.SQL? and it will be called

by a batch command startup_standby.bat?. See Appendix for details.

You could place a shortcut on the desktop on NT standby server, to depict the job.

5.2 Apply archived logs

a. Ensure the standby DB in recovery mode.

b. Apply the logs

SVRMGR > CONNECT INTERNAL/ <PASSWD>

SVRMGR > SET AUTORECOVERY ON;

SVRMGR > RECOVER STANDBY DATABASE;

SVRMGR > EXIT;

We could place the above commands into a RECOVER.SQL?script, and it will be called

by a batch recover.bat?. See Appendix for details.

5.3 Continuous Apply archived logs in recovery mode

Ensure a regular job to copy the primary offline archives to the standby server.

Pls see aync_log.bat?file for a reference. See Appendix for details.

You could use WINCRON to schedule a job to copy drive archives from primary site to local

archive directory with 1 hr interval.

Perform the apply archived logs in recovery mode?job once new archives arrival

Pls see sync_log.bat?file for a reference. See Appendix for details.

You could use WINCRON to schedule the job to apply archives with 1 hr interval.

Perform clean job on obsolete offline archives on standby system

Pls see archive.cmd ?file for a reference. See Appendix for details.

You could use WINCRON to schedule the job to clean obsolete archives with 2 days retention.

5.4 Activate Standby Database

To activate the standby database, copy the latest offline archive logs from primary server over to the standby system.

Apply the archives to the standby database as mentioned on Section 3.2.

Activate the standby database

SVRMGR > ALTER DATABASE ACTIVATE STANDBY DATABASE ;

Shutdown the standby DB to reset file headers and clear all buffers.

SVRMGR > SHUTDOWN NORMAL;

Open the database. You could start it by NT 揙racleStart<SID>?service and then enable the service to start automatically now.

You do not need copy any online redo logs from the primary server to the standby system once it is activated.

Take a DB hot-backup after the database opens.

5.5 Special Notes

Any physical changes that occur on the primary must be accomplished on the standby as well.

New datafiles added on primary database, file entries are added to the standby controlfile only.

If the standby database can't find the physical datafile, standby recovery will stop with an

ORA-1157 error.

Use ALTER DATABASE CREATE DATAFILE <PATH> as <PATH>; ?to recreate the physical

datafile or physically copy the missing datafiles to the standby system.

You can add or drop log files on the primary without affecting the standby DB.

If you do recreation controlfile?on the primary server, you must also recreate the controlfile for the standby database. Shut down the standby database, and use a current backup standby control file from primary server.

Jimi

GIT

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有