Home » RDBMS Server » Backup & Recovery » Restore database from backup
Restore database from backup [message #62584] Sat, 31 July 2004 05:07 Go to next message
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 Go to previous messageGo to next message
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
Re: Restore database from backup [message #62606 is a reply to message #62584] Mon, 02 August 2004 22:22 Go to previous message
Thomas
Messages: 67
Registered: September 1999
Member
The backup of open files is not useful at all. You have to take "hot" backup. Simple scripts are provided Here - Hot Backup Oracle & Windows

Hope that helps,

clio_usa - OCP DBA 8/8i/9i

Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups
Previous Topic: backup controlfile
Next Topic: What happen when Tablespace begin in backup mode.
Goto Forum:
  


Current Time: Thu May 23 10:21:07 CDT 2024