Re: RECOVER DATABASE question again.

The only two backups that are valid that are taken when the Database is up and running are HOT backups and Export Backups(in Consistent Mode) .

What do U mean by Saving datafiles as U mentioned in Step 5.

What happens when U put a Tablespace in Backup mode is that the associated Datafile headers are frozen to reflect the CheckPoint SCN .But the Updates/Inserts to the Segments are not blocked. They are stored in the Redolog files which may be used to Recover the Database in case of a Crash.

Since the Datafiles are Consistent now, an OS Level Backup is Valid and can be used for subsequent Recoveries.

When you End the Tablespace Backup mode, the Datafile & Control file headers are updated with the present SCN and becomes insync with the rest of the Database.

In case of a Crash when the hotbackup is going on,
>Alter database datafile ' ......' end backup;
will make it Consistent without applying any Redolog files.

So U dont need to worry about putting a 25GB Tablespace in Hotbackup mode as feared by U'r predecessor.

In U'r Case, Since the files are from a 'Fuzzy' backup , Oracle complains that even the SYSTEM file has to be recovered.

Try Recovering from a Cold backup or a Valid Hotbackup or a Consistent Export Backup...

-Thiru

Alexander Chupin wrote:

> Hi,
>
> Thanx to all, who answered. As I assumed this
> technology of backup is not unerstandable and bad.
>
> Denny Koovakattu wrote in message <7mdmlk$voa$1_at_nnrp1.deja.com>...
>
> >Though not supported, if there was no activity on the production
> >database while you were taking the backup, you should be able to
> >recover. ( I wouldn't bet on it. )
>
> Now I made some experiment with a little database.
>
> 1. startup database
> 2. create table.
> 3. insert into table 6000 rows.
> 4. disconnect from database.
> 5. save database files, redolog files, ctrlfile.
> 6. connect to database
> 7. update 6000 rows.
> 8. disconnect from database
> 9. connect internal
> 10. shutdown abort
> 11. restore database file, redolo files, ctrlfile
>
> Now I'd like roll forward using archive log files.
>
> 12. startup mount exclusive
> 11. alter database recover database until cancel using backup controlfile;
> received:
> *
> ORA-00279: change 53109 generated at 07/13/99 15:48:09 needed for thread 1
> ORA-00289: suggestion : /dsk1/arcs/AR0000000138.0001
> ORA-00280: change 53109 for thread 1 is in sequence #138
>
> When I tried issue: alter database recover cancel;
> I'm receiving:
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> below
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/dev/vx/rdsk/rLNX.system'
>
> After this database already coldn't be started.
>
> >startup
> ORACLE instance shut down.
> ORACLE instance started.
> Total System Global Area 4754704 bytes
> Fixed Size 48400 bytes
> Variable Size 4222976 bytes
> Database Buffers 409600 bytes
> Redo Buffers 73728 bytes
> Database mounted.
> ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
>
> >alter database open resetlogs
> *
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/dev/vx/rdsk/rLNX.system'
>
> --------------------------------------------
> The end of outrage.
>
> If I don't tired you. I wold like to receive any
> advices to change any steps in this
> experiment for obtaining more
> successul result.
>
> Thanx in advance,
> WBR, Alexander.
Received on Tue Jul 13 1999 - 10:46:48 CDT