View to determine backup status of tablespace
> QUESTION POSED on: 12 February 2007
Is there any view/table within the Oracle database from which you can determine the backup status of a tablespace, i.e., is it in or out of backup mode?
> EXPERT RESPONSE
The STATUS column of V$BACKUP will show you if the datafile is ACTIVE (backup in progress). Join this view to DBA_DATA_FILES to see the affected tablespace.
'오라클' 카테고리의 다른 글
| Recover database using backup controlfile until cancel (0) | 2007.04.13 |
|---|---|
| Can't connect to Oracle after running alter statement (0) | 2007.02.16 |
| System doesn't respond to forced log switch (0) | 2007.02.14 |
| Sequential log of executed SQL statements (0) | 2007.02.14 |
| Buffer busy waits on primary key index (0) | 2007.02.14 |