Oracle DBA: Oracle Database restoration to new Server using RMAN backup sets

Steps

1. Install same version oracle software in the target environment(new Server).
2. Copy backupsets to the target environment(new server)
3. Prepare same directory structure as earlier it was.
4. Recreate tnsname, listener, pfile.
5. Create pfile for minimum parameter like db_name, controlfiles and undo.
6. Startup nomount using pfile (pfile which is created with minimum parameters)
7. Connect to RMAN
8. Restore spfile from backup sets.
9. Shutdown database
10. Startup database in nomount mode (automatically database will start with spfile because spfile restored)
11. Restore controlfile from backup sets
12. Catalog start with backup location( location where backup sets are copied)
13. Restore database
14. Recover database
15. Open database with resetlogs

Command summary

sqlplus / as sysdba
startup nomount pfile='/opt/oracle/pfile_temp.ora';
rman target /
restore spfile from '/u03/ORCL/ORCL_17012_1_1_inc';
restore controlfile from '/u03/ORCL/ORCL_17012_1_1_inc';
alter database mount;
report schema;
catalog start with '/u03/ORCL';
restore database preview;
list backup of archivelog all;
restore database until sequence 15480;
recover database until sequence 15480;
alter database open resetlogs;

cat /opt/oracle/pfile_temp.ora

db_name=orcl

control_files=('/oracle/oradata/orcl/orcl/control01.ctl',

'/oracle/oradata/orcl/orcl/control02.ctl',

'/oracle/oradata/orcl/orcl/control03.ctl')

undo_management=AUTO

sqlplus / as sysdba

startup nomount pfile='/opt/oracle/pfile_temp.ora';

[oracle@rac02 dbs]$ rman target /

connected to target database: ORCL (not mounted)

RMAN> restore spfile from '/u03/ORCL/ORCL_17012_1_1_inc';

Starting restore at 28-FEB-20

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=36 devtype=DISK

channel ORA_DISK_1: autobackup found: /u03/ORCL/ORCL_17012_1_1_inc

channel ORA_DISK_1: SPFILE restore from autobackup complete

Finished restore at 28-FEB-20

RMAN> exit

RMAN> restore controlfile from '/u03/ORCL/ORCL_17012_1_1_inc';

Starting restore at 27-FEB-20

using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

output filename=/oracle/oradata/ORCL/ORCL/control01.ctl

output filename=/oracle/oradata/ORCL/ORCL/control02.ctl

output filename=/oracle/oradata/ORCL/ORCL/control03.ctl

Finished restore at 27-FEB-20

RMAN>

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN> report schema;

Starting implicit crosscheck backup at 27-FEB-20

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=158 devtype=DISK

Crosschecked 13 objects

Finished implicit crosscheck backup at 27-FEB-20

Starting implicit crosscheck copy at 27-FEB-20

using channel ORA_DISK_1

Finished implicit crosscheck copy at 27-FEB-20

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_29_h0pj17ty_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_30_h0pj1chf_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_28_h0pj17tw_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_31_h0pj25xx_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_32_h0pj2q9r_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_36_h5h5nvdl_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_35_h5h5nlqz_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_39_h5h5oo5h_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_34_h5h5nc94_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_37_h5h5o2gy_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_33_h5h5n3g3_.arc

File Name: /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_38_h5h5obl5_.arc

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA

Report of database schema

List of Permanent Datafiles

===========================

File Size(MB) Tablespace RB segs Datafile Name

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

1 0 SYSTEM *** /oracle/oradata/ORCL/system01.dbf

2 0 UNDOTBS1 *** /oracle/oradata/ORCL/undotbs01.dbf

3 0 SYSAUX *** /oracle/oradata/ORCL/sysaux01.dbf

4 0 ORCL_DATA *** /oracle/oradata/ORCL/ORCL_data01.dbf

5 0 ORCL_INDEX *** /oracle/oradata/ORCL/ORCL_INDEX01.dbf

6 0 ORCLBI_DATA *** /oracle/oradata/ORCL/ORCLbi_data01.dbf

7 0 ORCLBI_INDEX *** /oracle/oradata/ORCL/ORCLbi_index01.dbf

8 0 USERS *** /oracle/oradata/ORCL/users01.dbf

9 0 ORCL_DATA *** /oracle/oradata/ORCL/ORCL_data02.dbf

10 0 SYSTEM *** /oracle/oradata/ORCL/system02.dbf

11 0 SYSAUX *** /oracle/oradata/ORCL/sysaux03.dbf

12 0 ORCL_DATA *** /oracle/oradata/ORCL/ORCLbi_data02.dbf

13 0 SYSAUX *** /oracle/oradata/ORCL/sysaux02.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

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

1 0 TEMP 32767 /oracle/oradata/ORCL/temp01.dbf

RMAN>

RMAN> catalog start with '/u03/ORCL';

searching for all files that match the pattern /u03/ORCL

List of Files Unknown to the Database

=====================================

File Name: /u03/ORCL/ORCL_17009_1_1_inc

File Name: /u03/ORCL/ORCL_16999_1_1_inc

File Name: /u03/ORCL/ORCL_17011_1_1_inc

File Name: /u03/ORCL/ORCL_17003_1_1_inc

File Name: /u03/ORCL/ORCL_16996_1_1_full

File Name: /u03/ORCL/ORCL_17010_1_1_inc

File Name: /u03/ORCL/ORCL_17007_1_1_inc

File Name: /u03/ORCL/ORCL_17002_1_1_inc

File Name: /u03/ORCL/ORCL_17012_1_1_inc

File Name: /u03/ORCL/ORCL_17005_1_1_inc

File Name: /u03/ORCL/ORCL_17001_1_1_inc

File Name: /u03/ORCL/ORCL_17006_1_1_inc

File Name: /u03/ORCL/ORCL_16998_1_1_inc

Do you really want to catalog the above files (enter YES or NO)? YES

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u03/ORCL/ORCL_17009_1_1_inc

File Name: /u03/ORCL/ORCL_16999_1_1_inc

File Name: /u03/ORCL/ORCL_17011_1_1_inc

File Name: /u03/ORCL/ORCL_17003_1_1_inc

File Name: /u03/ORCL/ORCL_16996_1_1_full

File Name: /u03/ORCL/ORCL_17010_1_1_inc

File Name: /u03/ORCL/ORCL_17007_1_1_inc

File Name: /u03/ORCL/ORCL_17002_1_1_inc

File Name: /u03/ORCL/ORCL_17012_1_1_inc

File Name: /u03/ORCL/ORCL_17005_1_1_inc

File Name: /u03/ORCL/ORCL_17001_1_1_inc

File Name: /u03/ORCL/ORCL_17006_1_1_inc

File Name: /u03/ORCL/ORCL_16998_1_1_inc

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA

Report of database schema

List of Permanent Datafiles

===========================

File Size(MB) Tablespace RB segs Datafile Name

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

1 0 SYSTEM *** /oracle/oradata/ORCL/system01.dbf

2 0 UNDOTBS1 *** /oracle/oradata/ORCL/undotbs01.dbf

3 0 SYSAUX *** /oracle/oradata/ORCL/sysaux01.dbf

4 0 ORCL_DATA *** /oracle/oradata/ORCL/ORCL_data01.dbf

5 0 ORCL_INDEX *** /oracle/oradata/ORCL/ORCL_INDEX01.dbf

6 0 ORCLBI_DATA *** /oracle/oradata/ORCL/ORCLbi_data01.dbf

7 0 ORCLBI_INDEX *** /oracle/oradata/ORCL/ORCLbi_index01.dbf

8 0 USERS *** /oracle/oradata/ORCL/users01.dbf

9 0 ORCL_DATA *** /oracle/oradata/ORCL/ORCL_data02.dbf

10 0 SYSTEM *** /oracle/oradata/ORCL/system02.dbf

11 0 SYSAUX *** /oracle/oradata/ORCL/sysaux03.dbf

12 0 ORCL_DATA *** /oracle/oradata/ORCL/ORCLbi_data02.dbf

13 0 SYSAUX *** /oracle/oradata/ORCL/sysaux02.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

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

1 0 TEMP 32767 /oracle/oradata/ORCL/temp01.dbf

RMAN>

RMAN> restore database preview;

Starting restore at 27-FEB-20

using channel ORA_DISK_1

data file 1 will be created automatically during restore operation

data file 2 will be created automatically during restore operation

data file 3 will be created automatically during restore operation

data file 4 will be created automatically during restore operation

data file 5 will be created automatically during restore operation

data file 6 will be created automatically during restore operation

data file 7 will be created automatically during restore operation

data file 8 will be created automatically during restore operation

data file 9 will be created automatically during restore operation

data file 10 will be created automatically during restore operation

data file 11 will be created automatically during restore operation

data file 12 will be created automatically during restore operation

data file 13 will be created automatically during restore operation

no backup of log thread 1 seq 15230 lowscn 371687323 found to restore

no backup of log thread 1 seq 15232 lowscn 371725775 found to restore

no backup of log thread 1 seq 15233 lowscn 371758519 found to restore

no backup of log thread 1 seq 15234 lowscn 371794631 found to restore

no backup of log thread 1 seq 15235 lowscn 371805910 found to restore

no backup of log thread 1 seq 15236 lowscn 371806061 found to restore

no backup of log thread 1 seq 15237 lowscn 371852459 found to restore

no backup of log thread 1 seq 15238 lowscn 371866664 found to restore

no backup of log thread 1 seq 15239 lowscn 371871394 found to restore

no backup of log thread 1 seq 15240 lowscn 371871468 found to restore

no backup of log thread 1 seq 15241 lowscn 371917160 found to restore

no backup of log thread 1 seq 15242 lowscn 371935128 found to restore

no backup of log thread 1 seq 15243 lowscn 371935206 found to restore

no backup of log thread 1 seq 15244 lowscn 371981358 found to restore

no backup of log thread 1 seq 15245 lowscn 371999852 found to restore

no backup of log thread 1 seq 15246 lowscn 371999933 found to restore

no backup of log thread 1 seq 15247 lowscn 372045246 found to restore

no backup of log thread 1 seq 15248 lowscn 372063431 found to restore

no backup of log thread 1 seq 15249 lowscn 372063521 found to restore

no backup of log thread 1 seq 15250 lowscn 372109090 found to restore

no backup of log thread 1 seq 15251 lowscn 372127564 found to restore

no backup of log thread 1 seq 15253 lowscn 372166714 found to restore

no backup of log thread 1 seq 15254 lowscn 372198353 found to restore

no backup of log thread 1 seq 15255 lowscn 372234837 found to restore

no backup of log thread 1 seq 15256 lowscn 372246908 found to restore

no backup of log thread 1 seq 15257 lowscn 372246998 found to restore

no backup of log thread 1 seq 15258 lowscn 372292469 found to restore

no backup of log thread 1 seq 15259 lowscn 372305269 found to restore

no backup of log thread 1 seq 15260 lowscn 372311789 found to restore

no backup of log thread 1 seq 15261 lowscn 372311877 found to restore

no backup of log thread 1 seq 15262 lowscn 372345756 found to restore

no backup of log thread 1 seq 15263 lowscn 372370879 found to restore

no backup of log thread 1 seq 15264 lowscn 372383499 found to restore

no backup of log thread 1 seq 15265 lowscn 372383573 found to restore

no backup of log thread 1 seq 15266 lowscn 372429430 found to restore

no backup of log thread 1 seq 15267 lowscn 372447497 found to restore

no backup of log thread 1 seq 15268 lowscn 372447571 found to restore

no backup of log thread 1 seq 15269 lowscn 372492953 found to restore

no backup of log thread 1 seq 15270 lowscn 372510716 found to restore

no backup of log thread 1 seq 15271 lowscn 372510801 found to restore

no backup of log thread 1 seq 15272 lowscn 372556257 found to restore

no backup of log thread 1 seq 15273 lowscn 372574008 found to restore

no backup of log thread 1 seq 15274 lowscn 372574177 found to restore

no backup of log thread 1 seq 15275 lowscn 372611344 found to restore

no backup of log thread 1 seq 15276 lowscn 372642891 found to restore

no backup of log thread 1 seq 15277 lowscn 372682163 found to restore

no backup of log thread 1 seq 15278 lowscn 372693963 found to restore

no backup of log thread 1 seq 15279 lowscn 372694029 found to restore

no backup of log thread 1 seq 15280 lowscn 372738961 found to restore

no backup of log thread 1 seq 15281 lowscn 372750797 found to restore

no backup of log thread 1 seq 15282 lowscn 372757758 found to restore

no backup of log thread 1 seq 15283 lowscn 372757839 found to restore

no backup of log thread 1 seq 15284 lowscn 372803024 found to restore

no backup of log thread 1 seq 15285 lowscn 372820908 found to restore

no backup of log thread 1 seq 15286 lowscn 372820986 found to restore

no backup of log thread 1 seq 15287 lowscn 372865560 found to restore

no backup of log thread 1 seq 15288 lowscn 372883147 found to restore

no backup of log thread 1 seq 15289 lowscn 372883228 found to restore

no backup of log thread 1 seq 15290 lowscn 372928485 found to restore

no backup of log thread 1 seq 15291 lowscn 372945847 found to restore

no backup of log thread 1 seq 15292 lowscn 372945929 found to restore

no backup of log thread 1 seq 15293 lowscn 372990529 found to restore

no backup of log thread 1 seq 15294 lowscn 373008518 found to restore

no backup of log thread 1 seq 15295 lowscn 373008606 found to restore

no backup of log thread 1 seq 15296 lowscn 373044449 found to restore

no backup of log thread 1 seq 15297 lowscn 373075270 found to restore

no backup of log thread 1 seq 15298 lowscn 373115437 found to restore

no backup of log thread 1 seq 15299 lowscn 373127457 found to restore

no backup of log thread 1 seq 15300 lowscn 373127529 found to restore

no backup of log thread 1 seq 15301 lowscn 373172700 found to restore

no backup of log thread 1 seq 15302 lowscn 373186504 found to restore

no backup of log thread 1 seq 15303 lowscn 373191533 found to restore

no backup of log thread 1 seq 15304 lowscn 373191608 found to restore

no backup of log thread 1 seq 15305 lowscn 373236046 found to restore

no backup of log thread 1 seq 15306 lowscn 373253794 found to restore

no backup of log thread 1 seq 15307 lowscn 373253884 found to restore

no backup of log thread 1 seq 15308 lowscn 373299044 found to restore

no backup of log thread 1 seq 15309 lowscn 373316544 found to restore

no backup of log thread 1 seq 15310 lowscn 373316742 found to restore

no backup of log thread 1 seq 15311 lowscn 373360940 found to restore

no backup of log thread 1 seq 15312 lowscn 373378500 found to restore

no backup of log thread 1 seq 15313 lowscn 373378611 found to restore

no backup of log thread 1 seq 15314 lowscn 373423476 found to restore

no backup of log thread 1 seq 15315 lowscn 373441853 found to restore

no backup of log thread 1 seq 15316 lowscn 373442041 found to restore

no backup of log thread 1 seq 15317 lowscn 373442163 found to restore

no backup of log thread 1 seq 15318 lowscn 373478669 found to restore

no backup of log thread 1 seq 15319 lowscn 373510871 found to restore

no backup of log thread 1 seq 15320 lowscn 373549128 found to restore

no backup of log thread 1 seq 15321 lowscn 373561201 found to restore

no backup of log thread 1 seq 15322 lowscn 373561283 found to restore

no backup of log thread 1 seq 15323 lowscn 373605399 found to restore

no backup of log thread 1 seq 15324 lowscn 373619223 found to restore

no backup of log thread 1 seq 15325 lowscn 373623820 found to restore

no backup of log thread 1 seq 15326 lowscn 373623897 found to restore

no backup of log thread 1 seq 15327 lowscn 373669924 found to restore

no backup of log thread 1 seq 15328 lowscn 373687994 found to restore

no backup of log thread 1 seq 15329 lowscn 373688101 found to restore

no backup of log thread 1 seq 15330 lowscn 373733802 found to restore

no backup of log thread 1 seq 15331 lowscn 373751440 found to restore

no backup of log thread 1 seq 15332 lowscn 373751552 found to restore

no backup of log thread 1 seq 15333 lowscn 373796578 found to restore

no backup of log thread 1 seq 15334 lowscn 373813667 found to restore

no backup of log thread 1 seq 15335 lowscn 373813760 found to restore

no backup of log thread 1 seq 15336 lowscn 373859637 found to restore

no backup of log thread 1 seq 15337 lowscn 373877502 found to restore

no backup of log thread 1 seq 15338 lowscn 373877621 found to restore

no backup of log thread 1 seq 15339 lowscn 373914809 found to restore

no backup of log thread 1 seq 15340 lowscn 373944958 found to restore

no backup of log thread 1 seq 15341 lowscn 373985307 found to restore

no backup of log thread 1 seq 15342 lowscn 373996924 found to restore

no backup of log thread 1 seq 15343 lowscn 373997010 found to restore

no backup of log thread 1 seq 15344 lowscn 374042473 found to restore

no backup of log thread 1 seq 15345 lowscn 374056184 found to restore

no backup of log thread 1 seq 15346 lowscn 374060773 found to restore

no backup of log thread 1 seq 15347 lowscn 374060878 found to restore

no backup of log thread 1 seq 15348 lowscn 374106412 found to restore

no backup of log thread 1 seq 15349 lowscn 374124017 found to restore

no backup of log thread 1 seq 15350 lowscn 374124122 found to restore

no backup of log thread 1 seq 15351 lowscn 374170027 found to restore

no backup of log thread 1 seq 15352 lowscn 374187560 found to restore

no backup of log thread 1 seq 15353 lowscn 374187740 found to restore

no backup of log thread 1 seq 15354 lowscn 374233126 found to restore

no backup of log thread 1 seq 15355 lowscn 374250532 found to restore

no backup of log thread 1 seq 15356 lowscn 374250667 found to restore

no backup of log thread 1 seq 15357 lowscn 374296701 found to restore

no backup of log thread 1 seq 15358 lowscn 374314594 found to restore

no backup of log thread 1 seq 15359 lowscn 374314832 found to restore

no backup of log thread 1 seq 15360 lowscn 374314947 found to restore

no backup of log thread 1 seq 15361 lowscn 374354460 found to restore

no backup of log thread 1 seq 15362 lowscn 374384593 found to restore

no backup of log thread 1 seq 15363 lowscn 374421943 found to restore

no backup of log thread 1 seq 15364 lowscn 374433345 found to restore

no backup of log thread 1 seq 15365 lowscn 374433428 found to restore

no backup of log thread 1 seq 15366 lowscn 374478734 found to restore

no backup of log thread 1 seq 15367 lowscn 374490636 found to restore

no backup of log thread 1 seq 15368 lowscn 374497590 found to restore

no backup of log thread 1 seq 15369 lowscn 374497716 found to restore

no backup of log thread 1 seq 15370 lowscn 374543487 found to restore

no backup of log thread 1 seq 15371 lowscn 374561215 found to restore

no backup of log thread 1 seq 15372 lowscn 374561315 found to restore

no backup of log thread 1 seq 15373 lowscn 374607159 found to restore

no backup of log thread 1 seq 15374 lowscn 374624859 found to restore

no backup of log thread 1 seq 15375 lowscn 374624971 found to restore

no backup of log thread 1 seq 15376 lowscn 374670756 found to restore

no backup of log thread 1 seq 15377 lowscn 374687900 found to restore

no backup of log thread 1 seq 15378 lowscn 374688013 found to restore

no backup of log thread 1 seq 15379 lowscn 374733378 found to restore

no backup of log thread 1 seq 15380 lowscn 374751240 found to restore

no backup of log thread 1 seq 15381 lowscn 374751343 found to restore

no backup of log thread 1 seq 15382 lowscn 374787969 found to restore

no backup of log thread 1 seq 15383 lowscn 374817821 found to restore

no backup of log thread 1 seq 15384 lowscn 374857302 found to restore

no backup of log thread 1 seq 15385 lowscn 374870098 found to restore

no backup of log thread 1 seq 15386 lowscn 374870185 found to restore

no backup of log thread 1 seq 15387 lowscn 374916002 found to restore

no backup of log thread 1 seq 15388 lowscn 374929673 found to restore

no backup of log thread 1 seq 15389 lowscn 374934586 found to restore

no backup of log thread 1 seq 15390 lowscn 374934695 found to restore

no backup of log thread 1 seq 15391 lowscn 374980867 found to restore

no backup of log thread 1 seq 15392 lowscn 374998497 found to restore

no backup of log thread 1 seq 15393 lowscn 374998625 found to restore

no backup of log thread 1 seq 15394 lowscn 375044379 found to restore

no backup of log thread 1 seq 15395 lowscn 375061775 found to restore

no backup of log thread 1 seq 15396 lowscn 375061914 found to restore

no backup of log thread 1 seq 15397 lowscn 375108390 found to restore

no backup of log thread 1 seq 15398 lowscn 375125694 found to restore

no backup of log thread 1 seq 15399 lowscn 375125820 found to restore

no backup of log thread 1 seq 15400 lowscn 375171455 found to restore

no backup of log thread 1 seq 15401 lowscn 375187060 found to restore

no backup of log thread 1 seq 15402 lowscn 375189536 found to restore

no backup of log thread 1 seq 15403 lowscn 375189665 found to restore

no backup of log thread 1 seq 15404 lowscn 375228897 found to restore

no backup of log thread 1 seq 15405 lowscn 375259045 found to restore

no backup of log thread 1 seq 15406 lowscn 375295721 found to restore

no backup of log thread 1 seq 15407 lowscn 375308032 found to restore

no backup of log thread 1 seq 15408 lowscn 375308144 found to restore

no backup of log thread 1 seq 15409 lowscn 375354416 found to restore

no backup of log thread 1 seq 15410 lowscn 375365773 found to restore

no backup of log thread 1 seq 15411 lowscn 375372860 found to restore

no backup of log thread 1 seq 15412 lowscn 375372963 found to restore

no backup of log thread 1 seq 15413 lowscn 375420565 found to restore

no backup of log thread 1 seq 15414 lowscn 375438038 found to restore

no backup of log thread 1 seq 15415 lowscn 375438146 found to restore

no backup of log thread 1 seq 15416 lowscn 375484312 found to restore

no backup of log thread 1 seq 15417 lowscn 375502091 found to restore

no backup of log thread 1 seq 15418 lowscn 375502216 found to restore

no backup of log thread 1 seq 15419 lowscn 375548440 found to restore

no backup of log thread 1 seq 15420 lowscn 375565957 found to restore

no backup of log thread 1 seq 15421 lowscn 375566066 found to restore

no backup of log thread 1 seq 15422 lowscn 375612339 found to restore

no backup of log thread 1 seq 15423 lowscn 375630246 found to restore

no backup of log thread 1 seq 15424 lowscn 375630460 found to restore

no backup of log thread 1 seq 15425 lowscn 375630575 found to restore

no backup of log thread 1 seq 15426 lowscn 375666063 found to restore

no backup of log thread 1 seq 15427 lowscn 375695912 found to restore

no backup of log thread 1 seq 15428 lowscn 375736783 found to restore

no backup of log thread 1 seq 15429 lowscn 375749267 found to restore

no backup of log thread 1 seq 15430 lowscn 375749365 found to restore

no backup of log thread 1 seq 15431 lowscn 375793341 found to restore

no backup of log thread 1 seq 15432 lowscn 375809132 found to restore

no backup of log thread 1 seq 15433 lowscn 375811510 found to restore

no backup of log thread 1 seq 15434 lowscn 375811633 found to restore

no backup of log thread 1 seq 15435 lowscn 375857227 found to restore

no backup of log thread 1 seq 15436 lowscn 375875326 found to restore

no backup of log thread 1 seq 15437 lowscn 375875448 found to restore

no backup of log thread 1 seq 15438 lowscn 375921507 found to restore

no backup of log thread 1 seq 15439 lowscn 375939187 found to restore

no backup of log thread 1 seq 15440 lowscn 375939319 found to restore

no backup of log thread 1 seq 15441 lowscn 375984657 found to restore

no backup of log thread 1 seq 15442 lowscn 376002049 found to restore

no backup of log thread 1 seq 15443 lowscn 376002157 found to restore

no backup of log thread 1 seq 15444 lowscn 376047620 found to restore

no backup of log thread 1 seq 15445 lowscn 376065562 found to restore

no backup of log thread 1 seq 15446 lowscn 376065689 found to restore

no backup of log thread 1 seq 15447 lowscn 376065886 found to restore

no backup of log thread 1 seq 15448 lowscn 376104179 found to restore

no backup of log thread 1 seq 15449 lowscn 376134238 found to restore

no backup of log thread 1 seq 15450 lowscn 376172581 found to restore

no backup of log thread 1 seq 15451 lowscn 376184745 found to restore

no backup of log thread 1 seq 15452 lowscn 376184861 found to restore

no backup of log thread 1 seq 15453 lowscn 376229735 found to restore

no backup of log thread 1 seq 15454 lowscn 376242951 found to restore

no backup of log thread 1 seq 15455 lowscn 376248364 found to restore

no backup of log thread 1 seq 15456 lowscn 376248463 found to restore

no backup of log thread 1 seq 15457 lowscn 376294034 found to restore

no backup of log thread 1 seq 15458 lowscn 376311394 found to restore

no backup of log thread 1 seq 15459 lowscn 376311504 found to restore

no backup of log thread 1 seq 15460 lowscn 376357285 found to restore

no backup of log thread 1 seq 15461 lowscn 376374546 found to restore

no backup of log thread 1 seq 15462 lowscn 376374659 found to restore

no backup of log thread 1 seq 15463 lowscn 376420251 found to restore

no backup of log thread 1 seq 15464 lowscn 376437643 found to restore

no backup of log thread 1 seq 15465 lowscn 376437764 found to restore

no backup of log thread 1 seq 15466 lowscn 376482787 found to restore

no backup of log thread 1 seq 15467 lowscn 376500834 found to restore

no backup of log thread 1 seq 15468 lowscn 376500950 found to restore

List of Backup Sets

===================

BS Key Size Device Type Elapsed Time Completion Time

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

16994 133.87M DISK 00:00:23 27-FEB-20

BP Key: 17001 Status: AVAILABLE Compressed: YES Tag: TAG20200227T040153

Piece Name: /u03/ORCL/ORCL_17010_1_1_inc

List of Archived Logs in backup set 16994

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15469 376538978 22-FEB-20 376568556 23-FEB-20

1 15470 376568556 23-FEB-20 376606639 23-FEB-20

1 15471 376606639 23-FEB-20 376618751 24-FEB-20

1 15472 376618751 24-FEB-20 376618845 24-FEB-20

1 15473 376618845 24-FEB-20 376663756 24-FEB-20

1 15474 376663756 24-FEB-20 376677937 25-FEB-20

1 15475 376677937 25-FEB-20 376682881 25-FEB-20

1 15476 376682881 25-FEB-20 376683008 25-FEB-20

1 15477 376683008 25-FEB-20 376728106 25-FEB-20

1 15478 376728106 25-FEB-20 376745863 26-FEB-20

1 15479 376745863 26-FEB-20 376745976 26-FEB-20

1 15480 376745976 26-FEB-20 376791447 26-FEB-20

1 15481 376791447 26-FEB-20 376808760 27-FEB-20

List of Archived Log Copies

Key Thrd Seq S Low Time Name

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

15541 1 28 A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_28_h0pj17tw_.arc

15539 1 29 A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_29_h0pj17ty_.arc

15540 1 30 A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_30_h0pj1chf_.arc

15542 1 31 A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_31_h0pj25xx_.arc

15543 1 32 A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2019_12_31/o1_mf_1_32_h0pj2q9r_.arc

15549 1 33 A 31-DEC-19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_33_h5h5n3g3_.arc

15547 1 34 A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_34_h5h5nc94_.arc

15545 1 35 A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_35_h5h5nlqz_.arc

15544 1 36 A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_36_h5h5nvdl_.arc

15548 1 37 A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_37_h5h5o2gy_.arc

15550 1 38 A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_38_h5h5obl5_.arc

15546 1 39 A 27-FEB-20 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2020_02_27/o1_mf_1_39_h5h5oo5h_.arc

Media recovery start SCN is 10

Recovery must be done beyond SCN 109348927 to clear data files fuzziness

Finished restore at 27-FEB-20

RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA

Report of database schema

List of Permanent Datafiles

===========================

File Size(MB) Tablespace RB segs Datafile Name

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

1 445 SYSTEM *** /oracle/oradata/ORCL/system01.dbf

2 292 UNDOTBS1 *** /oracle/oradata/ORCL/undotbs01.dbf

3 600 SYSAUX *** /oracle/oradata/ORCL/sysaux01.dbf

4 800 ORCL_data *** /oracle/oradata/ORCL/ORCL_data01.dbf

5 50 ORCL_INDEX *** /oracle/oradata/ORCL/ORCL_INDEX01.dbf

6 5000 ORCLBI_data *** /oracle/oradata/ORCL/ORCLbi_data01.dbf

7 10 ORCLBI_INDEX *** /oracle/oradata/ORCL/ORCLbi_index01.dbf

8 5 USERS *** /oracle/oradata/ORCL/users01.dbf

9 410 ORCL_data *** /oracle/oradata/ORCL/ORCL_data02.dbf

10 500 SYSTEM *** /oracle/oradata/ORCL/system02.dbf

11 100 SYSAUX *** /oracle/oradata/ORCL/sysaux03.dbf

12 500 ORCL_data *** /oracle/oradata/ORCL/ORCLbi_data02.dbf

13 240 SYSAUX *** /oracle/oradata/ORCL/sysaux02.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace Maxsize(MB) Tempfile Name

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

1 0 TEMP 32767 /oracle/oradata/ORCL/temp01.dbf

RMAN> list backup of archivelog all;

List of Backup Sets

===================

BS Key Size Device Type Elapsed Time Completion Time

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

16982 38.23M DISK 00:00:06 24-FEB-20

BP Key: 17008 Status: AVAILABLE Compressed: YES Tag: TAG20200224T040132

Piece Name: /u03/ORCL/ORCL_16998_1_1_inc

List of Archived Logs in backup set 16982

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15469 376538978 22-FEB-20 376568556 23-FEB-20

1 15470 376568556 23-FEB-20 376606639 23-FEB-20

1 15471 376606639 23-FEB-20 376618751 24-FEB-20

BS Key Size Device Type Elapsed Time Completion Time

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

16985 100.50K DISK 00:00:01 24-FEB-20

BP Key: 17006 Status: AVAILABLE Compressed: YES Tag: TAG20200224T040319

Piece Name: /u03/ORCL/ORCL_17001_1_1_inc

List of Archived Logs in backup set 16985

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15472 376618751 24-FEB-20 376618845 24-FEB-20

BS Key Size Device Type Elapsed Time Completion Time

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

16986 73.32M DISK 00:00:13 25-FEB-20

BP Key: 17003 Status: AVAILABLE Compressed: YES Tag: TAG20200225T040144

Piece Name: /u03/ORCL/ORCL_17002_1_1_inc

List of Archived Logs in backup set 16986

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15469 376538978 22-FEB-20 376568556 23-FEB-20

1 15470 376568556 23-FEB-20 376606639 23-FEB-20

1 15471 376606639 23-FEB-20 376618751 24-FEB-20

1 15472 376618751 24-FEB-20 376618845 24-FEB-20

1 15473 376618845 24-FEB-20 376663756 24-FEB-20

1 15474 376663756 24-FEB-20 376677937 25-FEB-20

1 15475 376677937 25-FEB-20 376682881 25-FEB-20

BS Key Size Device Type Elapsed Time Completion Time

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

16989 151.00K DISK 00:00:01 25-FEB-20

BP Key: 17005 Status: AVAILABLE Compressed: YES Tag: TAG20200225T040339

Piece Name: /u03/ORCL/ORCL_17005_1_1_inc

List of Archived Logs in backup set 16989

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15476 376682881 25-FEB-20 376683008 25-FEB-20

BS Key Size Device Type Elapsed Time Completion Time

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

16990 105.40M DISK 00:00:17 26-FEB-20

BP Key: 17007 Status: AVAILABLE Compressed: YES Tag: TAG20200226T040140

Piece Name: /u03/ORCL/ORCL_17006_1_1_inc

List of Archived Logs in backup set 16990

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15469 376538978 22-FEB-20 376568556 23-FEB-20

1 15470 376568556 23-FEB-20 376606639 23-FEB-20

1 15471 376606639 23-FEB-20 376618751 24-FEB-20

1 15472 376618751 24-FEB-20 376618845 24-FEB-20

1 15473 376618845 24-FEB-20 376663756 24-FEB-20

1 15474 376663756 24-FEB-20 376677937 25-FEB-20

1 15475 376677937 25-FEB-20 376682881 25-FEB-20

1 15476 376682881 25-FEB-20 376683008 25-FEB-20

1 15477 376683008 25-FEB-20 376728106 25-FEB-20

1 15478 376728106 25-FEB-20 376745863 26-FEB-20

BS Key Size Device Type Elapsed Time Completion Time

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

16993 112.50K DISK 00:00:02 26-FEB-20

BP Key: 16996 Status: AVAILABLE Compressed: YES Tag: TAG20200226T040345

Piece Name: /u03/ORCL/ORCL_17009_1_1_inc

List of Archived Logs in backup set 16993

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15479 376745863 26-FEB-20 376745976 26-FEB-20

BS Key Size Device Type Elapsed Time Completion Time

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

16994 133.87M DISK 00:00:23 27-FEB-20

BP Key: 17001 Status: AVAILABLE Compressed: YES Tag: TAG20200227T040153

Piece Name: /u03/ORCL/ORCL_17010_1_1_inc

List of Archived Logs in backup set 16994

Thrd Seq Low SCN Low Time Next SCN Next Time

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

1 15469 376538978 22-FEB-20 376568556 23-FEB-20

1 15470 376568556 23-FEB-20 376606639 23-FEB-20

1 15471 376606639 23-FEB-20 376618751 24-FEB-20

1 15472 376618751 24-FEB-20 376618845 24-FEB-20

1 15473 376618845 24-FEB-20 376663756 24-FEB-20

1 15474 376663756 24-FEB-20 376677937 25-FEB-20

1 15475 376677937 25-FEB-20 376682881 25-FEB-20

1 15476 376682881 25-FEB-20 376683008 25-FEB-20

1 15477 376683008 25-FEB-20 376728106 25-FEB-20

1 15478 376728106 25-FEB-20 376745863 26-FEB-20

1 15479 376745863 26-FEB-20 376745976 26-FEB-20

1 15480 376745976 26-FEB-20 376791447 26-FEB-20

1 15481 376791447 26-FEB-20 376808760 27-FEB-20

RMAN> restore database until sequence 15480;

Starting restore at 28-FEB-20

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /oracle/oradata/ORCL/system01.dbf

restoring datafile 00002 to /oracle/oradata/ORCL/undotbs01.dbf

restoring datafile 00003 to /oracle/oradata/ORCL/sysaux01.dbf

restoring datafile 00004 to /oracle/oradata/ORCL/ORCL_data01.dbf

restoring datafile 00005 to /oracle/oradata/ORCL/ORCL_INDEX01.dbf

restoring datafile 00006 to /oracle/oradata/ORCL/ORCLbi_data01.dbf

restoring datafile 00007 to /oracle/oradata/ORCL/ORCLbi_index01.dbf

restoring datafile 00008 to /oracle/oradata/ORCL/users01.dbf

restoring datafile 00009 to /oracle/oradata/ORCL/ORCL_data02.dbf

restoring datafile 00010 to /oracle/oradata/ORCL/system02.dbf

restoring datafile 00011 to /oracle/oradata/ORCL/sysaux03.dbf

restoring datafile 00012 to /oracle/oradata/ORCL/ORCLbi_data02.dbf

restoring datafile 00013 to /oracle/oradata/ORCL/sysaux02.dbf

channel ORA_DISK_1: reading from backup piece /u03/ORCL/ORCL_16996_1_1_full

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/ORCL/ORCL_16996_1_1_full tag=TAG20200223T040229

channel ORA_DISK_1: restore complete, elapsed time: 00:10:46

Finished restore at 28-FEB-20

RMAN>

RMAN> recover database until sequence 15480;

Starting recover at 28-FEB-20

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: /oracle/oradata/ORCL/system01.dbf

destination for restore of datafile 00002: /oracle/oradata/ORCL/undotbs01.dbf

destination for restore of datafile 00003: /oracle/oradata/ORCL/sysaux01.dbf

destination for restore of datafile 00004: /oracle/oradata/ORCL/ORCL_data01.dbf

destination for restore of datafile 00005: /oracle/oradata/ORCL/ORCL_INDEX01.dbf

destination for restore of datafile 00006: /oracle/oradata/ORCL/ORCLbi_data01.dbf

destination for restore of datafile 00007: /oracle/oradata/ORCL/ORCLbi_index01.dbf

destination for restore of datafile 00008: /oracle/oradata/ORCL/users01.dbf

destination for restore of datafile 00009: /oracle/oradata/ORCL/ORCL_data02.dbf

destination for restore of datafile 00010: /oracle/oradata/ORCL/system02.dbf

destination for restore of datafile 00011: /oracle/oradata/ORCL/sysaux03.dbf

destination for restore of datafile 00012: /oracle/oradata/ORCL/ORCLbi_data02.dbf

destination for restore of datafile 00013: /oracle/oradata/ORCL/sysaux02.dbf

channel ORA_DISK_1: reading from backup piece /u03/ORCL/ORCL_16999_1_1_inc

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/ORCL/ORCL_16999_1_1_inc tag=TAG20200224T040140

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15