-
编辑 删除
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.
-
编辑 删除
Dell OpenManage Server
# rpm -ivh net-snmp-5.1.2-11.EL4.11.x86_64.rpm#tar -zxvf OM_5.5.0_ManNode_A00.tar.gz #cd linux/supportscripts/#./srvadmin-install.sh --express#./srvadmin-services.sh starthttps://10.224.188.29:...
-
编辑 删除
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;
-
编辑 删除
tar linux
Ø mount 10.224.188.188:/vol/tribox /mnt/cdromØ cd /Ø tar –czplvf /mnt/cdrom/tribox.tgz . boot
-
编辑 删除
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?不带劲!
-
编辑 删除
Grant general user login EM
SQL> grant select_catalog_role to scott;
-
编辑 删除
手工 RAC Archive , flashback
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+WEBLOG/' SCOPE=SPFILE SID='*';ORALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' SCOPE=SPFILE SID='*';ALTER SYSTEM SET CLUSTER_D...
-
编辑 删除
TTS (PT)
Before: PT_Table:EMPP1_Tablespace:PTS1P2_Tablespace:PTS2 After: PT_Table:EMPP1_Tablespace:PTS1P2_Tablespace:PTS2 PTS1 TTS to NewDB. Action: create ...
-
编辑 删除
LogMiner
execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_4_4qmyvk67_.arc',dbms_logmnr.new);execute DBMS_LOGMNR.ADD_LOGFILE ('/..o1_mf_1_3_4qmyq1bl_.arc',dbms_logmnr.addfile);execute DBMS_LOGMNR.ADD_LOGFILE ('/....
-
编辑 删除
PT_IOT test
CREATE TABLE BENCHMARK.H_ORDER_IOT_PA( O_ORDERKEY NUMBER NOT NULL, O_CUSTKEY NUMBER...
-
编辑 删除
PT test
CREATE TABLE BENCHMARK.H_ORDER_PA( O_ORDERKEY NUMBER PRIMARY KEY NOT NULL, O_CUSTKEY  ...
-
编辑 删除
IOT test
SELECT * FROM h_order WHERE O_orderdate > TO_DATE ('1998-1-1', 'YYYY-MM-DD')ORDER BY o_orderdate; CREATE ...
-
编辑 删除
dbms_redefinition
Note: DBMS_REDEFINITION is used to redefine table columns and column names. Tables that can not be redefined are: Tables that have materialized views and materialized view logs defined on them ...
