Re: RECOVER DATABASE question again.

From: Alexander Chupin <chupin_at_mail.mosbb.com>
Date: Tue, 13 Jul 1999 16:44:32 +0400
Message-ID: <378b3a03.0@ns.mosbb.com>

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.

1. startup mount exclusive
2. 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 - 07:44:32 CDT