|
- [root@station90 ~]# su - oracle
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:42:25 2018
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> list incarnation of database;
- using target database control file instead of recovery catalog
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 1 ORCL 1343950367 PARENT 1 15-AUG-09
- 2 2 ORCL 1343950367 PARENT 945184 23-MAY-13
- 3 3 ORCL 1343950367 ORPHAN 1451975 01-APR-18
- 4 4 ORCL 1343950367 PARENT 1451975 01-APR-18
- 5 5 ORCL 1343950367 ORPHAN 1456352 01-APR-18
- 6 6 ORCL 1343950367 PARENT 1456361 01-APR-18
- 7 7 ORCL 1343950367 CURRENT 1464173 01-APR-18
- RMAN> shutdown abort
- Oracle instance shut down
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:43:36 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected to an idle instance.
- SQL> startup mount
- ORACLE instance started.
- Total System Global Area 6680915968 bytes
- Fixed Size 2213936 bytes
- Variable Size 3623880656 bytes
- Database Buffers 3019898880 bytes
- Redo Buffers 34922496 bytes
- Database mounted.
- SQL> flashback database to before resetlogs;
- Flashback complete.
- SQL> alter database open resetlogs;
- Database altered.
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:48:18 2018
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> list incarnation of database;
- using target database control file instead of recovery catalog
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 1 ORCL 1343950367 PARENT 1 15-AUG-09
- 2 2 ORCL 1343950367 PARENT 945184 23-MAY-13
- 3 3 ORCL 1343950367 ORPHAN 1451975 01-APR-18
- 4 4 ORCL 1343950367 PARENT 1451975 01-APR-18
- 5 5 ORCL 1343950367 ORPHAN 1456352 01-APR-18
- 6 6 ORCL 1343950367 PARENT 1456361 01-APR-18
- 7 7 ORCL 1343950367 ORPHAN 1464173 01-APR-18
- 8 8 ORCL 1343950367 CURRENT 1464173 02-APR-18
- RMAN> shutdown abort
- Oracle instance shut down
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:51:32 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected to an idle instance.
- SQL> startup mount
- ORACLE instance started.
- Total System Global Area 6680915968 bytes
- Fixed Size 2213936 bytes
- Variable Size 3623880656 bytes
- Database Buffers 3019898880 bytes
- Redo Buffers 34922496 bytes
- Database mounted.
- SQL> flashback database to before resetlogs;
- flashback database to before resetlogs
- *
- ERROR at line 1:
- ORA-38766: cannot flashback data file 5; file resized smaller
- ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'
- SQL> alter database datafile 5 offline ;
- Database altered.
- SQL> flashback database to before resetlogs;
- Flashback complete.
- SQL> alter database datafile 5 online ;
- Database altered.
- SQL> alter database open resetlogs;
- alter database open resetlogs
- *
- ERROR at line 1:
- ORA-01190: control file or data file 5 is from before the last RESETLOGS
- ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:53:39 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> alter database datafile 5 offline ;
- Database altered.
- SQL> alter database open ;
- alter database open
- *
- ERROR at line 1:
- ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
- SQL> alter database open resetlogs;
- alter database open resetlogs
- *
- ERROR at line 1:
- ORA-01245: offline file 5 will be lost if RESETLOGS is done
- ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:54:16 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:54:28 2018
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN> restore datafile 5 ;
- Starting restore at 02-APR-18
- using target database control file instead of recovery catalog
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=192 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=132 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=9 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=70 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=10 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.256.972322947
- channel ORA_SBT_TAPE_1: reading from backup piece 12s4ih4j_1_1
- channel ORA_SBT_TAPE_1: piece handle=12s4ih4j_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
- Finished restore at 02-APR-18
- RMAN> recover datafile 5;
- Starting recover at 02-APR-18
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of recover command at 04/02/2018 19:55:42
- RMAN-06067: RECOVER DATABASE required with a backup or created control file
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:56:05 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> alter database open resetlogs;
- alter database open resetlogs
- *
- ERROR at line 1:
- ORA-01245: offline file 5 will be lost if RESETLOGS is done
- ORA-01110: data file 5: '+DATA/orcl/datafile/example.256.972322947'
- SQL> recover datafile 5 ;
- ORA-00283: recovery session canceled due to errors
- ORA-38798: Cannot perform partial database recovery
- ORA-38797: Full database recovery required after a database has been flashed
- back
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:56:37 2018
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN> recover database;
- Starting recover at 02-APR-18
- using target database control file instead of recovery catalog
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=194 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=10 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=132 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=9 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=70 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=8 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- starting media recovery
- archived log for thread 1 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.392.972323287
- archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_20.262.972060893
- archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_21.261.972060939
- archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_22.263.972070275
- archived log for thread 1 with sequence 23 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_23.264.972071759
- archived log for thread 1 with sequence 24 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_24.265.972072815
- archived log for thread 1 with sequence 25 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_25.266.972072905
- archived log for thread 1 with sequence 26 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_26.267.972073043
- archived log for thread 1 with sequence 27 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_27.268.972073051
- archived log for thread 1 with sequence 28 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_28.269.972073063
- archived log for thread 1 with sequence 29 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_29.270.972079239
- archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_30.271.972079311
- archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2018_03_29/thread_1_seq_31.272.972079365
- archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_32.273.972119851
- archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_33.274.972120503
- archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_34.275.972126049
- archived log for thread 1 with sequence 35 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_35.276.972134249
- archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_36.277.972142677
- archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_37.278.972161139
- archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_38.279.972162905
- archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_39.280.972165649
- archived log for thread 1 with sequence 40 is already on disk as file +FRA/orcl/archivelog/2018_03_30/thread_1_seq_40.281.972166117
- archived log for thread 1 with sequence 41 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_41.282.972206295
- archived log for thread 1 with sequence 42 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_42.283.972208237
- archived log for thread 1 with sequence 43 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_43.284.972212455
- archived log for thread 1 with sequence 44 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_44.285.972224729
- archived log for thread 1 with sequence 45 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_45.286.972231635
- archived log for thread 1 with sequence 46 is already on disk as file +FRA/orcl/archivelog/2018_03_31/thread_1_seq_46.287.972237931
- archived log for thread 1 with sequence 47 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.288.972292287
- archived log for thread 1 with sequence 48 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.289.972292375
- archived log for thread 1 with sequence 49 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_49.290.972292459
- archived log for thread 1 with sequence 50 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_50.291.972293883
- archived log for thread 1 with sequence 51 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_51.292.972293981
- archived log for thread 1 with sequence 52 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_52.293.972294939
- archived log for thread 1 with sequence 53 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_53.295.972298807
- archived log for thread 1 with sequence 54 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_54.297.972306021
- archived log for thread 1 with sequence 55 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_55.299.972307191
- archived log for thread 1 with sequence 56 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_56.301.972309643
- archived log for thread 1 with sequence 57 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_57.302.972313083
- archived log for thread 1 with sequence 58 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_58.303.972313083
- archived log for thread 1 with sequence 59 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_59.304.972313093
- archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.318.972317853
- archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.319.972317855
- archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.320.972317859
- archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.321.972317859
- archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.322.972317861
- archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.323.972317861
- archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.324.972317863
- archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.325.972317863
- archived log for thread 1 with sequence 9 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.326.972317865
- archived log for thread 1 with sequence 10 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.327.972317865
- archived log for thread 1 with sequence 11 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.328.972317865
- archived log for thread 1 with sequence 12 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.329.972317865
- archived log for thread 1 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.330.972317867
- archived log for thread 1 with sequence 14 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.331.972317871
- archived log for thread 1 with sequence 15 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.332.972317873
- archived log for thread 1 with sequence 16 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.333.972317873
- archived log for thread 1 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.334.972317875
- archived log for thread 1 with sequence 18 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_18.335.972317875
- archived log for thread 1 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.336.972317877
- archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_20.337.972317879
- archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_21.338.972317879
- archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_22.339.972317879
- archived log for thread 1 with sequence 23 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_23.340.972317881
- archived log for thread 1 with sequence 24 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_24.341.972317883
- archived log for thread 1 with sequence 25 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_25.342.972317885
- archived log for thread 1 with sequence 26 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_26.343.972317885
- archived log for thread 1 with sequence 27 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_27.344.972317889
- archived log for thread 1 with sequence 28 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_28.345.972317889
- archived log for thread 1 with sequence 29 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_29.346.972317895
- archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_30.347.972317895
- archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_31.348.972317897
- archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_32.349.972317901
- archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_33.350.972317901
- archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_34.351.972317903
- archived log for thread 1 with sequence 35 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_35.352.972317903
- archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_36.353.972317905
- archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_37.354.972317907
- archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_38.355.972317909
- archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_39.356.972317913
- archived log for thread 1 with sequence 40 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_40.357.972317915
- archived log for thread 1 with sequence 41 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_41.358.972317915
- archived log for thread 1 with sequence 42 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_42.359.972317917
- archived log for thread 1 with sequence 43 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_43.360.972317919
- archived log for thread 1 with sequence 44 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_44.361.972318087
- archived log for thread 1 with sequence 45 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_45.362.972318089
- archived log for thread 1 with sequence 46 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_46.363.972318099
- archived log for thread 1 with sequence 47 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.364.972318103
- archived log for thread 1 with sequence 48 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.369.972319355
- archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.374.972321509
- archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.375.972321511
- archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.376.972321513
- archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.377.972321515
- archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.378.972321519
- archived log for thread 1 with sequence 6 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.379.972321519
- archived log for thread 1 with sequence 7 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.380.972321521
- archived log for thread 1 with sequence 8 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.381.972321523
- archived log for thread 1 with sequence 9 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.382.972321525
- archived log for thread 1 with sequence 10 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.383.972321527
- archived log for thread 1 with sequence 11 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.384.972321529
- archived log for thread 1 with sequence 12 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.385.972321531
- archived log for thread 1 with sequence 13 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.386.972321535
- archived log for thread 1 with sequence 14 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.387.972321537
- archived log for thread 1 with sequence 15 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.388.972321815
- archived log for thread 1 with sequence 16 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.389.972321817
- archived log for thread 1 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.391.972321827
- archived log for thread 1 with sequence 1 is already on disk as file +DATA/orcl/onlinelog/group_1.261.816169635
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.392.972323287 thread=1 sequence=19
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_20.262.972060893 thread=1 sequence=20
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_21.261.972060939 thread=1 sequence=21
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_22.263.972070275 thread=1 sequence=22
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_23.264.972071759 thread=1 sequence=23
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_24.265.972072815 thread=1 sequence=24
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_25.266.972072905 thread=1 sequence=25
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_26.267.972073043 thread=1 sequence=26
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_27.268.972073051 thread=1 sequence=27
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_28.269.972073063 thread=1 sequence=28
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_29.270.972079239 thread=1 sequence=29
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_30.271.972079311 thread=1 sequence=30
- archived log file name=+FRA/orcl/archivelog/2018_03_29/thread_1_seq_31.272.972079365 thread=1 sequence=31
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_32.273.972119851 thread=1 sequence=32
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_33.274.972120503 thread=1 sequence=33
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_34.275.972126049 thread=1 sequence=34
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_35.276.972134249 thread=1 sequence=35
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_36.277.972142677 thread=1 sequence=36
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_37.278.972161139 thread=1 sequence=37
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_38.279.972162905 thread=1 sequence=38
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_39.280.972165649 thread=1 sequence=39
- archived log file name=+FRA/orcl/archivelog/2018_03_30/thread_1_seq_40.281.972166117 thread=1 sequence=40
- archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_41.282.972206295 thread=1 sequence=41
- archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_42.283.972208237 thread=1 sequence=42
- archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_43.284.972212455 thread=1 sequence=43
- archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_44.285.972224729 thread=1 sequence=44
- archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_45.286.972231635 thread=1 sequence=45
- archived log file name=+FRA/orcl/archivelog/2018_03_31/thread_1_seq_46.287.972237931 thread=1 sequence=46
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.288.972292287 thread=1 sequence=47
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.289.972292375 thread=1 sequence=48
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_49.290.972292459 thread=1 sequence=49
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_50.291.972293883 thread=1 sequence=50
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_51.292.972293981 thread=1 sequence=51
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_52.293.972294939 thread=1 sequence=52
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_53.295.972298807 thread=1 sequence=53
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_54.297.972306021 thread=1 sequence=54
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_55.299.972307191 thread=1 sequence=55
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_56.301.972309643 thread=1 sequence=56
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_57.302.972313083 thread=1 sequence=57
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_58.303.972313083 thread=1 sequence=58
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_59.304.972313093 thread=1 sequence=59
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.318.972317853 thread=1 sequence=1
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.319.972317855 thread=1 sequence=2
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.320.972317859 thread=1 sequence=3
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.321.972317859 thread=1 sequence=4
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.322.972317861 thread=1 sequence=5
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.323.972317861 thread=1 sequence=6
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.324.972317863 thread=1 sequence=7
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.325.972317863 thread=1 sequence=8
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.326.972317865 thread=1 sequence=9
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.327.972317865 thread=1 sequence=10
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.328.972317865 thread=1 sequence=11
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.329.972317865 thread=1 sequence=12
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.330.972317867 thread=1 sequence=13
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.331.972317871 thread=1 sequence=14
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.332.972317873 thread=1 sequence=15
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.333.972317873 thread=1 sequence=16
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.334.972317875 thread=1 sequence=17
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_18.335.972317875 thread=1 sequence=18
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_19.336.972317877 thread=1 sequence=19
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_20.337.972317879 thread=1 sequence=20
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_21.338.972317879 thread=1 sequence=21
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_22.339.972317879 thread=1 sequence=22
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_23.340.972317881 thread=1 sequence=23
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_24.341.972317883 thread=1 sequence=24
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_25.342.972317885 thread=1 sequence=25
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_26.343.972317885 thread=1 sequence=26
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_27.344.972317889 thread=1 sequence=27
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_28.345.972317889 thread=1 sequence=28
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_29.346.972317895 thread=1 sequence=29
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_30.347.972317895 thread=1 sequence=30
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_31.348.972317897 thread=1 sequence=31
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_32.349.972317901 thread=1 sequence=32
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_33.350.972317901 thread=1 sequence=33
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_34.351.972317903 thread=1 sequence=34
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_35.352.972317903 thread=1 sequence=35
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_36.353.972317905 thread=1 sequence=36
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_37.354.972317907 thread=1 sequence=37
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_38.355.972317909 thread=1 sequence=38
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_39.356.972317913 thread=1 sequence=39
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_40.357.972317915 thread=1 sequence=40
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_41.358.972317915 thread=1 sequence=41
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_42.359.972317917 thread=1 sequence=42
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_43.360.972317919 thread=1 sequence=43
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_44.361.972318087 thread=1 sequence=44
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_45.362.972318089 thread=1 sequence=45
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_46.363.972318099 thread=1 sequence=46
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_47.364.972318103 thread=1 sequence=47
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_48.369.972319355 thread=1 sequence=48
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_1.374.972321509 thread=1 sequence=1
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_2.375.972321511 thread=1 sequence=2
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_3.376.972321513 thread=1 sequence=3
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_4.377.972321515 thread=1 sequence=4
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_5.378.972321519 thread=1 sequence=5
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_6.379.972321519 thread=1 sequence=6
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_7.380.972321521 thread=1 sequence=7
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_8.381.972321523 thread=1 sequence=8
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_9.382.972321525 thread=1 sequence=9
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_10.383.972321527 thread=1 sequence=10
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_11.384.972321529 thread=1 sequence=11
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_12.385.972321531 thread=1 sequence=12
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_13.386.972321535 thread=1 sequence=13
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_14.387.972321537 thread=1 sequence=14
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_15.388.972321815 thread=1 sequence=15
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_16.389.972321817 thread=1 sequence=16
- archived log file name=+FRA/orcl/archivelog/2018_04_01/thread_1_seq_17.391.972321827 thread=1 sequence=17
- media recovery complete, elapsed time: 00:00:22
- Finished recover at 02-APR-18
- RMAN> alter database open resetlogs;
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of alter db command at 04/02/2018 19:57:28
- ORA-01139: RESETLOGS option only valid after an incomplete database recovery
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 2 19:57:39 2018
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> alter database open ;
- Database altered.
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 2 19:58:08 2018
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> list incarnation of database;
- using target database control file instead of recovery catalog
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 1 ORCL 1343950367 PARENT 1 15-AUG-09
- 2 2 ORCL 1343950367 PARENT 945184 23-MAY-13
- 3 3 ORCL 1343950367 ORPHAN 1451975 01-APR-18
- 4 4 ORCL 1343950367 PARENT 1451975 01-APR-18
- 5 5 ORCL 1343950367 ORPHAN 1456352 01-APR-18
- 6 6 ORCL 1343950367 PARENT 1456361 01-APR-18
- 7 7 ORCL 1343950367 ORPHAN 1464173 01-APR-18
- 8 8 ORCL 1343950367 CURRENT 1464173 02-APR-18
- RMAN>
复制代码- select * from v$restore_point;
- create restore point rsp1 ;
- create restore point rsp2 as of scn 1000000;
- create restore point rsp3
- guarantee flashback database;
-
- select * from v$flashback_database_log;
复制代码
|
|