| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: reset database
sorry I usually do- I cant access the web at the mo thats all- but thanks
for this..
-----Original Message-----
Sent: 16 May 2002 10:05
To: Malik, Fawzia
Cc: ORACLE-L_at_fatcity.com
pls. next time read the manual. if the manual gives problem then describe the problem !
Oracle8i Recovery Manager User's Guide and Reference
Release 2 (8.1.6)
Part Number A76990-01
Library
Product
Contents
Index
Go to previous page Go to beginning of chapter Go to next page
Recovery Manager Command Syntax, 36 of 50
reset
BM_8417
Syntax
BM_6172 BM_23645
Purpose
BM_23757To 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.
BM_23780
Requirements
BM_23659
Keywords and Parameters
BM_23738
BM_23662
to incarnation primary_key
BM_23869changes 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. BM_23881
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.
BM_23739
Examples
BM_23740
Resetting a Database After RESETLOGS
BM_23741The following example resets a database after performing incomplete media recovery:
BM_23928run {
BM_23929 allocate channel dev1 type disk;
BM_45070 set until logseq 1234 thread 1;
BM_23931 restore database skip tablespace readonly;
BM_23937 recover database;
BM_23985 sql "ALTER DATABASE OPEN RESETLOGS";
BM_23991 release channel dev1;
BM_23943}
BM_24021reset database;
BM_24019
BM_23994
Resetting an Old Incarnation
BM_23995The following command makes an old incarnation of database PROD1 current again:
BM_23996# obtain primary key of old incarnation
BM_24039list incarnation of database prod1;
BM_60396
BM_38807List of Database Incarnations
BM_38808DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
BM_38809------- ------- ------- ------ --- ----------
BM_388101 2 PROD1 1224038686 NO 1 02-JUL-98 BM_388051 582 PROD1 1224038686 YES 59727 10-JUL-98 BM_38818
BM_59949shutdown immediate;
BM_59948# reset database to old incarnation
BM_24040reset database to incarnation 2;
BM_24041# recover it
BM_24024run {
BM_23997 allocate channel dev1 type disk;
BM_59950 restore controlfile;
BM_59951 startup mount;
BM_23998 restore database;
BM_23999 recover database;
BM_49481 sql "ALTER DATABASE OPEN RESETLOGS";
BM_24000 release channel dev1;
BM_23992}
BM_31283
Related Topics
BM_31290"list"
BM_31297"restore"
BM_31304"recover"
Malik, Fawzia wrote:
Hi,
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
-- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk <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 */Received on Thu May 16 2002 - 05:14:37 CDTThe 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.
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.
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.
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.
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. ------_=_NextPart_000_01C1FCB9.0AAE7800-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: Fawzia.Malik_at_bskyb.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |