how I read SCN directly from data file?

From: <bikle_at_my-deja.com>
Date: Fri, 22 Oct 1999 01:09:44 GMT
Message-ID: <7uodgm$v8h$1@nnrp1.deja.com>

Hi,

how I read SCN directly from data file?

Often I need to build a test dbs from a hot backup of prod db files

Ideal recipe:

1. get the files
2. restore the files to a test area
3. build & run a create control file script
4. RECOVER UNTIL CHANGE <the SCN I need> USING BACKUP CONTROLFILE;
5. ALTER DATABASE OPEN RESETLOGS;

What I usually do:

1. get the files
2. restore the files to a test area
3. build & run a create control file script
4. RECOVER UNTIL CANCEL USING BACKUP CONTROLFILE;
5. ALTER DATABASE OPEN RESETLOGS;

The above recipe usually works ok, but sometimes I have troubles finding a consistent state between arch redo logs

(oracle tells me this with an error:
online backup of file x needs more recovery to be consistent)

thanks,

-Dan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 20:09:44 CDT