玉面飞龙的BLOG

今天建Standby数据库的时候，碰见一个ora-19909错误，提示不能恢复。后来使用Rman 调整控制文件中的Incarnation信息,得以解决。

incarnation有点凤凰盘涅,重生的意思，比较符合给数据库使用resetlogs的境遇。

Oracle9i时候 resetlogs后，之前的备份就都失效了;10g后通过记录在控制文件中incarnation的信息，数据库resetlog打开后，之前备份的备份文件还有可能在将来的恢复中用上。

•When a database goes through multiple incarnations, some backups can become orphaned. Orphaned backups are backups that are created during incarnations of the database that are not ancestors of the current incarnation.

•For example, database incarnation is 5 and SCN is 7000. A DBPITR is done at SCN 7000 to SCN 6666 and then RESETLOGS is performed. Now in current incarnation 6 the backup taken between 6666 and 7000 SCN became orphaned.

•Orphaned backups are usable by RMAN in cases where you wish to restore the database to a point in time not in the current incarnation path.

最近中国的股市有点Incarnation的意思，是个股票就在涨。

最近比较看好电力股, 刺激出口，稳定就业什么的，都要用电啊。而且之前电力股都在阴跌，价格都在低位。下半年中国经济率先恢复，电力股会慢慢回暖。现在绝对是价值投资的首选。

中国平安,中国人寿等大盘指标股也不错，经济复苏，他们就会在大盘的带动下上涨。也强烈推荐。

操作语法如下,

RMAN> shutdown

Oracle instance shut down

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area    4898947072 bytes

Fixed Size                     2035888 bytes
Variable Size               2684358480 bytes
Database Buffers            2147483648 bytes
Redo Buffers                  65069056 bytes

RMAN> list incarnation of database;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
——- ——- ——– —————- — ———- ———-
1       1       DEVDB   693043031        CURRENT 1             01-OCT-02
2       2       DEVDB   693043031        PARENT  3464454166946 18-DEC-07

RMAN> reset database to incarnation 2;

database reset to incarnation 2

RMAN> list incarnation of database;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
——- ——- ——– —————- — ———- ———-
1       1       DEVDB   693043031        PARENT  1             01-OCT-02
2       2       DEVDB   693043031        CURRENT 3464454166946 18-DEC-07

RMAN> quit