ArcerZhang`s Technology Blog

摘要： [系列50-共18集]Oracle公司 - Oracle RAC Workshop培训[系列51-共6集]Oracle公司 - Oracle 11g R2 RAC Hands on Training[系列59-共6集]小布 -Oracle 11gR2 RAC Installation[系列93-共15集]黄伟 -Oracle 11g R2 RAC + DG高端实战[系列145-共4集]King -Oracle RAC系列培训[系列219-共6集]Luocs - Oracle 11g R2 RAC安装系列培训[系列230-共2集]黄伟 - 黄伟之RAC生产库现场调整备份策略实战 阅读全文

摘要： Selecting the Right Linux SoftwareIP AddressUsers and GroupsThe Directory LayoutOracle SID 阅读全文

摘要： Grid Infrastructure这个软件包含了集群软件及ASM软件.ObjectivesAfter competing this seminar,you should be able to do the following:Learn the detailed process to setup Oracle 11gR2 RACLearn how to startup and shutdown RACLearn the basic administration method about RACRAC ArchitectureInterconnected nodes act as a sin 阅读全文

摘要： 复制数据库，采用目标数据库的备份可以进行；Active source database ---> TCP/IP ---> Destination or AUXILIARY databaseDuplicating a DatabaseWith network(no backups required)Including customized spfileVia Enterprise Manager or RMAN command linePerforming Active Database DuplicationThe RMAN DUPLICATE Command采用命令行方式克隆数据 阅读全文

摘要： 复制数据库两种方式:采用命令行方式采用OEM方式Ensuring That Backups and Archived Redo Log Files Are AvailableBackups of all target database files must be accessible on the duplicate host.Backups can be a combination of full and incremental backups.Archived redo log files needed to recover the duplicate database must be a 阅读全文

摘要： a说都发生 阅读全文

摘要： ObjectivesAfter completing this lesson,you should be able to :List the purpose of creating a duplicate database.Choose a technique for duplicating a database.Duplicate a database with RMANUse an RMAN backup to duplicate a databaseDuplicate a database based on a running instanceUsing a Duplicate Data 阅读全文

摘要： 检查数据库中存在的外部表，外部文件:SQL> show userUSER is "SYS"SQL> declare 2 external boolean; 3 begin 4 external := dbms_tdb.check_external; 5 end; 6 /PL/SQL procedure successfully completed.SQL> set serverout onSQL> /The following external tables exist in the database:SH.SALES_TRANSACTIONS_EX 阅读全文

摘要： 1、来自动态性能视图v$tempfile，临时文件信息SQL> select file#,name from v$tempfile; FILE# NAME---------- ------------------------------------------------------------ 1 D:\APP\MARYHU\ORADATA\ARCERZHANGDB\TEMP01.DBFView Code 2、添加临时文件alter tablespace tempadd tempfile 'f:\app\user\oradata\kelongdb\temp01.dbf... 阅读全文

摘要： Transporting DatabasesGeneralize the transportable tablespace featureData subsets can easily be distributed from a data warehorsing enviroment to data marts,which are usually on smaller platforms.A database can be migrated from one platform to another very quickly.Database Transportation Procedure:S 阅读全文