???????????????????????????????????????7?????????????????????SQL??????????????????????洢???????????????
???????????????????????????????????????????漰????????????????????????
????????????????м???????????????????????????rownum?????????????????
????SQL????????????????
????select cn ????present_point ??????? ?? last_date ??????????? from test.user_present_point_sp  where  present_point > 0 and last_date < to_date('2016-10-07'??'yyyy-MM-dd')  and rownum<10;
???????????????????????????????????????????????VPN??????????????????????????Щ???????????????????????????????????????????????
??????????????????????????????????3??
???????????????????μ??????·?????????????????????????????????????????????????????????????????д????
?????????е???????
????select cn ????present_point ??????? ?? last_date ??????????? from test.user_present_point_sp  where  present_point > 0 and last_date < to_date('2016-10-07'??'yyyy-MM-dd')??
??????????????????????????????rownum<10 ???????????????9?????????????????????ü????????????????????????
??????????????????????????????????????????????????????????λ?????????????????????????ü??????
????select cn ????present_point ??????? ?? last_date ??????????? from test.user_present_point_sp as of timestamp to_timestamp('2016-10-06 08:00:00'??'yyyy-mm-dd hh24:mi:ss') where      present_point > 0 and last_date < to_date('2016-10-07'??'yyyy-MM-dd')
????*
????ERROR at line 1:
????ORA-01555: snapshot too old: rollback segment number 22 with name
????"_SYSSMU22_163011606$" too small
?????????????????????????????????????????????????????????????????????????????????а??????? ??????????????????????
?????????????????????????????????????????????????????????????????????????????????????4???????????????????????????????
???????????????????????????????????????У???μ????????????
???????????????????
????SQL> select flashback_on??database_role??open_mode from v$database;
????FLASHBACK_ON      DATABASE_ROLE    OPEN_MODE
????------------------ ---------------- --------------------
????YES                PHYSICAL STANDBY READ ONLY WITH APPLY
????????????????????????????????????????????????????
SQL> select username??count(*)from v$session group by username;
USERNAME                        COUNT(*)
------------------------------ ----------
50
PUBLIC                                  5
SYS     
                            1
???????mount??Σ???????????????
????flashback database to timestamp to_timestamp('2016-10-06 07:20:00'??'yyyy-mm-dd hh24:mi:ss');
???????????????????漰?????????????????????????????????????Щ???????15??????????
Sat Oct 08 11:14:59 2016
flashback database to timestamp to_timestamp('2016-10-06 07:20:00'??'yyyy-mm-dd hh24:mi:ss')
Flashback Restore Start
Sat Oct 08 11:27:03 2016
Flashback Restore Complete
Flashback Media Recovery Start
started logmerger process
Parallel Media Recovery started with 24 slaves
Flashback Media Recovery Log /U01/app/Oracle/fast_recovery_area/SGCDB2/archivelog/2016_10_06/o1_mf_1_3696_czc0wj0f_.arc
Flashback Media Recovery Log /U01/app/oracle/fast_recovery_area/SGCDB2/archivelog/2016_10_06/o1_mf_1_3697_czc540wp_.arc
Sat Oct 08 11:27:15 2016
Incomplete Recovery applied until change 229374582017 time 10/06/2016 07:20:01
Sat Oct 08 11:27:15 2016
Flashback Media Recovery Complete
Completed:  flashback database to timestamp to_timestamp('2016-10-06 07:20:00'??'yyyy-mm-dd hh24:mi:ss')
Sat Oct 08 11:29:34 2016
??????β???????????????????????????????????????????????????????????????????????????????????????????????????????
??????????????????????????????????????ù鵵???????????????о???????????????????ж?????????????????????????????м???д???????????????????????????????????????????????????????ó??Щ?????????????????????????????????Щ??????????????????Щ???????????????????????