| Restore database from backup [message #62584] |
Sat, 31 July 2004 05:07  |
Tom-Erik
Messages: 1
Registered: July 2004
|
Junior Member |
|
|
Hi!
We might need to restore our <NOBR><A class=iAs oncontextmenu="return false;" onmousemove=kwM(64377); onmouseover=kwE(event,64377); style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" onclick="return kwC();" onmouseout=kwL(event); href="http://www.experts-exchange.com/Databases/Oracle/Q_21077897.html#" target=_blank>database[/url]</NOBR> from <NOBR><A class=iAs oncontextmenu="return false;" onmousemove=kwM(391124); onmouseover=kwE(event,391124); style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" onclick="return kwC();" onmouseout=kwL(event); href="http://www.experts-exchange.com/Databases/Oracle/Q_21077897.html#" target=_blank>backup[/url]</NOBR>. What I have discovered is that the backup has been made while the database has been open/running. (it was just filecopying of the whole <NOBR><A class=iAs oncontextmenu="return false;" onmousemove=kwM(435225); onmouseover=kwE(event,435225); style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" onclick="return kwC();" onmouseout=kwL(event); href="http://www.experts-exchange.com/Databases/Oracle/Q_21077897.html#" target=_blank>server[/url]</NOBR>).
Does anyone have any idea or experience of the chances that this backup will work properly? (it is a 9iAS infrasctructure database)
Thanks in advance!
Best regards,
Tom-Erik
|
|
|
|
| Re: Restore database from backup [message #62589 is a reply to message #62584] |
Mon, 02 August 2004 01:17  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
NO, you cant use that backup to recover your db. If your db is up then you have to put each tablespace in backup mode before starting backup of that tablespace. You can do this by following commands :
Alter tablespace ts_name begin backup;
{copy all the file related to that tablespace}
Alter tablespace ts_name end backup;
And if you are taking a simple file copy backup then ur db must be SHUTDOWN.
Best of Luck
Daljit Singh
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
