As long as you haven't opened the database with resetlogs between the time
of the backup you want and the present you can just restore it and recover,
using backup controlfile, until cancel.
If you have opened it with resetlogs, you will have to change the
incarnation of the database, Consult the
Paul - Can you specify what you mean by no archive log mode and backed up
with RMAN? Was the database open?
Which Oracle version?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 19, 2002 9:40 AM
To: Multiple recipients of
Database is 9.0.1.4 running on Win2K.
The database called DB2 is not running in archivelog mode.
The database is being backed up using RMAN: I.e.
set ORACLE_SID=DB2
rman target / catalog rman@otherdb
shutdown immediate;
startup mount;
backup database format=f:\oracle_backup\%d\%d_%U tag
:RE: Restoring DB from specific RMAN backup set.
Database is 9.0.1.4 running on Win2K.
The database called DB2 is not running in archivelog mode.
The database is being backed up using RMAN: I.e.
set ORACLE_SID=DB2
rman target / catalog rman@otherdb
shutdown immediate;
startup mount;
backup
:
Subject:RE: Restoring DB from specific RMAN backup set.
Database is 9.0.1.4 running on Win2K.
The database called DB2 is not running in archivelog mode.
The database is being backed up using RMAN: I.e.
set ORACLE_SID=DB2
rman target / catalog rman@otherdb
shutdown immediate
Title: RE: Restoring DB from specific RMAN backup set.
Jared,
LOL. Sounds like Abbot and Costello doing the DBA version of 'Who's on First'.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED
10:17 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Restoring DB from specific RMAN backup set.
Database is 9.0.1.4 running on Win2K.
The database called DB2 is not running in archivelog mode