We've attempted an upgrade this week of one of out 11.2.0.2 systems to 12.1.0.2, this ended badly with some weird problem with acl's and timestamp with timezone datatypes messing it up.
ERROR = [ORA-01830: date format picture ends before converting entire input string ORA-06512: at "SYS.XS_OBJECT_MIGRATION", line 167
This seemed to be a known problem and we followed the doc below
Oracle Support Document 1958876.1 (Upgrade to 12.1 fails with ORA-01830 date format picture ends before converting entire input string ORA-06512: at "SYS.XS_OBJECT_MIGRATION") can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1958876.1
This removed all the timezones but the issue still persisted and we couldn't find a way forward - the acl removal procedure would not even work - so we were forced to abandon the upgrade.
With all the issues we were having we decided running any kind of downgrade script was not a good idea - instead we'd just restore from rman backup.
The code below shows how to restore from rman backup when you want to restore everything - including the controlfiles.
First up we shutdown abort the instance at 12c to make sure there is no SGA left at all - we don;t care about the status of any of the files as we will trash the lot.
[oracle@server-name]:DB_NAME:[/oracle/12.1.0.2.1.DB/rdbms/admin]# s
SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 19 20:31:10 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shutdown abort;
ORACLE instance shut down.
SQL>
Then we update the oratab back to 11.2 and switch the environment back to 11.2
Now we startup nomount to get an instance again (note just the instance - we don't mount anything)
SQL*Plus: Release 11.2.0.2.0 Production on Thu Feb 19 20:40:41 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SYS@DB_NAME>startup nomount
ORACLE instance started.
Total System Global Area 8551575552 bytes
Fixed Size 2243608 bytes
Variable Size 4395631592 bytes
Database Buffers 4143972352 bytes
Redo Buffers 9728000 bytes
SYS@DB_NAME>
Now we fire up rman
rman target=/ catalog=user/pass@catalog
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Feb 19 20:41:56 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DB_NAME (not mounted)
connected to recovery catalog database
Note here that it doesn't know which dbid we are interested in as there are multiple with the same name so we have to tell it. We find the dbid from the backup logs of the earlier backups.
We then run the following script to do the restore and recover
RUN
{
set dbid 3219893268;
SET UNTIL TIME '19-FEB-2015 16:15:32';
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/tsm/DB_NAME/conf/tdpo.opt)';
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
}
Note the following
1) dbid has to be explicitly set
2) set until time has to be explicitly set to just before we tried the upgrade
3) We have to allocate a tape channel as our backups are on tape
4) we need an explicit mount after the controlfiles are restore
So lets run it - I've included all the output just so you can see everything it did.
RMAN> RUN
2> {
3> set dbid 3219893268;
4> SET UNTIL TIME '19-FEB-2015 16:15:32';
5> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/tsm/DB_NAME/conf/tdpo.opt)';
6> RESTORE CONTROLFILE;
ALTER DATABASE MOUNT; 7>
8> RESTORE DATABASE;
9> RECOVER DATABASE;
10> }
executing command: SET DBID
database name is "DB_NAME" and DBID is 3219893268
executing command: SET until clause
allocated channel: t1
channel t1: SID=178 device type=SBT_TAPE
channel t1: Data Protection for Oracle: version 6.3.0.0
Starting restore at 19-FEB-15
channel t1: starting datafile backup set restore
channel t1: restoring control file
channel t1: reading from backup piece database_online_DB_NAME_872076074_20150219_2429.rman
channel t1: piece handle=database_online_DB_NAME_872076074_20150219_2429.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:01:55
output file name=/oracle/DB_NAME/oradata/DB_NAME/controlfile/o1_mf_6gjcwhop_.ctl
output file name=/oracle/DB_NAME/recovery_area/DB_NAME/controlfile/o1_mf_6gjcwhrg_.ctl
Finished restore at 19-FEB-15
database mounted
Starting restore at 19-FEB-15
Starting implicit crosscheck backup at 19-FEB-15
Finished implicit crosscheck backup at 19-FEB-15
Starting implicit crosscheck copy at 19-FEB-15
Finished implicit crosscheck copy at 19-FEB-15
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3462_91qdy4k0_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3458_91oc3c3s_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3457_91oc25lo_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3453_91obj3k5_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3456_91oc1xqp_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3459_91oc4yny_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3450_91obbh76_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3452_91obbqh8_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3460_91oc6lxq_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3451_91obbn4k_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3455_91oc1mdk_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3454_91obshq9_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_26/o1_mf_1_3461_91ot69xh_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1189_bgd46q51_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1192_bgd4qjd0_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1193_bgd510tt_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1188_bgd3w1ty_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1191_bgd4q77y_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1196_bgd8w663_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1197_bgd90jf9_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1186_bgd3cf1v_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1190_bgd4py68_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1198_bgdf6jkh_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1187_bgd3g77y_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1194_bgd8df48_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1199_bgdfmgt8_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_19/o1_mf_1_1195_bgd8s5n8_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3470_91qzlsr8_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3468_91qzj8hv_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3463_91qyq0v4_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3467_91qz82q6_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3464_91qywjcy_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3473_91qzod88_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3465_91qz52v3_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3471_91qzm43k_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3472_91qzmgbw_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3469_91qzk80c_.arc
File Name: /oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2013_08_27/o1_mf_1_3466_91qz6ghs_.arc
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00003 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_sys_undo_91vg82pn_.dbf
channel t1: restoring datafile 00012 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_bus_data_91vg8301_.dbf
channel t1: restoring datafile 00039 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_tools_91vg82yg_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872070093_20150219_2412.rman
channel t1: piece handle=database_online_DB_NAME_872070093_20150219_2412.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:21:05
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00018 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_erro_91vhj2ny_.dbf
channel t1: restoring datafile 00025 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_gti_aq_d_91vhj2os_.dbf
channel t1: restoring datafile 00051 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_sys_undo_91vhj2n9_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872070899_20150219_2413.rman
channel t1: piece handle=database_online_DB_NAME_872070899_20150219_2413.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:20:26
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00004 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_aq_data_91vk8gmd_.dbf
channel t1: restoring datafile 00024 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_figs_ind_91vl20mn_.dbf
channel t1: restoring datafile 00041 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_zn_load__91vmypv2_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872074552_20150219_2423.rman
channel t1: piece handle=database_online_DB_NAME_872074552_20150219_2423.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:13:15
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00009 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_boss_ind_91voss3n_.dbf
channel t1: restoring datafile 00014 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_aq_91voss2v_.dbf
channel t1: restoring datafile 00045 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pos_mgnt_91voss24_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872071364_20150219_2414.rman
channel t1: piece handle=database_online_DB_NAME_872071364_20150219_2414.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:31:15
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00006 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_audit_da_91vl20kt_.dbf
channel t1: restoring datafile 00008 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_boss_dat_91vo4q6o_.dbf
channel t1: restoring datafile 00021 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_common_i_91vohbhc_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872074967_20150219_2424.rman
channel t1: piece handle=database_online_DB_NAME_872074967_20150219_2424.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:11:55
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00028 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_mrkt_inf_91vj7m3m_.dbf
channel t1: restoring datafile 00033 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pos_mgnt_91vj7m18_.dbf
channel t1: restoring datafile 00050 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_eisdba_91vj7m2m_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872071709_20150219_2415.rman
channel t1: piece handle=database_online_DB_NAME_872071709_20150219_2415.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:20:55
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00007 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_audit_in_91vlrfq7_.dbf
channel t1: restoring datafile 00029 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_mrkt_inf_91vlrfr5_.dbf
channel t1: restoring datafile 00049 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_audit_da_91vlrfpg_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872075193_20150219_2425.rman
channel t1: piece handle=database_online_DB_NAME_872075193_20150219_2425.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:06:25
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00026 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_load_dat_91vjrmj7_.dbf
channel t1: restoring datafile 00034 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pos_mgnt_91vjrmhj_.dbf
channel t1: restoring datafile 00044 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_xdb_91vjrmk7_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872072045_20150219_2416.rman
channel t1: piece handle=database_online_DB_NAME_872072045_20150219_2416.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:16:15
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00002 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_sysaux_91vohbgf_.dbf
channel t1: restoring datafile 00017 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_data_91vohbfc_.dbf
channel t1: restoring datafile 00020 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_common_d_91vl20lp_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872075468_20150219_2426.rman
channel t1: piece handle=database_online_DB_NAME_872075468_20150219_2426.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:11:46
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00013 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_bus_inde_91vkkwk3_.dbf
channel t1: restoring datafile 00040 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_users_91vkkwj7_.dbf
channel t1: restoring datafile 00046 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pos_mgnt_91vkkwhl_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872072370_20150219_2417.rman
channel t1: piece handle=database_online_DB_NAME_872072370_20150219_2417.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:18:25
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00016 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_big__91vmkxy8_.dbf
channel t1: restoring datafile 00019 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_inde_91vmkxxj_.dbf
channel t1: restoring datafile 00048 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_big__91vmkxz5_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872075703_20150219_2427.rman
channel t1: piece handle=database_online_DB_NAME_872075703_20150219_2427.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:09:35
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00022 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_elpm_sna_91vl89xv_.dbf
channel t1: restoring datafile 00027 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_mrkt_inf_91vl89wf_.dbf
channel t1: restoring datafile 00043 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_zn_load__91vl89yt_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872072675_20150219_2418.rman
channel t1: piece handle=database_online_DB_NAME_872072675_20150219_2418.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:08:35
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00001 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_system_91vndlhz_.dbf
channel t1: restoring datafile 00031 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_ph2_trad_91vndlh6_.dbf
channel t1: restoring datafile 00042 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_zn_load__91vndlgg_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872075899_20150219_2428.rman
channel t1: piece handle=database_online_DB_NAME_872075899_20150219_2428.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:10:45
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00005 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_aq_tib_d_91vm2t70_.dbf
channel t1: restoring datafile 00036 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pos_mgnt_91vm2t53_.dbf
channel t1: restoring datafile 00038 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pwr_stmt_91vm2t64_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872072951_20150219_2419.rman
channel t1: piece handle=database_online_DB_NAME_872072951_20150219_2419.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:21:16
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00011 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_bo_index_91vns3xx_.dbf
channel t1: restoring datafile 00023 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_figs_dat_91vmypsx_.dbf
channel t1: restoring datafile 00047 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_big__91vmyps6_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872073246_20150219_2420.rman
channel t1: piece handle=database_online_DB_NAME_872073246_20150219_2420.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:20:25
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00010 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_bo_data_91vo4q7m_.dbf
channel t1: restoring datafile 00015 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_cns_big__91vns3w7_.dbf
channel t1: restoring datafile 00037 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pwr_stmt_91vns3wx_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872073551_20150219_2421.rman
channel t1: piece handle=database_online_DB_NAME_872073551_20150219_2421.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:22:25
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00030 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_mrkt_inf_91vk8gn3_.dbf
channel t1: restoring datafile 00032 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_ph2_trad_91vk8gnz_.dbf
channel t1: restoring datafile 00035 to /oracle/DB_NAME/oradata/DB_NAME/datafile/o1_mf_pos_mgnt_91vo4q50_.dbf
channel t1: reading from backup piece database_online_DB_NAME_872074037_20150219_2422.rman
channel t1: piece handle=database_online_DB_NAME_872074037_20150219_2422.rman tag=TAG20150219T094131
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:12:05
Finished restore at 20-FEB-15
Starting recover at 20-FEB-15
starting media recovery
channel t1: starting archived log restore to default destination
channel t1: restoring archived log
archived log thread=1 sequence=1185
channel t1: reading from backup piece redolog_DB_NAME_872077420_20150219_2430_1.rman
channel t1: piece handle=redolog_DB_NAME_872077420_20150219_2430_1.rman tag=TAG20150219T114339
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:01:55
archived log file name=/oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_20/o1_mf_1_1185_bgf3rhyr_.arc thread=1 sequence=1185
channel default: deleting archived log(s)
archived log file name=/oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_20/o1_mf_1_1185_bgf3rhyr_.arc RECID=1209 STAMP=872127249
channel t1: starting archived log restore to default destination
channel t1: restoring archived log
archived log thread=1 sequence=1186
channel t1: reading from backup piece redolog_DB_NAME_872125000_20150220_2431_1.rman
channel t1: piece handle=redolog_DB_NAME_872125000_20150220_2431_1.rman tag=TAG20150220T005635
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:02:45
archived log file name=/oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_20/o1_mf_1_1186_bgf3tk73_.arc thread=1 sequence=1186
channel default: deleting archived log(s)
archived log file name=/oracle/DB_NAME/recovery_area/DB_NAME/archivelog/2015_02_20/o1_mf_1_1186_bgf3tk73_.arc RECID=1210 STAMP=872127348
media recovery complete, elapsed time: 00:00:24
Finished recover at 20-FEB-15
released channel: t1
RMAN>
And there we go - db restored to that exact point in time.
As this is incomplete recovery we now have to open the database with the resetlogs option
SYS@DB_NAME>alter database open resetlogs;
Database altered.
SYS@DB_NAME>
And there we go - a complete restore back to 11.2.
Informative post. Thanks!
ReplyDelete