1

For example, I have a level 0 and level 1 RMAN backupset files like
inr00_0413_*
inr01_0413_1_*
Is it necessary to do this when recover from RMAN level 1 backup:

restore controlfile from inr01_0413_1_ctl_file_9jr2v0te_1_1_20160413;

Or I just:

catalog start with '/u02/rmanbackup/';  
recover database;

If not restore controlfile, after resotre and recover will get error:

ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA1/rac/datafile/system1.dbf'

Can't do

SQL> recover database using backup controlfile until cancel  

Or

RMAN> sql 'alter database open read only';

Backupset files:

[oracle@dbsrv01] ll /u02/rmanbackup/
Apr 13 20:53 block_change_tracking.ctf
Apr 13 19:44 inr00_0413_arc_8pr2uqq2_1_1_RAC_20160413_42265
Apr 13 19:44 inr00_0413_arc_8qr2uqq2_1_1_RAC_20160413_42266
Apr 13 19:44 inr00_0413_ctl_file_8rr2uqqa_1_1_20160413
Apr 13 19:44 inr00_0413_dbf_8er2uqcc_1_1_RAC_20160413_42254
Apr 13 19:46 inr00_0413_dbf_8fr2uqcc_1_1_RAC_20160413_42255
Apr 13 19:48 inr00_0413_dbf_8gr2uqcc_1_1_RAC_20160413_42256
Apr 13 19:50 inr00_0413_dbf_8hr2uqcc_1_1_RAC_20160413_42257
Apr 13 19:51 inr00_0413_dbf_8ir2uqcc_1_1_RAC_20160413_42258
Apr 13 19:52 inr00_0413_dbf_8jr2uqcc_1_1_RAC_20160413_42259
Apr 13 19:52 inr00_0413_dbf_8kr2uqcc_1_1_RAC_20160413_42260
Apr 13 19:52 inr00_0413_dbf_8lr2uqcc_1_1_RAC_20160413_42261
Apr 13 19:52 inr00_0413_dbf_8mr2uqcc_1_1_RAC_20160413_42262
Apr 13 19:52 inr00_0413_dbf_8nr2uqcc_1_1_RAC_20160413_42263
Apr 13 19:52 inr00_0413_dbf_8or2uqcc_1_1_RAC_20160413_42264
Apr 13 19:52 inr00_0413_spfile_8sr2uqqc_1_1_20160413
Apr 13 20:50 inr01_0413_1_arc_9gr2v0t5_1_1_RAC_20160413_42288
Apr 13 20:50 inr01_0413_1_arc_9hr2v0t5_1_1_RAC_20160413_42289
Apr 13 20:50 inr01_0413_1_arc_9ir2v0tc_1_1_RAC_20160413_42290
Apr 13 20:50 inr01_0413_1_ctl_file_9jr2v0te_1_1_20160413
Apr 13 20:50 inr01_0413_1_dbf_95r2v0sv_1_1_RAC_20160413_42277
Apr 13 20:50 inr01_0413_1_dbf_96r2v0sv_1_1_RAC_20160413_42278
Apr 13 20:50 inr01_0413_1_dbf_97r2v0t0_1_1_RAC_20160413_42279
Apr 13 20:50 inr01_0413_1_dbf_98r2v0t0_1_1_RAC_20160413_42280
Apr 13 20:50 inr01_0413_1_dbf_99r2v0t0_1_1_RAC_20160413_42281
Apr 13 20:50 inr01_0413_1_dbf_9ar2v0t0_1_1_RAC_20160413_42282
Apr 13 20:50 inr01_0413_1_dbf_9br2v0t0_1_1_RAC_20160413_42283
Apr 13 20:50 inr01_0413_1_dbf_9cr2v0t0_1_1_RAC_20160413_42284
Apr 13 20:50 inr01_0413_1_dbf_9dr2v0t0_1_1_RAC_20160413_42285
Apr 13 20:50 inr01_0413_1_dbf_9er2v0t0_1_1_RAC_20160413_42286
Apr 13 21:06 inr01_0413_1_dbf_9fr2v0t0_1_1_RAC_20160413_42287
Apr 13 21:06 inr01_0413_1_spfile_9kr2v0tg_1_1_20160413
  • 1
    Normally it is not needed. Usually it is the other way around, one would receive the above error after restoring the controlfile from an older backup while the datafiles already exist and they are ahead of the controlfile. What do you want to achieve? Did you already have a working database in +DATA1? Do you want to restore and recover that database to an earlier state? What steps led to this error? – Balazs Papp Apr 15 '16 at 20:57
  • I have restored the db from server A to server B with RMAN Level 0 backup, all are on ASM; so I want copy a RMAN Level 1 backup to server B and restore recover it. – Jason Smartree Apr 20 '16 at 10:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.