数据库有三种启动模式
启动模式 | 说明 |
NOMOUNT模式 | 启动例程,但不装载数据库,即只完成启动步骤的第1步 |
MOUNT模式 | 启动例程,并装载数据库,但不打开数据库,即只完成启动步骤的第1步和第2步 |
OPEN模式 | 启动例程、装载数据库、打开数据库,即完成全部的启动步骤 |
启动数据库实例有五种方式
1.启动数据库实例,装载并打开数据库。
(1)这是默认的启动数据库操作,直接使用startup命令即可实现此功能。使用此种方式启动数据库后,用户可以连接到数据库并执行数据访问操作。
(2)除了启动数据库实例、装载并打开数据库外,startup命令还将从默认位置读取初始化参数。
2. 启动数据库实例,不装载数据库。
startup NOMOUNT
3.启动数据库实例,装载数据库,但不打开数据库。
startup MOUNT
4. 启动后限制对数据库实例的访问。可在该方式下执行如下操作:
导入和导出数据。
执行数据载入。
临时阻止指定的用户访问数据库。
执行迁移或升级操作。
startup restrict
restrict子句可以与MOUNT、NOMOUNT、OPEN子句结合使用。启动数据库到受限模式后,只有拥有Restricted Session权限的用户才能访问数据库。
5、强制实例启动
startup force
一,nomount
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
SQL> startup nomount;
ORACLE
Total
SystemGlobal Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 188746628 bytes
Database
Buffers 415236096 bytes
Redo Buffers 7135232 bytes
SQL>select*from V$datafile;
select*from V$datafile
*
1
:
ORA
-01507: ??????
SQL>select*from scott.emp;
select*from scott.emp
*
1
:
ORA
-01219: ??????: ???????/?????
SQL>select name from V$database;
select name from V$database
*
1
:
ORA
-01507: ??????
SQL>select userfrom user_users;
select userfrom user_users
*
1
:
ORA
-01219: ??????: ???????/?????
SQL>shutdownimmediate;
ORA
-01507: ??????
ORACLE
SQL> spool off
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
二,mount
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
SQL> startup mount;
ORACLE
Total
SystemGlobal Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 188746628 bytes
Database
Buffers 415236096 bytes
Redo Buffers 7135232 bytes
SQL>select*from V$datafile;
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
1 9 30
-8 -05 0 1 SYSTEM
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666115 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
666115 13
-4 -13 534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 503316480 61440 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
2 532340 30
-8 -05 1 2 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666115 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
666115 13
-4 -13 534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 36700160 4480 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
3 6100 30
-8 -05 2 3 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666115 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
666115 13
-4 -13 534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 262144000 32000 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
4 9769 30
-8 -05 4 4 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666115 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
666115 13
-4 -13 534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 5242880 640 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
5 560323 12
-4 -13 6 5 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666115 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
666115 13
-4 -13 0 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
104857600 12800 104857600 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
SQL>select*from scott.emp;
select*from scott.emp
1
:
ORA
-01219::/
SQL>select name from V$database;
NAME
---------
ORCL
SQL>selectuserfrom user_users;
selectuserfrom user_users
*
1
:
ORA
-01219::/
SQL>desc V$database;
?
----------------------------------------- -------- ----------------------------
DBID NUMBER
NAME VARCHAR2
(9)
CREATED
DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME
DATE
PRIOR_RESETLOGS_CHANGE# NUMBER
PRIOR_RESETLOGS_TIME
DATE
LOG_MODE VARCHAR2
(12)
CHECKPOINT_CHANGE# NUMBER
ARCHIVE_CHANGE# NUMBER
CONTROLFILE_TYPE VARCHAR2
(7)
CONTROLFILE_CREATED
DATE
CONTROLFILE_SEQUENCE# NUMBER
CONTROLFILE_CHANGE# NUMBER
CONTROLFILE_TIME
DATE
OPEN_RESETLOGS VARCHAR2
(11)
VERSION_TIME
DATE
OPEN_MODE VARCHAR2
(10)
PROTECTION_MODE VARCHAR2
(20)
PROTECTION_LEVEL VARCHAR2
(20)
REMOTE_ARCHIVE VARCHAR2
(8)
ACTIVATION# NUMBER
SWITCHOVER# NUMBER
DATABASE_ROLE VARCHAR2
(16)
ARCHIVELOG_CHANGE# NUMBER
ARCHIVELOG_COMPRESSION VARCHAR2
(8)
SWITCHOVER_STATUS VARCHAR2
(20)
DATAGUARD_BROKER VARCHAR2
(8)
GUARD_STATUS VARCHAR2
(7)
SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2
(8)
SUPPLEMENTAL_LOG_DATA_PK VARCHAR2
(3)
SUPPLEMENTAL_LOG_DATA_UI VARCHAR2
(3)
FORCE_LOGGING VARCHAR2
(3)
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2
(101)
RECOVERY_TARGET_INCARNATION# NUMBER
LAST_OPEN_INCARNATION# NUMBER
CURRENT_SCN NUMBER
FLASHBACK_ON VARCHAR2
(18)
SUPPLEMENTAL_LOG_DATA_FK VARCHAR2
(3)
SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2
(3)
DB_UNIQUE_NAME VARCHAR2
(30)
STANDBY_BECAME_PRIMARY_SCN NUMBER
FS_FAILOVER_STATUS VARCHAR2
(21)
FS_FAILOVER_CURRENT_TARGET VARCHAR2
(30)
FS_FAILOVER_THRESHOLD NUMBER
FS_FAILOVER_OBSERVER_PRESENT VARCHAR2
(7)
FS_FAILOVER_OBSERVER_HOST VARCHAR2
(512)
SQL>shutdownimmediate;
ORA
-01109:
ORACLE
SQL> spool off;
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
三,open
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
SQL> startup open;
ORACLE
Total
SystemGlobal Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 188746628 bytes
Database
Buffers 415236096 bytes
Redo Buffers 7135232 bytes
SQL>select*from V$datafile;
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
1 9 30
-8 -05 0 1 SYSTEM
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666116 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 503316480 61440 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
2 532340 30
-8 -05 1 2 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666116 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 36700160 4480 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
3 6100 30
-8 -05 2 3 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666116 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 262144000 32000 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
4 9769 30
-8 -05 4 4 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666116 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
534906 534907
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
12
-4 -13 5242880 640 0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
5 560323 12
-4 -13 6 5 ONLINE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
READ
WRITE 666116 13-4 -13 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
104857600 12800 104857600 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0 8192
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
NONE
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
0
FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE#
STATUS
---------- ---------------- -------------- ---------- ---------- -------
ENABLED
CHECKPOINT_CHANGE# CHECKPOINT_TIM UNRECOVERABLE_CHANGE#
---------- ------------------ -------------- ---------------------
UNRECOVERABLE_ LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE#
-------------- ------------ -------------- --------------- --------------
ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
--------------------------------------------------------------------------------
FIRST_NONLOGGED_SCN FIRST_NONLOGGE
------------------- --------------
SQL>select*from scott.emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 17
-12-80 800
20
7499 ALLEN SALESMAN 7698 20
-2 -81 1600 300
30
7521 WARD SALESMAN 7698 22
-2 -81 1250 500
30
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7566 JONES MANAGER 7839 02
-4 -81 2975
20
7654 MARTIN SALESMAN 7698 28
-9 -81 1250 1400
30
7698 BLAKE MANAGER 7839 01
-5 -81 2850
30
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7782 CLARK MANAGER 7839 09
-6 -81 2450
10
7788 SCOTT ANALYST 7566 19
-4 -87 3000
20
7839 KING PRESIDENT 17
-11-81 5000
10
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7844 TURNER SALESMAN 7698 08
-9 -81 1500 0
30
7876 ADAMS CLERK 7788 23
-5 -87 1100
20
7900 JAMES CLERK 7698 03
-12-81 950
30
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7902 FORD ANALYST 7566 03
-12-81 3000
20
7934 MILLER CLERK 7782 23
-1 -82 1300
10
14
SQL> edit
file afiedt.buf
1
*select name,created,dbidfrom v$database
SQL>/
NAME CREATED
DBID
--------- -------------- ----------
ORCL 12
-4 -13 1340286805
SQL> show user
USER
"SYS"
SQL>selectuserfrom user_users;
USER
------------------------------
SYS
SQL>select ename,sal from emp;
select ename,sal from emp
1
:
ORA
-00942:
SQL>shutdownimmediate;
ORACLE
SQL> spool off;
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@