ArcerZhang`s Technology Blog

摘要： 1、查看Data File 结构SQL> desc dba_data_files; Name Null? Type ----------------------------------------------------------------------------------------------------------------- -------- -------... 阅读全文

摘要： 表空间结构SQL> desc dba_tablespaces; Name Null? Type ----------------------------------------------------------------------------------------------------------------- -------- -----------------... 阅读全文

摘要： 1、查看数据文件SQL> select name,status from v$datafile;NAME STATUS-------------------------------------------------- -------/u01/oradata/poli/system01.dbf SYSTEM/u01/oradata/poli/sysaux01.dbf ONLINE/u01/oradata/poli/undot... 阅读全文

摘要： 1、RMAN连接远端数据库rman target sys/oracle@DB200 nocatalog2、查看RMAN的配置信息show all;(rman登陆成功后，执行show all命令;)3、修改rman配置文件之前默认Device type是Disk，现在需要修改成sbt;操作命令如下:configure default device type to sbt;恢复Device type为Diskconfigure default device type clear;4、数据库备份backup database;View Code RMAN> backup database; . 阅读全文

摘要： NOARCHIVELOG ModeImplications of NOARCHIVELOG ModeIf a tablespace becomes unavaliable because of a failure,you cannot continue to operate the database until the tablespace has been dropped or the entire database has been restored from backups.Auto and Manual Archivingoracle server有归档模式与非归档模式之分，如果是归档 阅读全文

摘要： After completing this lesson,you should be able to do the following:Describe the Oracle processes,memory structures,and files relating to recoveryIdentify the importance of checkpoints,redo log files,and archived log filesDescribe ways to tune instance recoveryTypes of CheckpointsFull checkpointAll 阅读全文

摘要： 1、sqlplus sys/pwd as sysdba2、show parameter background_dump_destSQL> show parameter background_dumpNAME TYPE VALUE------------------------------------ ----------- ------------------------------background_dump_dest string /RealData/diag/rdbms/datacenter/DATA... 阅读全文

摘要： 1、Oracle存储数据的原理是什么？用户创建一张表，COMMIT之前，是存储在内存中的，COMMIT之后，先是存储到REDO LOG FILE中，最后才是写往DATA FILE；2、DDL语句是不需要进行commit的，DML语句是需要commit的；3、alter system checkpoint;将数据写到datafile中；4、alter system switch logfile;将数据归档，写到archive log file中； 阅读全文

摘要： 1、概述Fundamental II第一至第五章，内容涵盖oracle net相关内容,第六至第十七章内容涵盖备份与恢复内容； 阅读全文

摘要： Backup and Recovery Issues [备份与恢复所关心的问题]Protect the database from numerous types of failuresIncrease Mean-Time-Between-Failures(MTBF) [平均无故障时间]Decrease Mean-Time-To-Reconver(MTTR) [平均抢修时间]Minimize data lossCategories of FailuresStatement failure(sql 语句Causes of Statement FailuresLogic error in an ap 阅读全文