redo01.log恢复问题
背景: 在正常oracle11g正常open状态,我操作系统mv 了redo01.log然后rman不知道该怎么恢复。
可是通过下面的脚本居然重建了redo01.log
我不知道哪一步能重建的.
看哪个日志可以知道呢?
ps:操作过程如下:
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/redo03.log
/u01/app/oracle/oradata/orcl/redo02.log
/u01/app/oracle/oradata/orcl/redo01.log
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------------- ------------- --------- ------------ ---------
1 1 1 52428800 512 1 NO
CURRENT 1849633 23-APR-12 2.8147E+14
3 1 0 52428800 512 1 YES
UNUSED 0 0
2 1 0 52428800 512 1 YES
UNUSED 0 0
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database drop logfile member;
alter database drop logfile member
*
ERROR at line 1:
ORA-02236: invalid file name
SQL> alter database drop logfile 1;
alter database drop logfile 1
*
ERROR at line 1:
ORA-02236: invalid file name
SQL> alter database drop logfile member 1
2 ;
alter database drop logfile member 1
*
ERROR at line 1:
ORA-02236: invalid file name
SQL> archive log start ;
Statement processed.
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
SQL> alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo01.log';
alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo01.log'
*
ERROR at line 1:
ORA-00361: cannot remove last log member
/u01/app/oracle/oradata/orcl/redo01.log for group 1
SQL> col member for a40
SQL> set linesize 1400
SQL> set linesize 140
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ---------------------------------------- ---
3 ONLINE /u01/app/oracle/oradata/orcl/redo03.log NO
2 ONLINE /u01/app/oracle/oradata/orcl/redo02.log NO
1 ONLINE /u01/app/oracle/oradata/orcl/redo01.log NO
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 1 52428800 512 1 NO CURRENT 1861350 25-APR-12 2.8147E+14
2 1 0 52428800 512 1 YES UNUSED 0 0
3 1 0 52428800 512 1 YES UNUSED 0 0
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 1 52428800 512 1 YES ACTIVE 1861350 25-APR-12 1862933 25-APR-12
2 1 2 52428800 512 1 NO CURRENT 1862933 25-APR-12 2.8147E+14
3 1 0 52428800 512 1 YES UNUSED 0 0
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 1 52428800 512 1 YES ACTIVE 1861350 25-APR-12 1862933 25-APR-12
2 1 2 52428800 512 1 YES ACTIVE 1862933 25-APR-12 1862948 25-APR-12
3 1 3 52428800 512 1 NO CURRENT 1862948 25-APR-12 2.8147E+14
SQL> !
$ cd $ORACLE_BASE;
$ cd oradata/
$ ls
orcl orcl01
$ cd orcl
$ ls
control01.ctl example01.dbf redo01.log redo02.log sysaux01.dbf tablespace2.dbf undotbs01.dbf yzz.dbf
control01.ctl20120423 example01.dbf20120423 redo01.log20120403 redo03.log system01.dbf temp01.dbf users01.dbf
$ ll
总计 1959644
-rw-r----- 1 oracle oinstall 9781248 04-25 15:28 control01.ctl
-rw-r----- 1 oracle oinstall 9781248 04-23 16:08 control01.ctl20120423
-rw-r----- 1 oracle oinstall 104865792 04-25 14:59 example01.dbf
-rw-r----- 1 oracle oinstall 104865792 04-23 16:48 example01.dbf20120423
-rw-r----- 1 oracle oinstall 52429312 04-25 15:27 redo01.log---------已重建,但是不知道哪里重建的。
-rw-r----- 1 oracle oinstall 52429312 04-24 16:02 redo01.log20120403
-rw-r----- 1 oracle oinstall 52429312 04-25 15:27 redo02.log
-rw-r----- 1 oracle oinstall 52429312 04-25 15:28 redo03.log
-rw-r----- 1 oracle oinstall 692068352 04-25 15:23 sysaux01.dbf
-rw-r----- 1 oracle oinstall 734011392 04-25 15:23 system01.dbf
-rw-r----- 1 oracle oinstall 10493952 04-25 14:59 tablespace2.dbf
-rw-r----- 1 oracle oinstall 20979712 04-25 15:01 temp01.dbf
-rw-r----- 1 oracle oinstall 104865792 04-25 15:23 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 04-25 14:59 users01.dbf
-rw-r----- 1 oracle oinstall 10493952 04-25 14:59 yzz.dbf
$ ecit
bash: ecit: command not found
$ exit
exit
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter database open;
alter database open
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> shutdown
页:
[1]