 | |
How to determine if tablespace/datafile is in BACKUP mode
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
How to determine if tablespace/datafile is in BACKUP mode -
06-09-2008
, 09:07 AM
#2
| |||
| |||
|
|
I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin |
it's still in backup mode and this needs to be corrected. As I
understand it Oracle 7, if started with files in backup mode after a
crash or a SHUTDOWN ABORT, will assume media recovery is required.
David Fitzjarrell
#3
| |||
| |||
|
|
I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin |
it's still in backup mode and this needs to be corrected. As I
understand it Oracle 7, if started with files in backup mode after a
crash or a SHUTDOWN ABORT, will assume media recovery is required.
David Fitzjarrell
#4
| |||
| |||
|
|
I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin |
it's still in backup mode and this needs to be corrected. As I
understand it Oracle 7, if started with files in backup mode after a
crash or a SHUTDOWN ABORT, will assume media recovery is required.
David Fitzjarrell
#5
| |||
| |||
|
|
I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin |
it's still in backup mode and this needs to be corrected. As I
understand it Oracle 7, if started with files in backup mode after a
crash or a SHUTDOWN ABORT, will assume media recovery is required.
David Fitzjarrell
#6
| |||
| |||
|
|
I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin |
it's still in backup mode and this needs to be corrected. As I
understand it Oracle 7, if started with files in backup mode after a
crash or a SHUTDOWN ABORT, will assume media recovery is required.
David Fitzjarrell
#7
| |||
| |||
|
|
I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin |
it's still in backup mode and this needs to be corrected. As I
understand it Oracle 7, if started with files in backup mode after a
crash or a SHUTDOWN ABORT, will assume media recovery is required.
David Fitzjarrell
#8
| |||
| |||
|
|
I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." * * * * * * * * * * * * * * * * * * * * * * * * -- Benjamin Franklin |
it's still in backup mode and this needs to be corrected. As I
understand it Oracle 7, if started with files in backup mode after a
crash or a SHUTDOWN ABORT, will assume media recovery is required.
David Fitzjarrell
#9
| |||
| |||
|
|
On Jun 9, 9:07=A0am, Stan Brown <st... (AT) panix (DOT) com> wrote: I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything= is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 -- Benjamin Franklin Query the V$BACKUP view. Should any file# have a status of ACTIVE it's still in backup mode and this needs to be corrected. As I understand it Oracle 7, if started with files in backup mode after a crash or a SHUTDOWN ABORT, will assume media recovery is required. |
server was rebooted. Guess I lucked out on that one. Thanks for the quick
answer.
Quote:
|
David Fitzjarrell -- |
neither liberty nor safety."
-- Benjamin Franklin
#10
| |||
| |||
|
|
On Jun 9, 9:07=A0am, Stan Brown <st... (AT) panix (DOT) com> wrote: I have a 7.3.4.5.0 instance, that does hot backups to another machine via NFS. The NFS server had issues this weekend, and I believe that everything= is back to normal now, but i would like to make certain that none of the instances tablespaces/datafiles were inadvertently left in BACKUP mode. How can I verify this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 -- Benjamin Franklin Query the V$BACKUP view. Should any file# have a status of ACTIVE it's still in backup mode and this needs to be corrected. As I understand it Oracle 7, if started with files in backup mode after a crash or a SHUTDOWN ABORT, will assume media recovery is required. |
server was rebooted. Guess I lucked out on that one. Thanks for the quick
answer.
Quote:
|
David Fitzjarrell -- |
neither liberty nor safety."
-- Benjamin Franklin
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.