RMAN> run {
2> allocate channel ch00 type 'SBT_TAPE';
3> send 'NB_ORA_CLIENT=lh-ora-rs';
4> recover database;
5> release channel ch00;
6> }
allocated channel: ch00
channel ch00: sid=1987 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.6 (2014102721)
sent command to channel: ch00
Starting recover at 03-AUG-15
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/ora_dat/ssaerp/system01.dbf'
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/03/2015 14:06:59
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 105266 lowscn 3956325323 found to rest ore
RMAN-06025: no backup of log thread 1 seq 105265 lowscn 3956321064 found to rest ore
I moved archive log files from production to Development server and try to recover database.
RMAN> run {
2> allocate channel t1 type disk;
3> recover database;
4> release channel t1;
5> }
allocated channel: t1
channel t1: sid=1987 devtype=DISK
Starting recover at 03-AUG-15
starting media recovery
archive log thread 1 sequence 105265 is already on disk as file /ora_dat/ssaerp/ archive1/1_105265_694624922.dbf
archive log thread 1 sequence 105266 is already on disk as file /ora_dat/ssaerp/ archive1/1_105266_694624922.dbf
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/ora_dat/ssaerp/system01.dbf'
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/03/2015 14:13:32
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 105264 lo wscn 3956321028
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 105263 lo wscn 3956315146
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 105262 lo wscn 3956283401
RMAN> run {
2> allocate channel t1 type disk;
3> recover database;
4> release channel t1;
5> }
allocated channel: t1
channel t1: sid=1987 devtype=DISK
Starting recover at 03-AUG-15
starting media recovery
archive log thread 1 sequence 105262 is already on disk as file /ora_dat/ssaerp/archive1/1_105262_694624922.dbf
archive log thread 1 sequence 105263 is already on disk as file /ora_dat/ssaerp/archive1/1_105263_694624922.dbf
archive log thread 1 sequence 105264 is already on disk as file /ora_dat/ssaerp/archive1/1_105264_694624922.dbf
archive log thread 1 sequence 105265 is already on disk as file /ora_dat/ssaerp/archive1/1_105265_694624922.dbf
archive log thread 1 sequence 105266 is already on disk as file /ora_dat/ssaerp/archive1/1_105266_694624922.dbf
archive log filename=/ora_dat/ssaerp/archive1/1_105262_694624922.dbf thread=1 sequence=105262
archive log filename=/ora_dat/ssaerp/archive1/1_105263_694624922.dbf thread=1 sequence=105263
archive log filename=/ora_dat/ssaerp/archive1/1_105264_694624922.dbf thread=1 sequence=105264
archive log filename=/ora_dat/ssaerp/archive1/1_105265_694624922.dbf thread=1 sequence=105265
archive log filename=/ora_dat/ssaerp/archive1/1_105266_694624922.dbf thread=1 sequence=105266
archive log filename=/ora_dat/ssaerp/archive1/1_105267_694624922.dbf thread=1 sequence=105267
archive log filename=/ora_dat/ssaerp/archive1/1_105268_694624922.dbf thread=1 sequence=105268
archive log filename=/ora_dat/ssaerp/archive1/1_105269_694624922.dbf thread=1 sequence=105269
archive log filename=/ora_dat/ssaerp/archive1/1_105270_694624922.dbf thread=1 sequence=105270
archive log filename=/ora_dat/ssaerp/archive1/1_105271_694624922.dbf thread=1 sequence=105271
archive log filename=/ora_dat/ssaerp/archive1/1_105272_694624922.dbf thread=1 sequence=105272
archive log filename=/ora_dat/ssaerp/archive1/1_105273_694624922.dbf thread=1 sequence=105273
archive log filename=/ora_dat/ssaerp/archive1/1_105274_694624922.dbf thread=1 sequence=105274
archive log filename=/ora_dat/ssaerp/archive1/1_105275_694624922.dbf thread=1 sequence=105275
archive log filename=/ora_dat/ssaerp/archive1/1_105276_694624922.dbf thread=1 sequence=105276
archive log filename=/ora_dat/ssaerp/archive1/1_105277_694624922.dbf thread=1 sequence=105277
archive log filename=/ora_dat/ssaerp/archive1/1_105278_694624922.dbf thread=1 sequence=105278
unable to find archive log
archive log thread=1 sequence=105279
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/03/2015 14:25:51
RMAN-06054: media recovery requesting unknown log: thread 1 seq 105279 lowscn 3956590616
RMAN> alter database open resetlogs;
database opened
RMAN>
