第2次活动：2017-07-16（星期日晚上7:00-10:00）

botang · 发表于 2017-7-15 16:25:39

第二次活动：2017-07-16（星期日晚上7:00-10:00）

select d.FLASHBACK_ON
from v_$database d;
select * from v$database_incarnation;
alter database flashback on;
select * from v$flashback_database_log;
select * from v$flashback_database_stat;
---------------
select * from v$restore_point;
select current_scn from v$database;
create restore point before_patch ;

复制代码

---------------------------------------------- LAB 5 ----------------------------------------------
5_基于时间的不完全恢复
---------------------------------------------- LAB 5 ----------------------------------------------
******************
你的主机信息如下：
******************
192.168.1.90
station90.example.com
Linux station90.example.com 2.6.32-696.el6.x86_64 #1 SMP Tue Feb 21 00:53:17 EST 2017 x86_64 x86_64 x86_64 GNU/Linux
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 16 20:44:03 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> SQL>
A
--------------------
Botang
****************************
The database open mode here:
****************************
D
-
X
OPEN_MODE
--------------------
READ WRITE
**********************************
The database archivelog mode here:
**********************************
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 29
Next log sequence to archive 31
Current log sequence 31
***************************
The database datafile here:
***************************
TABLESPACE_NAME STATUS
------------------------------ ---------------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
NAME STATUS
----------------------------------------------------------------- ---------------
+DATA/orcl/datafile/system.256.816169553 SYSTEM
+DATA/orcl/datafile/sysaux.257.816169553 ONLINE
+DATA/orcl/datafile/undotbs1.258.816169553 ONLINE
+DATA/orcl/datafile/users.259.816169553 ONLINE
+DATA/orcl/datafile/example.265.816169651 ONLINE
******************************
The database controlfile here:
******************************
NAME
-----------------------------------------------------------------
+DATA/orcl/controlfile/current.260.816169631
+FRA/orcl/controlfile/current.256.816169633
**************************
The database logfile here:
**************************
MEMBER
--------------------------------------------------------------------------------
+DATA/orcl/onlinelog/group_3.263.816169641
+FRA/orcl/onlinelog/group_3.259.816169641
+DATA/orcl/onlinelog/group_2.262.816169639
+FRA/orcl/onlinelog/group_2.258.816169639
+DATA/orcl/onlinelog/group_1.261.816169635
+FRA/orcl/onlinelog/group_1.257.816169637
SQL> 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
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 16 20:44:03 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> SQL>
A
--------------------
Botang
**************************
Table successfully created.
**************************
A
----------
1
********************************************************************************
**************************
After the displayed moment, the table will continuously be inserted with more
rows, but finnally be droped.
********************************************************************************
**************************
SYSDATE
-------------------
2017-07-16:20:44:09
A
----------
1
2
3
4
5
SQL> 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
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 16 20:44:21 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> SQL>
A
--------------------
Botang
****************************
The destory take place here:
****************************
SQL> 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
THE END

复制代码

---------------------------------------------- LAB 6a ----------------------------------------------
6a_基于log序列号的不完全恢复
---------------------------------------------- LAB 6a ----------------------------------------------
******************
你的主机信息如下：
******************
192.168.1.90
station90.example.com
Linux station90.example.com 2.6.32-696.el6.x86_64 #1 SMP Tue Feb 21 00:53:17 EST 2017 x86_64 x86_64 x86_64 GNU/Linux
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station90
ora.FRA.dg ora....up.type ONLINE ONLINE station90
ora....ER.lsnr ora....er.type ONLINE ONLINE station90
ora.asm ora.asm.type ONLINE ONLINE station90
ora.cssd ora.cssd.type ONLINE ONLINE station90
ora.diskmon ora....on.type ONLINE ONLINE station90
ora.orcl.db ora....se.type ONLINE ONLINE station90
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 16 21:44:41 2017
SQL> Connected.
SQL> SQL> SQL>
A
--------------------
Botang
****************************
The database open mode here:
****************************
D
-
X
OPEN_MODE
--------------------
READ WRITE
**********************************
The database archivelog mode here:
**********************************
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 9
Next log sequence to archive 11
Current log sequence 11
***************************
The database datafile here:
***************************
TABLESPACE_NAME STATUS
------------------------------ ---------------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
NAME STATUS
----------------------------------------------------------------- ---------------
+DATA/orcl/datafile/system.256.816169553 SYSTEM
+DATA/orcl/datafile/sysaux.257.816169553 ONLINE
+DATA/orcl/datafile/undotbs1.258.816169553 ONLINE
+DATA/orcl/datafile/users.259.816169553 ONLINE
+DATA/orcl/datafile/example.265.816169651 ONLINE
******************************
The database controlfile here:
******************************
NAME
-----------------------------------------------------------------
+DATA/orcl/controlfile/current.260.816169631
+FRA/orcl/controlfile/current.256.816169633
**************************
The database logfile here:
**************************
MEMBER
--------------------------------------------------------------------------------
+DATA/orcl/onlinelog/group_3.263.816169641
+FRA/orcl/onlinelog/group_3.259.816169641
+DATA/orcl/onlinelog/group_2.262.816169639
+FRA/orcl/onlinelog/group_2.258.816169639
+DATA/orcl/onlinelog/group_1.261.816169635
+FRA/orcl/onlinelog/group_1.257.816169637
SQL> 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
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 16 21:44:41 2017
SQL> Connected.
SQL> SQL> SQL>
A
--------------------
Botang
**************************
Table successfully created.
**************************
A
----------
1
********************************************************************************
***************************
After the displayed moment, the table will continuously be inserted with more
rows, but finnally be droped..
********************************************************************************
***************************
THREAD# SEQUENCE#
---------- ----------
1 13
1 11
1 12
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 11
Next log sequence to archive 13
Current log sequence 13
A
----------
1
2
3
4
5
SQL> 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
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 16 21:44:57 2017
SQL> Connected.
SQL> SQL> SQL>
A
--------------------
Botang
****************************
The destory take place here:
****************************
SQL> 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
THE END

复制代码