SYS @ orcl2 > recover datafile 5; ORA-00279: change 1398211 generated at 10/12/2023 17:19:51 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/flash_recovery_area/ORCL2/archivelog/2023_10_12/o1_mf_1_43_llhc7 kwj_.arc ORA-00280: change 1398211 for thread 1 is in sequence #43
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1398475 generated at 10/12/2023 17:23:13 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/flash_recovery_area/ORCL2/archivelog/2023_10_12/o1_mf_1_44_llhc7 mb4_.arc ORA-00280: change 1398475 for thread 1 is in sequence #44
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1398478 generated at 10/12/2023 17:23:14 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/flash_recovery_area/ORCL2/archivelog/2023_10_12/o1_mf_1_45_llhc7 n44_.arc ORA-00280: change 1398478 for thread 1 is in sequence #45 ...
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1459431 generated at 10/12/2023 17:48:04 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/flash_recovery_area/ORCL2/archivelog/2023_10_12/o1_mf_1_52_llhdz jtz_.arc ORA-00280: change 1459431 for thread 1 is in sequence #52
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Log applied. Media recovery complete.
SYS @ orcl2 > alter database open;
Database altered.
SYS @ orcl2 > conn scott/tiger Connected. SCOTT @ orcl2 > SCOTT @ orcl2 > SCOTT @ orcl2 > select * from emp908 ;
EMPNO ENAME JOB MGR HIREDATE SAL ---------- ---------- --------- ---------- ------------------- ---------- COMM DEPTNO ---------- ---------- 7839 KING PRESIDENT 1981/11/17:00:00:00 5000 10
7698 BLAKE MANAGER 7839 1981/05/01:00:00:00 2850 30
7782 CLARK MANAGER 7839 1981/05/09:00:00:00 2450 10
EMPNO ENAME JOB MGR HIREDATE SAL ---------- ---------- --------- ---------- ------------------- ---------- COMM DEPTNO ---------- ---------- 7566 JONES MANAGER 7839 1981/04/01:00:00:00 2975 20
7654 MARTIN SALESMAN 7698 1981/09/10:00:00:00 1250 1400 30
7499 ALLEN SALESMAN 7698 1981/02/11:00:00:00 1600 300 30
EMPNO ENAME JOB MGR HIREDATE SAL ---------- ---------- --------- ---------- ------------------- ---------- COMM DEPTNO ---------- ---------- 7844 TURNER SALESMAN 7698 1981/08/21:00:00:00 1500 0 30
7900 JAMES CLERK 7698 1981/12/11:00:00:00 950 30
7521 WARD SALESMAN 7698 1981/02/23:00:00:00 1250 500 30
EMPNO ENAME JOB MGR HIREDATE SAL ---------- ---------- --------- ---------- ------------------- ---------- COMM DEPTNO ---------- ---------- 7902 FORD ANALYST 7566 1981/12/11:00:00:00 3000 20
7369 SMITH CLERK 7902 1980/12/09:00:00:00 800 20
7788 SCOTT ANALYST 7566 1982/12/22:00:00:00 3000 20
EMPNO ENAME JOB MGR HIREDATE SAL ---------- ---------- --------- ---------- ------------------- ---------- COMM DEPTNO ---------- ---------- 7876 ADAMS CLERK 7788 1983/01/15:00:00:00 1100 20
7934 MILLER CLERK 7782 1982/01/11:00:00:00 1300 10
14 rows selected.
SCOTT @ orcl2 >
|