saya ambil dari "Chapter 10 of Oracle9i Recover Manager User's Guide"
tapi saya belum pernah mencoba langkah berikut, nanti kalo sudah berhasil
bagi2 tips-nya yach
selamat mencoba dan semoga sukses
=========================
Recovering a Backup Made Before a RESETLOGS: Example
Assume the following situation:
a.. You run RMAN with a recovery catalog.
b.. You made a backup of trgt on January 2, 2001.
c.. You performed incomplete recovery on this database and opened it with
the RESETLOGS option on January 10, 2001. A new database incarnation was
created.
On January 25, you discover that you need crucial data that was dropped from
the database at 8:00 a.m. on January 8, 2001. You decide to reset trgt to
the prior incarnation, restore the January 2 backup, and recover to 7:55
a.m. on January 8.
--------------------------------------------------------------------------
Note:
It is not possible to restore one datafile of a previous incarnation
while the current database is in a different incarnation--you must restore
the whole database.
--------------------------------------------------------------------------
To recover the database by means of a backup from the old incarnation:
1.. You obtain the primary key of the previous incarnation by executing a
LIST command:
# obtain primary key of old incarnation
LIST INCARNATION OF DATABASE trgt;
List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- ------- ------ --- ---------- ----------
1 2 TRGT 1224038686 NO 1 02-JAN-01
1 582 TRGT 1224038686 YES 59727 10-JAN-01
2.. Make sure the database is started but not mounted:
SHUTDOWN ABORT
STARTUP NOMOUNT
3.. Reset the incarnation to the primary key that you just obtained:
# reset database to old incarnation
RESET DATABASE TO INCARNATION 2;
4.. Recover the database, performing the following operations in the RUN
command:
a.. Set the end time for recovery to the time just before the loss of
the data.
b.. If automatic channels are not configured, then manually allocate one
or more channels.
c.. Restore the control file and mount it.
d.. Restore and recover the database.
For example, run the following commands:
RUN
{
SET UNTIL TIME 'Jan 8 2001 07:55:00'; # set time to just before data was
lost
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT; # mount database after restoring control file
RESTORE DATABASE;
RECOVER DATABASE;
}
5.. If recovery is successful, then reset the online redo logs:
ALTER DATABASE OPEN RESETLOGS; # this command automatically resets the
database
# so that this incarnation is the new
incarnation
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.port5.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
