558.Which view provides information on the backup status of the datafiles in the database?
A. V$BACKUP
B. V$BACKUP_STATUS
C. V$BACKUP_DATAFILE
D. V$DATAFILE_BACKUP
E. V$TABLESPCE_BACKUP
Answer: A
参考: http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1044.htm#REFRN30017
注意输出:
SQL> select * from v$backup
2 /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 1478037 03-APR-16
2 NOT ACTIVE 1478037 03-APR-16
3 NOT ACTIVE 1478037 03-APR-16
4 NOT ACTIVE 1478037 03-APR-16
5 NOT ACTIVE 1478037 03-APR-16
6 NOT ACTIVE 1478037 03-APR-16
6 rows selected.
SQL> alter tablespace users begin backup;
Tablespace altered.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 1478037 03-APR-16
2 NOT ACTIVE 1478037 03-APR-16
3 NOT ACTIVE 1478037 03-APR-16
4 ACTIVE 1498645 03-APR-16
5 NOT ACTIVE 1478037 03-APR-16
6 NOT ACTIVE 1478037 03-APR-16
6 rows selected.
A. V$BACKUP
B. V$BACKUP_STATUS
C. V$BACKUP_DATAFILE
D. V$DATAFILE_BACKUP
E. V$TABLESPCE_BACKUP
Answer: A
参考: http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1044.htm#REFRN30017
注意输出:
SQL> select * from v$backup
2 /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 1478037 03-APR-16
2 NOT ACTIVE 1478037 03-APR-16
3 NOT ACTIVE 1478037 03-APR-16
4 NOT ACTIVE 1478037 03-APR-16
5 NOT ACTIVE 1478037 03-APR-16
6 NOT ACTIVE 1478037 03-APR-16
6 rows selected.
SQL> alter tablespace users begin backup;
Tablespace altered.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 1478037 03-APR-16
2 NOT ACTIVE 1478037 03-APR-16
3 NOT ACTIVE 1478037 03-APR-16
4 ACTIVE 1498645 03-APR-16
5 NOT ACTIVE 1478037 03-APR-16
6 NOT ACTIVE 1478037 03-APR-16
6 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2074530/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8520577/viewspace-2074530/