OFFLINE不同选项的测试(NORMAL,TEMPORARY,IMMEDIATE)(一)
来源:互联网 发布:杨德昌 一一 知乎 编辑:程序博客网 时间:2024/06/07 17:11
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 2
Next log sequence to archive 4
Current log sequence 4
SQL> alter system switch logfile;
System altered.
SQL> create table t(scn int) tablespace users;
Table created.
SQL> insert into t select dbms_flashback.get_system_change_Number from dba_objects where rownum<=1000;
1000 rows created.
SQL> commit;
Commit complete.
SQL> select max(scn),min(scn) from t;
MAX(SCN) MIN(SCN)
---------- ----------
658591 658591
SQL> select change# from v$instance;
select change# from v$instance
*
ERROR at line 1:
ORA-00904: "CHANGE#": invalid identifier
SQL> insert into t select dbms_flashback.get_system_change_number from dba_objects where rownum<1000;
999 rows created.
SQL> insert into t select dbms_flashback.get_system_change_number from dba_objects where rownum<2;
1 row created.
SQL> select distinct scn,count(*) from t group by scn;
SCN COUNT(*)
---------- ----------
659277 1
658591 1000
659275 999
SQL> insert into t select dbms_flashback.get_system_change_number from t;
2000 rows created.
SQL> select distinct scn,count(*) from t group by scn;
SCN COUNT(*)
---------- ----------
659277 1
658591 1000
659275 999
659295 469
659293 1531
SQL> commit;
Commit complete.
SQL> select group#,bytes,archived,first_change#,sequence#,status from v$log;
GROUP# BYTES ARC FIRST_CHANGE# SEQUENCE# STATUS
---------- ---------- --- ------------- ---------- ----------------
1 52428800 YES 637009 4 INACTIVE
2 52428800 NO 658540 5 CURRENT
3 52428800 YES 614226 3 INACTIVE
SQL>
SQL>
SQL> alter system checkpoint;
System altered.
SQL> select substr(name,1,40) dname,checkpoint_change#,last_change#,offline_change#,status from v$datafile;
DNAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# STATUS
------------------ ------------ --------------- -------
/u01/oradata/orac10g21/system01.dbf
659333 602446 SYSTEM
/u01/oradata/orac10g21/undotbs01.dbf
659333 602446 ONLINE
/u01/oradata/orac10g21/sysaux01.dbf
659333 602446 ONLINE
DNAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# STATUS
------------------ ------------ --------------- -------
/u01/oradata/orac10g21/users01.dbf
659333 602446 ONLINE
/u01/oradata/orac10g21/example01.dbf
659333 602446 ONLINE
/u01/oradata/orac10g21/testing_lmt.dbf
659333 0 ONLINE
DNAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# STATUS
------------------ ------------ --------------- -------
/u01/oradata/orac10g21/tbs_test_01.dbf
659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_02.dbf
659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_03.dbf
659333 0 ONLINE
9 rows selected.
SQL> set linesize 2000
SQL> select substr(name,1,40) dname,checkpoint_change#,last_change#,offline_change#,status from v$datafile;
DNAME CHECKPOINT_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# STATUS
-------------------------------------------------------------------------------- ------------------ ------------ --------------- -------
/u01/oradata/orac10g21/system01.dbf 659333 602446 SYSTEM
/u01/oradata/orac10g21/undotbs01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/sysaux01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/users01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/example01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/testing_lmt.dbf 659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_01.dbf 659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_02.dbf 659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_03.dbf 659333 0 ONLINE
9 rows selected.
SQL> select name from v$datafile;
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/oradata/orac10g21/system01.dbf
/u01/oradata/orac10g21/undotbs01.dbf
/u01/oradata/orac10g21/sysaux01.dbf
/u01/oradata/orac10g21/users01.dbf
/u01/oradata/orac10g21/example01.dbf
/u01/oradata/orac10g21/testing_lmt.dbf
/u01/oradata/orac10g21/tbs_test_01.dbf
/u01/oradata/orac10g21/tbs_test_02.dbf
/u01/oradata/orac10g21/tbs_test_03.dbf
9 rows selected.
SQL> alter tablespace users add datafile '/u01/oradata/orac10g21/users02.dbf' size 10m;
Tablespace altered.
SQL> select substr(name,1,40) dname,checkpoint_change#,last_change#,offline_change#,status from v$datafile;
DNAME CHECKPOINT_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# STATUS
-------------------------------------------------------------------------------- ------------------ ------------ --------------- -------
/u01/oradata/orac10g21/system01.dbf 659333 602446 SYSTEM
/u01/oradata/orac10g21/undotbs01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/sysaux01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/users01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/example01.dbf 659333 602446 ONLINE
/u01/oradata/orac10g21/testing_lmt.dbf 659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_01.dbf 659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_02.dbf 659333 0 ONLINE
/u01/oradata/orac10g21/tbs_test_03.dbf 659333 0 ONLINE
/u01/oradata/orac10g21/users02.dbf 659640 0 ONLINE
10 rows selected.
SQL>- OFFLINE不同选项的测试(NORMAL,TEMPORARY,IMMEDIATE)(一)
- shutdown的normal、transactional、immediate、abort
- 动态SQL和PL/SQL的EXECUTE IMMEDIATE选项(转)
- IMMEDIATE DECODABILITY(前缀)
- 测试使数据文件offline的情景
- 动态SQL和PL/SQL的EXECUTE IMMEDIATE选项
- 动态SQL和PL/SQL的EXECUTE IMMEDIATE选项(转载)
- 动态SQL和PL/SQL的EXECUTE IMMEDIATE选项
- 动态SQL和PL/SQL的EXECUTE IMMEDIATE选项(转载)
- 动态SQL和PL/SQL的EXECUTE IMMEDIATE选项
- 动态SQL和PL/SQL的EXECUTE IMMEDIATE选项
- shutdown normal、transactional、immediate关闭启动
- Socket选项的那些事(一)
- 正态分布(Normal Distribution)
- normal、sysdba、sysoper不同身份登陆oracle的区别理解
- normal、sysdba、sysoper不同身份登陆oracle的区别理解
- IMMEDIATE DECODABILITY(字典树)
- 即时函数(Immediate Functions)
- 1125--来hc一年了
- 在Xcode 3.x中如何重命名一个工程
- 奇怪的错误:This generally means that another instance of this process was already running or is hung in t
- Distimo报告:WP7 Marketplace一周年
- 【总结】Oracle sql 中的字符(串)替换与转换
- OFFLINE不同选项的测试(NORMAL,TEMPORARY,IMMEDIATE)(一)
- linux时间同步
- 我奋斗了18年才和你坐在一起喝咖啡
- Freescale iMx51开发
- oracle SCN 详解(原创)
- 跟我一起写 Makefile
- 跳表
- tick
- COM组件的运行机制,即COM是怎么跑起来的