Re: How restore hotline backup ?

In article <6hs7dl$p00$1_at_news.park.ru>,   "Bors" <bors_at_park.ru> wrote:
>
> My greeting to all.
> If ORACLE diggers answer me.
>
> I have a hotline( on working database ) backup, this backup was done using
> following commands:
> ALTER TABLESPACE ... READ ONLY;
> ...
> ALTER TABLESPACE ... READ ONLY;
>
> cp datafile1 /backup/datafile
> ...
> cp datafileN /backup/datafileN
>
> And only tablespace that not turned to read only is SYSTEM. In process of
> copying no one write or read data. And no redo information was done( my
> database was running in NOARCHIVELOG mode ).
> After this i have try to restore database using following:
> CREATE CONTROLFILE REUSE SET DATABASE "...." RESETLOGS NOARCHIVELOG
> ....
> DATAFILE
> '/backup/system01.dbf',
> ....
> '/backup/data10.dbf';
>
> Created OK, but when i execute RECOVER DATABASE USING BACKUP CONTROLFILE
> Recovering process will fail, it asks for some redo files.
>
> And my questing. Is possibly open database to read only( for reading data )
> ignore some inconsistence in system datafiles( no data changes from start to
> finish backup process ). I assume that must be something............
>
> Thank for advance.
>
> PS: Please reply to email too
>
> Bors/
>
>

If Your database is in NOARCHIVELOG mode there is noway you can recover the database to the point in time. The only way to restore the database is to go back to
the latest coldbackup. i.e. If you overlay all the files of the coldbackup on the existing files
all your database changes from the last coldbackup are lost.

I think you need a major revamp of the backup strategy for the database.

1. take a couse in the "Oracle backup and recovery". This would educate you to understand the complex backup strategy of the Oracle database.
2. You do not need to put the tablespaces in readonly mode before you takeup the backup. Just shutdown the database when no users are using it and then take a coldbackup.
3. If you can't afford to shutdown the database, then you need to run the database in ARCHIVELOG mode. Once you alter the database to ARCHIVELOG mode, you need to backup the archive log files and tablespaces.

 Tablespaces are backedup using

ALTER TABLESPACE tablespacename BEGIN BACKUP;

   use OS commands (CPIO or TAR)to backup the datafile of the TABLESPACE.

ALTER TABLESPACE tablespacename END BACKUP;

Archive LOG files are backuedup using OS commands like CPIO or TAR.

4) As I said you can not use the command "RECOVER DATABASE USING BACKUP CONTROLFILE"
    to recover the database. This command can only be used if your database in ARCHIVELOG mode and you

    have the backup copies of these Archive logs to roll forward the database.

    I think, only option you are left with is to go back to the latest copy of the backup and overlay those files on the exisiting ones to recover the database. Your changes from the last backup to present are lost.

If you have any questions, Please let me know @ ajayreddy_at_msn.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 27 1998 - 13:46:59 CDT