eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 进京两周年记-Eygle在北京的生活之六 | Blog首页 | 进京两周年记-Eygle在北京的生活之七 »

Oracle10g新增的用以简化用户管理备份的命令

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 >

历史上的今天...
    >> 2012-04-06文章:
    >> 2008-04-06文章:
           偶遇孟静
    >> 2007-04-06文章:
           CSDN英雄会上会英雄
    >> 2006-04-06文章:
           Oracle10g与各版本的连通性
    >> 2004-04-06文章:

无觅

By eygle on 2005-04-06 22:28 | Comments (0) | Backup&Recovery | 245 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com