SQL> select name,status,checkpoint_change# from v$datafile_header;
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
ONLINE 828363
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF
ONLINE 828363
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEST.DBF
ONLINE 831081
已选择7行。
SQL> alter tablespace test begin backup;
表空间已更改。
SQL> select name,status,checkpoint_change# from v$datafile_header;
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
ONLINE 828363
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF
ONLINE 828363
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEST.DBF
ONLINE 831217
已选择7行。
SQL> insert into test values(1,2);
已创建 1 行。
SQL> commit;
提交完成。
SQL> select name,status,checkpoint_change# from v$datafile_header;
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
ONLINE 828363
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
ONLINE 828363
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF
ONLINE 828363
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEST.DBF
ONLINE 831217
已选择7行。
SQL> alter system checkpoint;
系统已更改。
SQL> select name,status,checkpoint_change# from v$datafile_header;
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
ONLINE 831256
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF
ONLINE 831256
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEST.DBF
ONLINE 831217
已选择7行。
SQL> alter database test end backup;
alter database test end backup
*
第 1 行出现错误:
ORA-01509: 指定的名称 'TEST' 与实际名称 'ORCL' 不匹配
SQL> alter tablespace test end backup;
表空间已更改。
SQL> select name,status,checkpoint_change# from v$datafile_header;
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
ONLINE 831256
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
ONLINE 831256
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF
ONLINE 831256
NAME
--------------------------------------------------------------------------------
STATUS CHECKPOINT_CHANGE#
------- ------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEST.DBF
ONLINE 831256
已选择7行。
结果证明：在表空间备份的情况下，并不影响我们业务的进行
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21416913/viewspace-719132/ ，如需转载，请注明出处，否则将追究法律责任。
