t;
Sent by: [EMAIL PROTECTED]
12/19/2002 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 databa
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: [
CLE-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.
The database is being backed up using RMAN: I.e.
set ORACLE_SID=DB2
rman target
CLE-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.
The database is being backed up using RMAN: I.e.
set ORACLE_SID=DB2
rman target / catalog rman
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 full_b
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
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
How can I restore a database from a specific RMAN backup set? We have a
database running in no archive log mode that is backed up with RMAN.
There is an RMAN catalog DB also.
If I look at the backup summary I see:
List of Database Incarnations
DB Key Inc Key DB Name DB IDCUR Reset S