Home » RDBMS Server » Server Utilities » Backup while Databse wasn't shutdown
Backup while Databse wasn't shutdown [message #368321] Fri, 10 November 2000 15:31 Go to next message
Messages: 1
Registered: November 2000
Junior Member
A friend tried to do a backup of his Ora Database by copying the folders on tape while the Database was open(he didn't know no better). He played the folders back onto the system and "bingo". Is there any way to restore the Database?
Immediate help is needed. Thanks in advance.
Re: Backup while Databse wasn't shutdown [message #368326 is a reply to message #368321] Mon, 13 November 2000 08:23 Go to previous message
Messages: 205
Registered: November 1999
Senior Member

He can 'startup mount' the database,
and issue 'recover database until cancel using backup control file;'
(provided he restored the contol file also from the tape)

He may lose some data which are inserted or modified after the backup and before the restore.

Previous Topic: Urgent - Exporting Data to Flat file
Next Topic: sqlloader
Goto Forum:

Current Time: Tue Dec 07 02:49:10 CST 2021