摘要：无备份恢复表空间前提是归档存在[oracle@NetData-ora10g-118 ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Aug 5 10:02:46 2014Copyright (c) 1... 阅读全文

摘要：模拟环境1. 做操作之前先备份数据库RMAN> run { # Hot database level 0 whole backup allocate channel t1 type disk; backup incremental level 0 skip inaccessible format '... 阅读全文

摘要：环境:源:os:windowsdb:11.2.0.1ip:192.168.213.129sid:orcl远程机导出:os:centos 6.5 x64db:11.2.0.4ip:192.168.213.199sid:netdata在213.199 上导出213.129schema为test的用户数据... 阅读全文

摘要：规划： IP:192.168.213.199 mask: 255.255.255.0 gateway:192.168.213.1 DNS1:202.101.172.35 磁盘分区: 磁盘总大小:25G /u01 5*1024 5120M 数据库软件分区至少大于5G /oradata 12*1024 12288M 数据库文件分区 /swap 1100*2M / 剩下 1. 插入光盘... 阅读全文

摘要：Oracle 11.2.4.0 ADG 单实例安装(COPY创建备库) 规划： 主:OS: Linux Centos 6.5 X64 hostname:ORA11G-DG1 ipaddress:192.168.213.199 db_unique_name=netdata... 阅读全文

摘要：整理自网络+实验字符集介绍影响Oracle数据库字符集最重要的参数是NLS_LANG参数。它的格式如下: NLS_LANG = language_territory.charsetNLS_LANG参数由以下部分组成:NLS_LANG=_.NLS_LANG各部分含义如下:LANGUAGE指定:-Ora... 阅读全文

摘要：oracle 利用flashback将备库激活为read wirte(10g 及上)环境:OS: CENTOS 6.5 X64DB: ORACLE 10.2.0.5主库操作:SQL> alter system switch logfile;System altered.SQL> 备库操作取消归档应用... 阅读全文

摘要：dataguard 归档丢失(主库中无此丢失归档处理),备库基于SCN恢复环境:OS: CentOS 6.5DB: Oracle 10.2.0.5 １.主备库环境主库:SQL> select dbid,name,LOG_MODE,open_mode,db_unique_name,DATABASE_R... 阅读全文

摘要：环境: OS: CentOS 6.5 X64 DB: oracle 10.2.0.5故障:之前由于错误激活备库主写导致主备日志同步，重建备库1.关闭备库，删除数据文件及控制文件,redo文件rm -rf *.log rm -rf *.ctl rm -rf *.dbf2.主库备库channel OR... 阅读全文

摘要：DG在线日志组大小修改环境(单实例,Centos 6.5 X64,oracle 10.2.0.5,filesystem存储)REDO ONLINE LOGselect * from v$logfile where type='STANDBY';　＃查询为standby log　三组STANDBY L... 阅读全文

摘要：Flashback Tips The following tips and restrictions apply to using flashback features. Flashback Tips – Performance For better performance, generate statistics on all tables involved in a ... 阅读全文

摘要：CLUSTER_DATABASE Property Description Parameter type Boolean Default value false Modifiable No Range of values true | false Basic Yes Real Application Clusters For all instances, ... 阅读全文

摘要：一. 数据库软件安装参照官方手册1.安装rpm包注这里的yum直接用163的yumyum -y install binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf elfutils-libelf-devel gc... 阅读全文

摘要：author by :shawnloong环境：windows 2008 r2 sp1 db:oracle 11g r2做之前记得做个完整备份ONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON;脚本如下run { delete noprompt obsolete; allocate channel cha1 type disk; allocate channel cha2 type disk; backup database format "c:\bak... 阅读全文

摘要：[oracle@oracledb1 admin]$ vi listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTI 阅读全文

摘要：oracle 启动状态由nomount-mount-open一. nomount状态下操作08:09:49 idle> startup nomount; ORACLE instance started.Total System Global Area 488534016 bytes Fixed Size2214616 bytes Variable Size364905768 bytes Database Buffers113246208 bytes Redo Buffers8167424 bytes 08:10:00idle>当 Oracle 启动实例时，首先需要从服务器参数文件（ 阅读全文

摘要：Oracle 11g Redhat 5安装一、检查硬件是否满足要求检查一内存　On Linux x86:At least 1 GB of RAM 内存至少1GTo determine the RAM size, enter the following command:# grep MemTotal ... 阅读全文

摘要：1.脱机数据文件用户可以将除system表空间的任何表空间offline如果表空间offline对应的对应数据文件也会offine测试19:45:16 sys@ORADB11G> alter tablespace users offline; Tablespace altered.查看表空间状态19:43:51 sys@ORADB11G> select TABLESPACE_NAME,status from dba_tablespaces; TABLESPACE_NAME STATUS------------------------------ ---------SYSTEM ON 阅读全文

摘要：1. 修改．bash_profileoracle_sid=PROD对象别名可创建2.创建建库所需文件夹admin(adump dudmp )oradata3．创建密码文件(as sysdba可使用多少个用户登录)cd $ORACLE_HOME/dbsorapwd file=orapwPROD entries=30 password=oraclelinux 密码文件的命名为orapw+oracle_sidwindows 密码文件命名为pwd+oracle_sid4.创建并修改参数文件创建参数cd /u01/oracle/product/11.2.0/db_1/dbs[oracle@oraclea 阅读全文

摘要：1.创建闪回归档表空间11:17:46 sys@ORA11G> create tablespace mytest datafile size 100m extent management local uniform size 1m segment space management auto; Tablespace created.2.创建闪回归档11:19:21 sys@ORA11G> create flashback archive flashback1 tablespace mytest retention 4year; Flashback archive created.3. 阅读全文