Oracle OCP 1Z0 053 Q558(V$BACKUP)
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q600(RMAN BACKUP)Oracle
- Oracle OCP 1Z0 053 Q703(Rman Backup)Oracle
- Oracle OCP 1Z0 053 Q342(RMAN BACKUP DURATION)Oracle
- Oracle OCP 1Z0 053 Q544(BACKUP NOARCHIVELOG)OracleHive
- Oracle OCP 1Z0 053 Q554(Backup Controlfile)Oracle
- Oracle OCP 1Z0 053 Q559(Alter Database Begin Backup)OracleDatabase
- Oracle OCP 1Z0 053 Q505(RMAN DATAFILE BACKUP COPIES)Oracle
- Oracle OCP 1Z0 053 Q338(RMAN Expired Backup)Oracle
- Oracle OCP 1Z0 053 Q688(RMAN Backup Compression)Oracle
- Oracle OCP 1Z0 053 Q347( report need backup)Oracle
- Oracle OCP 1Z0 053 Q344(V$SESSION)OracleSession
- Oracle OCP 1Z0 053 Q587(Backup as compressed backupset)Oracle
- Oracle OCP 1Z0 053 Q613(automatic management of backup and recovery)Oracle
- Oracle OCP 1Z0 053 Q608(User-managed Backup)Oracle
- Oracle OCP 1Z0 053 Q583(V$LOG&V$LOGFILE)Oracle
- Oracle OCP 1Z0 053 Q175(noarchivelog&alter tablespace backup mode)OracleHive
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle OCP 1Z0 053 Q462(V$NLS_VALID_VALUES)Oracle
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle