10g DBA 1Z0-042 Database
Date:2011-3-1 17:30 Author: hotexam Click: 39
Today saw the flash back to the database, Oracle 10g features, just 1Z0-042 certification will use this. The book says to delete a table space can not be completed and used resetlogs recovery, in fact, this means that if you change the structure of the database, it can not flash back, flash back to the logic can only be modified, but I did an experiment.
I deleted a table space 1Z0-042, and then flash back to the database and found that not open the database, open the database file when prompted datafile 7 offline, the file will be lost if the resetlogs, so I use RMAN to restore, that is, To revert to a previous time, with the UNTIL TIME this syntax, but in the RESTORE to go wrong, and told not restore the control file, at that point in time did not have a backup control file, but the data files have all been restored, in fact, control files recorded SCN SCN is inconsistent with the data file, the database can not be opened, which is the control file data files than the new, I think about 10g DBA Certification of the two options, one is to rebuild the control file, resetlogs options, one is again Wang Qianmian recovery, restore a control file before that, I RMAN’s controlfile autoback is on, control files are backed up. I took the second approach.
The first is to rebuild the control file with resetlogs option, the new Oracle Certification SCN control file is read from the data file, and then recover database until cancel.
The second approach is a cross-resetlogs point in time recovery, because yesterday the methods provided by Testinside experiment has used resetlogs opened database, so I restored the control file, also RESET DATABASE to incarnation n, the counterpart of the conversion, Otherwise, RMAN will be reported
RMAN-20207 UNTIL TIME is before RESETLOGSS time
Cause: UNTIL TIME cannot be less than the database creation time or RESETLOGSS time.
Action: Check the UNTIL TIME. If the database needs to be restored to an old incarnation, use the
RESET DATABASE TO INCARNATION command.
Finally, to recover database, the data is successfully resumed.