在Oracle9i下创建逻辑备用库（LogicalStandbyDatabase）1目录一、DATAGUARD技术概述：..........................................................................................................4二、物理的STANDBYDATABASE和逻辑的STANDBYDATABASE.....................................................4三、创建LOGICALSTANDBYDATABASE..........................................................................................51、将主数据库置为FORCELOGGING模式：.............................................................................52、确认主数据库运行于归档模式并定义好本地归档：.........................................................53、确认LOG_PARALLELISM初始化参数值：.............................................................................64、确认支持的数据类型和表：.................................................................................................65、确保主数据库中的表行是可以唯一确认的(即表中有主键或唯一性索引).....................86、确认主数据库可以补足日志(SUPPLEMENTALLOGGING)............................................................97、在主数据库创建一个交替的表空间：...............................................................................108、确认主数据库的数据文件和日志文件...............................................................................119、对主数据库做一次冷备份...................................................................................................1110、为备用数据库创建准备初始化参数文件：.....................................................................1211、将文件从主库拷贝到从库所在机器.................................................................................1212、在备用数据库服务器修改初始化参数.............................................................................1213、在备用数据库一端创建一个新的实例：.........................................................................1214、配置监听............................................................................................................................1315、在从库上打开DEADCONNECTIONDETECTION..........................................................................1316、配置服务命名....................................................................................................................1317、用初始化参数文件启动数据库到MOUNT状态下.............................................................1318、RENAME数据文件..................................................................................................................13219、RENAME日志文件..................................................................................................................1420、在备用数据库打开DATAGUARD........................................................................................1421、重设LOGICALSTANDBYDATABASE的数据库名.......................................................................1422、改变初始化参数................................................................................................................1423、给备用数据库创建新的临时文件(属于临时表空间).....................................................1524、注册归档日志和启动SQLAPPLYSERVICES........................................................................1525、在主数据库配置远程归档.........................................................................................
