-
编辑 删除
DG tips
############################# switchover ###############################sql> select database_role ,open_mode,protection_mode,protection_level,switchover_status from v$database;sql> alter d...
-
编辑 删除
PDG
################################## on primary db ######################################[oracle@hzdevdb1 dbs]$ ll $oracle_home/dbs/orapwcfgdb-rw-r----- 1 oracle dba 1536 jul 13 06:27 ...
-
编辑 删除
RMAN cases
RMAN> backup database plus archivelog;$ scp * hzdevdb2:/home/oracle/OraBase/flash_recovery_area/CFGDB/backupset/2009_07_24 $ export ORACLE_SID=cfgdb$ rman target /RMAN> set dbid 359504372RM...
-
编辑 删除
RMAN recover
各种故障背景下的恢复方法 丢失或损坏的文件 归档模式 数据库状态 恢复方法 一个或多个数据文件 不归档模式 关闭状态 利用一致的完全数据库备份修复整个数据库，自从备份之后发生的所有修改...
-
编辑 删除
RMAN tips
RMAN>LIST COPY OF TABLESPACE 'SYSTEM'; RMAN>LIST BACKUP OF TABLESPACE 'SYSTEM' ; RMAN>DELETE OBSOLETE ; RMAN>DELETE EXPIRED BACKUP; RMAN>DELETE EXPIRED COPY ; RMAN>DELETE BACKUPSET 19 ; RMAN>DELETE BA...
-
编辑 删除
oracle auto startup and shutdown script
[root@hzdevdb2 OraHome1]# vi /etc/init.d/oracle #!/bin/sh# chkconfig: 345 85 15# description: This service is for oracle startup and shutdown.ORACLE_HOME=/home/oracle/OraBase/OraHome1ORACLE=oracle...
-
编辑 删除
Stream objects
Streams配置和管理相关packagedbms_steams_admdbms_capture_admdbms_propagation_admdbms_apply_admdbms_rule_admStreams主要相关数据字典dba_streams_administratordba_capturedba_capture_parametersdba_prop...
-
编辑 删除
2 listeners are serving for 1 instance .
1, netca .2, vi /home/oracle/OraBase/OraHome1/network/admin/tnsnames.oraLISTENERS_MAMBO = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hzdevdb1.mambo....
-
编辑 删除
ORA-27102: out of memory
Causeshmall is the total amount of shared memory, in pages, that the system can use at one time. SolutionSet shmall equal to the sum of all the SGAs on the system, divided by the...
-
编辑 删除
Stream alter parameter
AQ_TM_PROCESSESProperty DescriptionParameter type IntegerDefault value 0Modifiable ALTER SYSTEMRange of values 0 to 10Basic NoAQ_TM_PROCESSES enables time monitoring of queue messages. The tim...
-
编辑 删除
ORA-27054
Solution1) The problem can be solved by using the recommended mounting options which are: (hard,bg,proto=tcp,suid,rsize=32768,wsize=32768,noac)* Note that this list of options is not exhaustive, a...
-
编辑 删除
ORA-27086: unable to lock file - already in use
ORA-00202: control file: '/home/oracle/OraBase/cfgdata/CFGDB/controlfile/o1_mf_4pxvrjq1_.ctl'ORA-27086: unable to lock file - already in useLinux-x86_64 Error: 11: Resource temporarily unavailablesto...
-
编辑 删除
audit session
SQL> audit session by a,b by access whenever successful;Audit succeeded.SQL> CREATE PUBLIC SYNONYM audit4ab FOR SYS.DBA_AUDIT_SESSION;Synonym created.
-
编辑 删除
ORA-00257: archiver error. Connect internal only, until freed
SQL> select * from v$flash_recovery_area_usage;FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------ ------------------ ------------------------- ------...
-
编辑 删除
Install EMGC 102050
$vi /home/oracle/mambos/102010/response/em_with_new_db.rspUNIX_GROUP_NAME="oinstall" &n...
-
编辑 删除
EMGC Tips
102050/3731593/Disk1/stage/shiphomeproperties.xml <?xml version="1.0" standalone="yes" ?><ORACLEHOME_INFO> <ARU_PLATFORM_INFO> &...
-
编辑 删除
BMR
blockrecover datafile 7 block 1234;blockrecover datafile 7 block 1234 datafile 17 block 12345;
-
编辑 删除
Recovery from Complete Loss (No Controlfile)
$export ORACLE_SID=webdbSQL>startup force nomountRMAN>restore spfile from autobackup;RMAN>shutdown immediate;RMAN>startup nomount;RMAN>restore controlfile from autobackup;RMAN>alter database mou...
-
编辑 删除
Incrementally Updated Backups
RMAN> configure DEVICE TYPE DISK BACKUP TYPE TO copy ;RMAN> backup incremental level 0 tag 'IUB' database;RMAN> backup incremental level 1 for recover of copy tag 'IUB' database;-rw-r----- 1 ...
-
编辑 删除
OCP ?
2009-02-17 98% pass 1Z0-0422009-02-19 100% pass 1Z0-0072009-02-22 96% pass 1Z0-043OCP?不带劲!
