| how to find tablespaces are online? [message #63386] |
Thu, 30 September 2004 18:41  |
Iyappan
Messages: 12
Registered: December 2003
|
Junior Member |
|
|
I issue a alter tablespace xxx begin backup and i forget to end backup.
how to find the tablespaces are in backup mode or not in backup mode?
thanks
iyappan
|
|
|
|
| Re: how to find tablespaces are online? [message #63387 is a reply to message #63386] |
Thu, 30 September 2004 19:28  |
easywebtech
Messages: 20
Registered: August 2004
|
Junior Member |
|
|
select *
from V$BACKUP
Determining Datafile Backup Status To view the backup status of a datafile, you can use the data dictionary table V$BACKUP. This table lists all online files and gives their backup status. It is most useful when the database is open. It is also useful immediately after a crash, because it shows the backup status of the files at the time of the crash. You can use this information to determine whether you have left tablespaces in backup mode.
webmaster
www.easywebtech.com
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
