|
ASM Diskgroup 没有自动挂起来:
- [root@station90 桌面]# oracleasm-discover
- Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so
- [ASM Library - Generic Linux, version 2.0.4 (KABI_V2)]
- Discovered disk: ORCL:ASMDISK01 [307200 blocks (157286400 bytes), maxio 128]
- Discovered disk: ORCL:ASMDISK02 [307200 blocks (157286400 bytes), maxio 128]
- Discovered disk: ORCL:ASMDISK03 [307200 blocks (157286400 bytes), maxio 128]
- Discovered disk: ORCL:ASMDISK04 [307200 blocks (157286400 bytes), maxio 128]
- Discovered disk: ORCL:ASMDISK05 [307200 blocks (157286400 bytes), maxio 128]
- Discovered disk: ORCL:ASMDISK06 [307200 blocks (157286400 bytes), maxio 128]
复制代码- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 25 09:09:29 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysasm
- Connected.
- SQL> desc v$asm_diskgroup
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- GROUP_NUMBER NUMBER
- NAME VARCHAR2(30)
- SECTOR_SIZE NUMBER
- BLOCK_SIZE NUMBER
- ALLOCATION_UNIT_SIZE NUMBER
- STATE VARCHAR2(11)
- TYPE VARCHAR2(6)
- TOTAL_MB NUMBER
- FREE_MB NUMBER
- HOT_USED_MB NUMBER
- COLD_USED_MB NUMBER
- REQUIRED_MIRROR_FREE_MB NUMBER
- USABLE_FILE_MB NUMBER
- OFFLINE_DISKS NUMBER
- COMPATIBILITY VARCHAR2(60)
- DATABASE_COMPATIBILITY VARCHAR2(60)
- VOTING_FILES VARCHAR2(1)
- SQL> select NAME , STATE from v$asm_diskgroup;
- NAME
- --------------------------------------------------------------------------------
- STATE
- ---------------------------------
- DATA
- MOUNTED
- HIGHDATA
- DISMOUNTED
- FRA
- MOUNTED
- SQL> show parameter diskgroup
- NAME TYPE
- ------------------------------------ ---------------------------------
- VALUE
- ------------------------------
- asm_diskgroups string
- FRA
- SQL> alter diskgroup highdata mount [FORCE];
- Diskgroup altered.
- SQL>
复制代码
磁盘可以当作小容量来用:
- create diskgroup highdata high redundancy failgroup f1
- 2 disk '/dev/raw/raw1' name d1 size 80M , '/dev/raw/raw2' name d2 size 80M
- 3 failgroup f2
- 4 disk '/dev/raw/raw3' name d3 size 80M , '/dev/raw/raw4' name d4 size 80M
- 5 failgroup f3
- 6* disk '/dev/raw/raw5' name d5 size 80M , '/dev/raw/raw6' name d6 size 80M
- SQL> /
复制代码- select * from v$asm_diskgroup;
- select * from v$asm_disk order by 1;
- select * from v$asm_operation;
- select * from V$ASM_CLIENT;
- select * from V$ASM_ATTRIBUTE order by group_number;
- alter diskgroup highdata set attribute 'compatible.asm'='11.2.0' ;
- select * from V$ASM_TEMPLATE order by group_number;
- select * from V$ASM_ALIAS where lower(name) ='current.260.816169631';
- select * from v$asm_file where group_number=1 and file_number=260;
复制代码- select * from V$ASM_TEMPLATE order by group_number;
- alter diskgroup data add template temp1 attributes (unprotected fine );
- alter diskgroup highdata add template temp3 attributes (mirror fine );
- alter diskgroup fra add template temp2 attributes (mirror fine );
- alter diskgroup data add alias '+DATA/orcl/datafile/users01.dbf' for '+DATA/orcl/datafile/users.259.816169553';
- select * from v$asm_alias where lower(name) in ('users01.dbf',
- 'users.259.816169553');
复制代码- select * from dba_data_files;
- create tablespace mydata datafile '+data/orcl/datafile/mydata01.dbf' size 5M;
复制代码- select * from v$asm_alias where lower(name) ='mydata01.dbf';
- select * from v$asm_file where group_number=1 and
- file_number=267;
-
- select * from v$asm_alias where group_number=1 and
- file_number=267;
复制代码- create tablespace yourdata datafile '+data(temp1)/orcl/datafile/yourdata01.dbf' size 5M;
复制代码- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 25 15:56:57 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn hr/oracle_4U
- ERROR:
- ORA-28002: the password will expire within 7 days
- Connected.
- SQL> select salary from employees where employee_id=100;
- SALARY
- ----------
- 24000
- SQL> update employees set salary=25000 where employee_id=100;
- 1 row updated.
- SQL> commit;
- Commit complete.
- SQL> select salary from employees as of scn 1387598 where employee_id=100;
- SALARY
- ----------
- 25000
- SQL> select salary from employees where employee_id=100;
- SALARY
- ----------
- 25000
- SQL> select salary from employees as of scn 1387597 where employee_id=100;
- SALARY
- ----------
- 24000
- SQL> select salary from employees as of timestamp to_timestamp('2018-03-25:15:59:53','YYYY-MM-DD:HH24:MI:SS') where employee_id=100;
- SALARY
- ----------
- 24000
- SQL>
复制代码- select xid from v$transaction;
- --09001D001A040000
- select * from flashback_transaction_query
- where table_name='EMPLOYEES' and logon_user='HR';
复制代码- select * from flashback_transaction_query
- where table_name='T05310_A' and logon_user='HR' order by 3 ,5;
- select versions_xid, versions_operation , versions_startscn ,a
- from hr.t05310_a versions between scn minvalue and maxvalue
- order by 3;
-
- select a from hr.t05310_a as of scn 1389474;
- select t.row_movement from dba_tables t
- where t.owner='HR' and t.table_name='T05310_A';
-
- alter table hr.T05310_A enable row movement;
- select * from hr.t05310_a;
复制代码- select * from flashback_transaction_query
- where table_name='TAB' order by 3 desc ,5 ;
-
- select d.SUPPLEMENTAL_LOG_DATA_MIN,
- d.SUPPLEMENTAL_LOG_DATA_PK,
- d.SUPPLEMENTAL_LOG_DATA_UI,
- d.SUPPLEMENTAL_LOG_DATA_FK,
- d.SUPPLEMENTAL_LOG_DATA_ALL
- from v_$database d;
- ----
- alter database add supplemental log data ;
- select d.SUPPLEMENTAL_LOG_DATA_MIN,
- d.SUPPLEMENTAL_LOG_DATA_PK,
- d.SUPPLEMENTAL_LOG_DATA_UI,
- d.SUPPLEMENTAL_LOG_DATA_FK,
- d.SUPPLEMENTAL_LOG_DATA_ALL
- from v_$database d;
-
- alter database add supplemental log data ;
-
- select object_id from dba_objects where object_name ='T05310_B';
-
- ---74740
- select * from flashback_transaction_query
- where table_name='TAB' order by 3 desc ,5 ;
-
复制代码
|
|