ORACLE中没有参数文件和控制文件如何通过rman恢复数据库 - 数据库编程

r thread 1 is in sequence #29053 Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00279: change 10903302108 generated at 01/23/2015 03:27:09 needed for thread 1 ORA-00289: suggestion : /oracle/app/oracle/flash_recovery_area/archivelog/1_29054_821708334.dbf ORA-00280: change 10903302108 for thread 1 is in sequence #29054 ORA-00278: log file '/oracle/app/oracle/flash_recovery_area/archivelog/1_29053_821708334.dbf' no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} auto ORA-00308: cannot open archived log '/oracle/app/oracle/flash_recovery_area/archivelog/1_29054_821708334.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00308: cannot open archived log '/oracle/app/oracle/flash_recovery_area/archivelog/1_29054_821708334.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL> SQL> alter database open resetlogs; Database altered. SQL>

SQL> select to_char(a.last_login_date,'yyyy-mm-dd hh24:mi:ss') from stu.pst_ac a where to_char(a.last_login_date,'yyyy-mm-dd hh24:mi:ss')>'2015-01-23 00:00:00:00' order by to_char(a.last_login_date,'yyyy-mm-dd hh24:mi:ss') desc; TO_CHAR(A.LAST_LOGI ------------------- 2015-01-23 03:10:38 2015-01-23 02:36:13 2015-01-23 01:47:36 2015-01-23 01:29:14 2015-01-23 01:27:41 2015-01-23 01:09:21 2015-01-23 00:52:14 2015-01-23 00:44:52 2015-01-23 00:43:46 2015-01-23 00:32:37 2015-01-23 00:31:59 TO_CHAR(A.LAST_LOGI ------------------- 2015-01-23 00:30:44 2015-01-23 00:27:27 2015-01-23 00:23:20 2015-01-23 00:18:53 2015-01-23 00:17:46 2015-01-23 00:13:25 2015-01-23 00:00:15 18 rows selected. SQL>

去[oracle@xuelong4 admin]$ sqlplus elearning/plel0328@SC_SID; SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 4 19:03:56 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select ut.TABLE_NAME from user_tables ut where rownum<3;

ORACLE中没有参数文件和控制文件如何通过rman恢复数据库(三)