Problém 52:
Jak provést obnovu pomocí RMAN po čas v minulosti_Tohle by měl být součet platů, ale není.. SQL> select sum(salary) from employees;SUM(SALARY)———–691400Aktuální součet je jiný..SQL> select sum(salary) from employees;SUM(SALARY)———–679050V našem případě, jsme zjistili, že v historii změn nad tabulkou job, byla za poslední měsic provedena jedna změna.SQL> alter session set nls_date_format = “yyyy-mm-dd hh24:mi:ss”;
Session altered.SQL> select min(end_date) from job_history where end_date > sysdate – 30;MIN(END_DATE)——————-2011-06-28 10:19:42
Řešení:
Použití klauzule UNTIL TIME v RMANovi.RMAN> run {set UNTIL TIME = ‘2011-06-28 10:19:42’;RESTORE DATABASE;RECOVER DATABASE;ALTER DATABASE OPEN RESETLOGS;}executing command: SET until clauseStarting restore at 2011-06-28 10:28:11allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=157 devtype=DISKchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00001 to /u01/app/oracle/oradata/orcl/system01.dbfrestoring datafile 00002 to /u01/app/oracle/oradata/orcl/undotbs01.dbfrestoring datafile 00003 to /u01/app/oracle/oradata/orcl/sysaux01.dbfrestoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbfrestoring datafile 00005 to /u01/app/oracle/oradata/orcl/example01.dbfchannel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_06_28/o1_mf_nnndf_TAG20110628T102035_70m3pmwn_.bkpchannel ORA_DISK_1: restored backup piece 1piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_06_28/o1_mf_nnndf_TAG20110628T102035_70m3pmwn_.bkp tag=TAG20110628T102035channel ORA_DISK_1: restore complete, elapsed time: 00:00:45Finished restore at 2011-06-28 10:28:58Starting recover at 2011-06-28 10:28:58using channel ORA_DISK_1starting media recoverymedia recovery complete, elapsed time: 00:00:00Finished recover at 2011-06-28 10:28:58database openedRMAN>SQL> select sum(salary) from employees;SUM(SALARY)———–691400