« 进京两周年记-Eygle在北京的生活之六 | Blog首页 | 进京两周年记-Eygle在北京的生活之七 »
Oracle10g新增的用以简化用户管理备份的命令
作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】链接：http://www.eygle.com/archives/2005/04/oracle10gaooeae.html
Oracle10g新增命令用以简化用户管理的备份，可以通过
alter database begin/end backup来进行数据库备份模式的切换。
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Apr 6 22:31:33 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SYS AS SYSDBA on 06-APR-05 >alter database begin backup;
Database altered.
SYS AS SYSDBA on 06-APR-05 >desc v$backup
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
STATUS VARCHAR2(18)
CHANGE# NUMBER
TIME DATE
SYS AS SYSDBA on 06-APR-05 >select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ------------
1 ACTIVE 11000149 06-APR-05
2 ACTIVE 11000149 06-APR-05
3 ACTIVE 11000149 06-APR-05
4 ACTIVE 11000149 06-APR-05
5 ACTIVE 11000149 06-APR-05
6 ACTIVE 11000149 06-APR-05
7 ACTIVE 11000149 06-APR-05
9 ACTIVE 11000149 06-APR-05
10 ACTIVE 11000149 06-APR-05
11 ACTIVE 11000149 06-APR-05
10 rows selected.
SYS AS SYSDBA on 06-APR-05 >alter database end backup;
Database altered.
SYS AS SYSDBA on 06-APR-05 >select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ------------
1 NOT ACTIVE 11000149 06-APR-05
2 NOT ACTIVE 11000149 06-APR-05
3 NOT ACTIVE 11000149 06-APR-05
4 NOT ACTIVE 11000149 06-APR-05
5 NOT ACTIVE 11000149 06-APR-05
6 NOT ACTIVE 11000149 06-APR-05
7 NOT ACTIVE 11000149 06-APR-05
9 NOT ACTIVE 11000149 06-APR-05
10 NOT ACTIVE 11000149 06-APR-05
11 NOT ACTIVE 11000149 06-APR-05
10 rows selected.
SYS AS SYSDBA on 06-APR-05 >
|
By eygle on 2005-04-06 22:28 | Comments (0) | Posted to Backup&Recovery | Edit |Pageviews:
| 相关文章 | 随机文章 |
|
Jan Dara 2-晚娘II Netapp中如何挂接根卷(root volume) 从《越狱》（Prison Break）看中美差异 Linux RAC OCFS文件系统与INODES 什么是内存的Parity、ECC和SPD |
网上相关主题:
