To create a new database incarnation record in the recovery
catalog. RMAN considers the new incarnation as the current incarnation of
the database. All subsequent backups and redo log archiving operations performed
by the target database will be associated with the new database incarnation.
Requirements
Execute reset database only at the RMAN prompt.
You must be using a recovery catalog.
You must issue a reset database command before you can use RMAN with a target
database that has been opened with the RESETLOGS option. If you do not, then
RMAN refuses to access the recovery catalog because it cannot distinguish
between a RESETLOGS operation and an accidental restore of an old control
file. The reset database command gives confirmation to RMAN that you issued
a RESETLOGS command.
Keywords and Parameters
to incarnation
primary_key
changes the incarnation that RMAN considers to be current
to an older incarnation. This option is useful in the rare circumstance in
which you want to undo the effects of a RESETLOGS by restoring backups of
a prior incarnation of the database.
Specify the primary key of the DBINC record for the
database incarnation. Obtain the key value using the
list
incarnation of databasecommand. After you issue
the reset database to incarnation command,
issue
restore
and
recover
commands to restore the database files from the prior incarnation and recover
them.
Examples
Resetting a Database
After RESETLOGS
The following example resets a database after performing incomplete
media recovery:
run {
allocate channel dev1 type disk;
set until logseq 1234 thread 1;
restore database skip tablespace readonly;
recover database;
sql "ALTER DATABASE OPEN RESETLOGS";
release channel dev1;
}
reset database;
Resetting an Old
Incarnation
The following command makes an old incarnation of database
PROD1 current again:
# obtain primary key of old incarnation
list incarnation of database prod1;
List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- ------- ------ --- ---------- ----------
1 2 PROD1 1224038686 NO 1 02-JUL-98
1 582 PROD1 1224038686 YES 59727 10-JUL-98
shutdown immediate;
# reset database to old incarnation
reset database to incarnation 2;
# recover it
run {
allocate channel dev1 type disk;
restore controlfile;
startup mount;
restore database;
recover database;
sql "ALTER DATABASE OPEN RESETLOGS";
release channel dev1;
}
Please can someone explain the consequences of "reset database" in rman??
Does this mean all the previous backups are lost??Is there a way around
??
Any help/advice would be greatly appreciated...
Rgds
Fawzia
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
--
/regards
Peter Gram
Mobil : +45 2527 7107
Fax : +45 4466 8856
Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk
/*
The process of preparing programs for a digital computer is especially
attractive, not only because it can be economically and scientifically
rewarding, but also because it can be an aesthetic experience much like
composing poetry or music
Donald Knuth
*/
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.
Oracle Documentation Library, Release 8.1.7
Please select a product from the list of documentation available on this system:
We are always trying to improve the content and delivery of our online documentation, so we invite you to tell us what you think. Each document in this distribution includes a reader's comment form, with an appropriate e-mail address for submitting comments on that document.
If you have general comments about the documentation library or this CD-ROM, please send them to doc_talk@us.oracle.com. Please note that this address is only for documentation feedback. For assistance with installation or software problems, please contact Oracle Support Services using the URLs listed above.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.
Oracle8i Recovery Manager User's Guide and Reference -- Contents
Oracle8i Recovery Manager User's Guide and Reference Release 2 (8.1.6) Part Number A76990-01
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.
Oracle8i Recovery Manager User's Guide and Reference -- Index
Oracle8i Recovery Manager User's Guide and Reference Release 2 (8.1.6) Part Number A76990-01
