How to determine if tablespace/datafile is in BACKUP mode

#41

In <fa73172d-8b51-488b-ba5b-03771659c947 (AT) f63g2000hsf (DOT) googlegroups.com> epokopac (AT) excite (DOT) com writes:

Quote:

" 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."

Prior to 7.2, media recovery would have been necessary. Effective with
7.2, a simple

"alter database datafile "full path file name" end backup" ;

issued after the "media recovery needed messages" will take the file
out of hot backup mode and allow you to then issue an "open".

Thanks, this is useful information.

Quote:

Eugene Pokopac (Oracle DBA - Tucker GA)

I used to live right next to there, in Clarkston.

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin

#42

In <fa73172d-8b51-488b-ba5b-03771659c947 (AT) f63g2000hsf (DOT) googlegroups.com> epokopac (AT) excite (DOT) com writes:

Quote:

" 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."

Prior to 7.2, media recovery would have been necessary. Effective with
7.2, a simple

"alter database datafile "full path file name" end backup" ;

issued after the "media recovery needed messages" will take the file
out of hot backup mode and allow you to then issue an "open".

Thanks, this is useful information.

Quote:

Eugene Pokopac (Oracle DBA - Tucker GA)

I used to live right next to there, in Clarkston.

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin

#43

In <fa73172d-8b51-488b-ba5b-03771659c947 (AT) f63g2000hsf (DOT) googlegroups.com> epokopac (AT) excite (DOT) com writes:

Quote:

" 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."

Prior to 7.2, media recovery would have been necessary. Effective with
7.2, a simple

"alter database datafile "full path file name" end backup" ;

issued after the "media recovery needed messages" will take the file
out of hot backup mode and allow you to then issue an "open".

Thanks, this is useful information.

Quote:

Eugene Pokopac (Oracle DBA - Tucker GA)

I used to live right next to there, in Clarkston.

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to determine if tablespace/datafile is in BACKUP mode

comp.databases.oracle.server comp.databases.oracle.server

Re: How to determine if tablespace/datafile is in BACKUP mode - 06-12-2008 , 02:18 PM

Re: How to determine if tablespace/datafile is in BACKUP mode - 06-12-2008 , 02:18 PM

Re: How to determine if tablespace/datafile is in BACKUP mode - 06-12-2008 , 02:18 PM