Re: Getting log number for recovery

From: AJG <noemail_at_noemail.noemail>
Date: Thu, 20 May 1999 12:42:12 -0700
Message-ID: <7i1oj6$lrv$1@potlatch.tc.fluke.com>

Perhaps I forgot to mention that I'm recovering with a created set of control files, via the CREATE CONTROLFILE command.

Anyway, ARCHIVE LOG LIST and V$RECOVERY_STATUS ideas are not showing anything:

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/oracle/admin/ttmp/arch/arch_stmp_
Oldest online log sequence     0
Current log sequence           0
SVRMGR> select * from v$recovery_status;
RECOVERY_ THREAD     SEQUENCE_N SCN_NEEDED       TIME_NEED PREVIOUS_LOG_NAME

PREVIOUS_LOG_ REASON

--------- ---------- ---------- ---------------- --------- -----------------
--------------------------------------------------------------- ------------

- -------------
0 rows selected.

Any other ideas, let me know.

Thanks!

Alan.

Kenny Gump wrote in message <374436cd.0_at_news.mountain.net>...
>Check V$RECOVERY_STATUS
>
>Kenny Gump
>
>AJG wrote in message <7hvn20$5vi$1_at_potlatch.tc.fluke.com>...
>>Hello,
>>
>>I have the following situation: A database, fully restored from a hot
>>backup, and I have not started the recovery yet.
>>
>>I want to know what log sequence number it's going to ask for when I start
>>the recovery.
>>
>>How do I do this besides running the recover command?
>>
>>I've been looking around the v$ tables, but have come up with nothing.
>>
>>Thanks!
>>
>>Alan.
>>
>>
>>
>>
>>
>
>
Received on Thu May 20 1999 - 14:42:12 CDT