|
|
本帖最后由 botang 于 2016-12-15 16:21 编辑
上完1Z0-053第12章（闪回数据库与不完全恢复的对比）
（052共19章，053共21章，063多租户共9章，49-15）
闪回数据库和不完全恢复的对比：
[code][root@station90 桌面]# su - oracle
[oracle@station90 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Dec 14 20:26:59 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1343950367, not open)
RMAN> list backup of database ;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Incr 0 69.06M SBT_TAPE 00:00:20 20-OCT-13
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: 1T_WHOLE_INCR0
Handle: 05omt45l_1_1 Media: station90-000010
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 0 Incr 1041758 20-OCT-13 +DATA/orcl/datafile/example.265.816169651
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Incr 0 588.69M SBT_TAPE 00:00:40 20-OCT-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: 1T_WHOLE_INCR0
Handle: 02omt45k_1_1 Media: station90-000009
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 1041748 20-OCT-13 +DATA/orcl/datafile/system.256.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Incr 0 3.31M SBT_TAPE 00:00:55 20-OCT-13
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: 1T_WHOLE_INCR0
Handle: 06omt45l_1_1 Media: station90-000009
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 0 Incr 1041761 20-OCT-13 +DATA/orcl/datafile/users.259.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Incr 0 380.38M SBT_TAPE 00:01:08 20-OCT-13
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: 1T_WHOLE_INCR0
Handle: 03omt45k_1_1 Media: station90-000010
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 0 Incr 1041751 20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Incr 0 94.69M SBT_TAPE 00:01:22 20-OCT-13
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: 1T_WHOLE_INCR0
Handle: 04omt45k_1_1 Media: station90-000009
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 0 Incr 1041755 20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Incr 1 128.00K SBT_TAPE 00:00:16 20-OCT-13
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: 2T_WHOLE_INCR1
Handle: 0aomt4ce_1_1 Media: station90-000009
List of Datafiles in backup set 10
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 1042472 20-OCT-13 +DATA/orcl/datafile/system.256.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Incr 1 1.50M SBT_TAPE 00:00:16 20-OCT-13
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: 2T_WHOLE_INCR1
Handle: 0comt4ce_1_1 Media: station90-000010
List of Datafiles in backup set 11
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 1 Incr 1042478 20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Incr 1 64.00K SBT_TAPE 00:00:35 20-OCT-13
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: 2T_WHOLE_INCR1
Handle: 0eomt4ce_1_1 Media: station90-000010
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 1 Incr 1042484 20-OCT-13 +DATA/orcl/datafile/users.259.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13 Incr 1 64.00K SBT_TAPE 00:00:41 20-OCT-13
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: 2T_WHOLE_INCR1
Handle: 0domt4ce_1_1 Media: station90-000009
List of Datafiles in backup set 13
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 1 Incr 1042481 20-OCT-13 +DATA/orcl/datafile/example.265.816169651
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14 Incr 1 7.44M SBT_TAPE 00:00:57 20-OCT-13
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: 2T_WHOLE_INCR1
Handle: 0bomt4ce_1_1 Media: station90-000010
List of Datafiles in backup set 14
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 1 Incr 1042475 20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Incr 1 128.00K SBT_TAPE 00:00:15 20-OCT-13
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: 3TCUMU_WHOLE_INCR1
Handle: 0iomt4hq_1_1 Media: station90-000009
List of Datafiles in backup set 18
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 1042619 20-OCT-13 +DATA/orcl/datafile/system.256.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19 Incr 1 7.44M SBT_TAPE 00:00:24 20-OCT-13
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: 3TCUMU_WHOLE_INCR1
Handle: 0jomt4hq_1_1 Media: station90-000010
List of Datafiles in backup set 19
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 1 Incr 1042622 20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20 Incr 1 1.50M SBT_TAPE 00:00:39 20-OCT-13
BP Key: 20 Status: AVAILABLE Compressed: NO Tag: 3TCUMU_WHOLE_INCR1
Handle: 0komt4hq_1_1 Media: station90-000010
List of Datafiles in backup set 20
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 1 Incr 1042625 20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21 Incr 1 64.00K SBT_TAPE 00:00:40 20-OCT-13
BP Key: 21 Status: AVAILABLE Compressed: NO Tag: 3TCUMU_WHOLE_INCR1
Handle: 0lomt4hq_1_1 Media: station90-000009
List of Datafiles in backup set 21
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 1 Incr 1042629 20-OCT-13 +DATA/orcl/datafile/example.265.816169651
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22 Incr 1 64.00K SBT_TAPE 00:00:53 20-OCT-13
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: 3TCUMU_WHOLE_INCR1
Handle: 0momt4hr_1_1 Media: station90-000010
List of Datafiles in backup set 22
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 1 Incr 1042632 20-OCT-13 +DATA/orcl/datafile/users.259.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Full 3.50M SBT_TAPE 00:00:24 12-DEC-16
BP Key: 27 Status: AVAILABLE Compressed: NO Tag: 4T_WHOLE_INCR0
Handle: 0vrn9uvi_1_1 Media: station90-000010
List of Datafiles in backup set 27
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1051009 12-DEC-16 +DATA/orcl/datafile/users.259.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
28 Full 588.75M SBT_TAPE 00:01:04 12-DEC-16
BP Key: 28 Status: AVAILABLE Compressed: NO Tag: 4T_WHOLE_INCR0
Handle: 0rrn9uvh_1_1 Media: station90-000009
List of Datafiles in backup set 28
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1051009 12-DEC-16 +DATA/orcl/datafile/system.256.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29 Full 98.25M SBT_TAPE 00:01:23 12-DEC-16
BP Key: 29 Status: AVAILABLE Compressed: NO Tag: 4T_WHOLE_INCR0
Handle: 0trn9uvh_1_1 Media: station90-000009
List of Datafiles in backup set 29
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 1051009 12-DEC-16 +DATA/orcl/datafile/undotbs1.258.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
30 Full 393.00M SBT_TAPE 00:01:40 12-DEC-16
BP Key: 30 Status: AVAILABLE Compressed: NO Tag: 4T_WHOLE_INCR0
Handle: 0srn9uvh_1_1 Media: station90-000010
List of Datafiles in backup set 30
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1051009 12-DEC-16 +DATA/orcl/datafile/sysaux.257.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
31 Full 69.25M SBT_TAPE 00:01:59 12-DEC-16
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: 4T_WHOLE_INCR0
Handle: 0urn9uvi_1_1 Media: station90-000009
List of Datafiles in backup set 31
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1051009 12-DEC-16 +DATA/orcl/datafile/example.265.816169651
RMAN>
RMAN> crosscheck backupset 30,31;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=192 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=8 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=69 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=132 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=193 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=9 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=70 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=133 device type=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=194 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=71 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=195 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=72 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=196 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=73 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=197 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=74 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0srn9uvh_1_1 RECID=30 STAMP=930413553
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0urn9uvi_1_1 RECID=31 STAMP=930413554
Crosschecked 2 objects
RMAN> run {
2> sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
3> set until time '2016-12-14:20:13:01';
4> restore database;
5> recover database;
6> }
sql statement: alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''
executing command: SET until clause
Starting restore at 14-DEC-16
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
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
flashing back control file to SCN 1081648
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 00004 to +DATA/orcl/datafile/users.259.816169553
channel ORA_SBT_TAPE_1: reading from backup piece 0vrn9uvi_1_1
channel ORA_SBT_TAPE_2: starting datafile backup set restore
channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_2: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
channel ORA_SBT_TAPE_2: reading from backup piece 0rrn9uvh_1_1
channel ORA_SBT_TAPE_1: piece handle=0vrn9uvi_1_1 tag=4T_WHOLE_INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:52
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 00002 to +DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_1: reading from backup piece 0srn9uvh_1_1
channel ORA_SBT_TAPE_2: piece handle=0rrn9uvh_1_1 tag=4T_WHOLE_INCR0
channel ORA_SBT_TAPE_2: restored backup piece 1
channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:01:08
channel ORA_SBT_TAPE_2: starting datafile backup set restore
channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_2: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_2: reading from backup piece 0trn9uvh_1_1
channel ORA_SBT_TAPE_2: piece handle=0trn9uvh_1_1 tag=4T_WHOLE_INCR0
channel ORA_SBT_TAPE_2: restored backup piece 1
channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_2: starting datafile backup set restore
channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_2: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
channel ORA_SBT_TAPE_2: reading from backup piece 0urn9uvi_1_1
channel ORA_SBT_TAPE_1: piece handle=0srn9uvh_1_1 tag=4T_WHOLE_INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:03
channel ORA_SBT_TAPE_2: piece handle=0urn9uvi_1_1 tag=4T_WHOLE_INCR0
channel ORA_SBT_TAPE_2: restored backup piece 1
channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:55
Finished restore at 14-DEC-16
Starting recover at 14-DEC-16
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
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
starting media recovery
archived log for thread 1 with sequence 17 is already on disk as file +FRA/orcl/archivelog/2016_12_14/thread_1_seq_17.262.930589325
archived log for thread 1 with sequence 18 is already on disk as file +FRA/orcl/archivelog/2016_12_14/thread_1_seq_18.261.930589515
archived log for thread 1 with sequence 19 is already on disk as file +FRA/orcl/archivelog/2016_12_14/thread_1_seq_19.263.930590849
archived log for thread 1 with sequence 20 is already on disk as file +FRA/orcl/archivelog/2016_12_14/thread_1_seq_20.266.930600777
archived log for thread 1 with sequence 21 is already on disk as file +FRA/orcl/archivelog/2016_12_14/thread_1_seq_21.267.930600777
archived log for thread 1 with sequence 22 is already on disk as file +FRA/orcl/archivelog/2016_12_14/thread_1_seq_22.268.930600787
archived log file name=+FRA/orcl/archivelog/2016_12_14/thread_1_seq_17.262.930589325 thread=1 sequence=17
archived log file name=+FRA/orcl/archivelog/2016_12_14/thread_1_seq_18.261.930589515 thread=1 sequence=18
archived log file name=+FRA/orcl/archivelog/2016_12_14/thread_1_seq_19.263.930590849 thread=1 sequence=19
archived log file name=+FRA/orcl/archivelog/2016_12_14/thread_1_seq_20.266.930600777 thread=1 sequence=20
archived log file name=+FRA/orcl/archivelog/2016_12_14/thread_1_seq_21.267.930600777 thread=1 sequence=21
archived log file name=+FRA/orcl/archivelog/2016_12_14/thread_1_seq_22.268.930600787 thread=1 sequence=22
media recovery complete, elapsed time: 00:00:02
Finished recover at 14-DEC-16
RMAN> list incarnation of database ;
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 CURRENT 945184 23-MAY-13
RMAN> alter database open ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 12/14/2016 20:46:57
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> alter database open resetlogs;
database opened
RMAN> list incarnation of database ;
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 CURRENT 1081654 14-DEC-16
RMAN> list incarnation of database ;
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-03135: connection lost contact
Process ID: 9237
Session ID: 68 Serial number: 31
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-04022: target database mount id 1458342401 does not match channel's mount id 1458337747
RMAN-03002: failure of list command at 12/14/2016 21:07:52
ORA-03114: not connected to ORACLE
[oracle@station90 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Dec 14 21:07:54 2016
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 1081654 14-DEC-16
4 4 ORCL 1343950367 CURRENT 1081654 14-DEC-16
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 14 21:52:43 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 6680915968 bytes
Fixed Size |
|
发表于 2016-12-15 15:42:48
