ora-19909 and Incarnations
今天建Standby数据库的时候，碰见一个ora-19909错误，提示不能恢复。后来使用Rman 调整控制文件中的Incarnation信息,得以解决。
incarnation有点凤凰盘涅,重生的意思，比较符合给数据库使用resetlogs的境遇。
•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 mountedTotal System Global Area 4898947072 bytes
Fixed Size 2035888 bytes
Variable Size 2684358480 bytes
Database Buffers 2147483648 bytes
Redo Buffers 65069056 bytesRMAN> 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-07RMAN> 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-07RMAN> quit