Database Backup and Recovery (MOSC)

MOSC Banner

RMAN> list incarnation, wrong result

edited Nov 24, 2015 3:18AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

Dear commumity,

We have Oracle 11g database and in every two weeks we restore database to  test environment.

It was restoring smoothly before yesterday.

When I restore controlfile, by the following way:

rman target /

run{

  set DBID 3732963157;

  allocate channel t1 type 'SBT_TAPE' parms='ENV=(NB_ORA_CLIENT=tcidb.lb.ge,NB_ORA_SERV=BKP-MASTER)';

  restore controlfile from autobackup;

  release channel t1;

  alter database mount;

}

RMAN> list incarnation;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1      1      LBTCI    3732963157      CURRENT 1          21-MAY-12

--It is correct

But when I run the script which we use for automatic restoring,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center