SYS@orclnew AS SYSDBA>select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
2 UNUSED
3 CURRENT
SYS@orclnew AS SYSDBA>select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
2 UNUSED
3 CURRENT
SYS@orclnew AS SYSDBA>alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-00316: log of thread , type in header is not log file
SYS@orclnew AS SYSDBA>select * from v$instance;
ERROR:
ORA-03114: not connected to ORACLE
SYS@orclnew AS SYSDBA>shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SYS@orclnew AS SYSDBA>exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\Documents and Settings\sphilip>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 17 09:21:34 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SYS@orclnew AS SYSDBA>startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1253072 bytes
Variable Size 339738928 bytes
Database Buffers 725614592 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A.LOG'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 104835887)
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 104841780)
SYS@orclnew AS SYSDBA>alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01623: log 3 is current log for instance orclnew (thread 1) - cannot drop
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A.LOG'
SYS@orclnew AS SYSDBA>alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open
SYS@orclnew AS SYSDBA>select group#,status,sequence# from v$log;
GROUP# STATUS SEQUENCE#
---------- ---------------- ----------
1 UNUSED 0
3 CURRENT 1
2 UNUSED 0
SYS@orclnew AS SYSDBA>alter database drop logfile member 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG';
alter database drop logfile member 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
*
ERROR at line 1:
ORA-01609: log 3 is the current log for thread 1 - cannot drop members
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A.LOG'
SYS@orclnew AS SYSDBA>alter system archive log;
alter system archive log
*
ERROR at line 1:
ORA-01974: Illegal archive option
SYS@orclnew AS SYSDBA>alter system archive logfile;
alter system archive logfile
*
ERROR at line 1:
ORA-02000: missing LOG keyword
SYS@orclnew AS SYSDBA>alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-01109: database not open
SYS@orclnew AS SYSDBA>alter system archive log all;
alter system archive log all
*
ERROR at line 1:
ORA-00271: there are no logs that need archiving
SYS@orclnew AS SYSDBA>alter database clear logfile group 3;
alter database clear logfile group 3
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of instance orclnew (thread 1)
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A.LOG'
SYS@orclnew AS SYSDBA>alter database clear unarchived logfile group 3;
alter database clear unarchived logfile group 3
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of instance orclnew (thread 1)
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3B.LOG'
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO3A.LOG'
SYS@orclnew AS SYSDBA>recover database until cancel;
ORA-00279: change 9860070 generated at 04/16/2009 12:13:27 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00001_0684331970.001
ORA-00280: change 9860070 for thread 1 is in sequence #1
Specify log: {
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
ORA-01112: media recovery not started
SYS@orclnew AS SYSDBA>select group#, status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
3 CURRENT
2 UNUSED
SYS@orclnew AS SYSDBA>alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\SYSTEM01.DBF'
SYS@orclnew AS SYSDBA>desc v$datafile
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
UNRECOVERABLE_CHANGE# NUMBER
UNRECOVERABLE_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(513)
PLUGGED_IN NUMBER
BLOCK1_OFFSET NUMBER
AUX_NAME VARCHAR2(513)
FIRST_NONLOGGED_SCN NUMBER
FIRST_NONLOGGED_TIME DATE
SYS@orclnew AS SYSDBA>select distinct(checkpoint_change#), checkpoint_time from v$datafile;
CHECKPOINT_CHANGE# CHECKPOIN
------------------ ---------
9860070 16-APR-09
SYS@orclnew AS SYSDBA>select distinct(checkpoint_change#),to_char(checkpoint_time,'dd-MON-yy hh24:mi:ss') from v$datafile;
CHECKPOINT_CHANGE# TO_CHAR(CHECKPOINT
------------------ ------------------
9860070 16-APR-09 12:13:27
SYS@orclnew AS SYSDBA>desc v$archived_log
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
NAME VARCHAR2(513)
DEST_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
RESETLOGS_ID NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE
BLOCKS NUMBER
BLOCK_SIZE NUMBER
CREATOR VARCHAR2(7)
REGISTRAR VARCHAR2(7)
STANDBY_DEST VARCHAR2(3)
ARCHIVED VARCHAR2(3)
APPLIED VARCHAR2(3)
DELETED VARCHAR2(3)
STATUS VARCHAR2(1)
COMPLETION_TIME DATE
DICTIONARY_BEGIN VARCHAR2(3)
DICTIONARY_END VARCHAR2(3)
END_OF_REDO VARCHAR2(3)
BACKUP_COUNT NUMBER
ARCHIVAL_THREAD# NUMBER
ACTIVATION# NUMBER
IS_RECOVERY_DEST_FILE VARCHAR2(3)
COMPRESSED VARCHAR2(3)
FAL VARCHAR2(3)
END_OF_REDO_TYPE VARCHAR2(10)
SYS@orclnew AS SYSDBA>column name format A90
SYS@orclnew AS SYSDBA>set lines 1000
select name, first_change#, to_char(first_time,'dd-MON-yy hh24:mi:ss'), next_change#,to_char(next_time,'dd-MON-yy hh24:mi:ss') from v$archived_log
/
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00005_0683717387.001 9555080 09-APR-09 16:53:56 9555127 09-APR-09 16:54:24
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00007_0683717387.001 9642083 14-APR-09 15:06:45 9662098 14-APR-09 15:14:17
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00006_0683717387.001 9555127 09-APR-09 16:54:24 9642083 14-APR-09 15:06:45
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00008_0683717387.001 9662098 14-APR-09 15:14:17 9691409 14-APR-09 16:19:15
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00009_0683717387.001 9691409 14-APR-09 16:19:15 9757691 15-APR-09 09:37:15
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00010_0683717387.001 9757691 15-APR-09 09:37:15 9760219 15-APR-09 10:05:16
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00011_0683717387.001 9760219 15-APR-09 10:05:16 9760221 15-APR-09 10:05:17
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00012_0683717387.001 9760221 15-APR-09 10:05:17 9760224 15-APR-09 10:05:21
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00013_0683717387.001 9760224 15-APR-09 10:05:21 9760232 15-APR-09 10:05:38
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00020_0683717387.001 9760551 15-APR-09 10:10:54 9859309 16-APR-09 11:09:42
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00021_0683717387.001 9859309 16-APR-09 11:09:42 9860008 16-APR-09 11:11:56
NAME FIRST_CHANGE# TO_CHAR(FIRST_TIME NEXT_CHANGE# TO_CHAR(NEXT_TIME,
------------------------------------------------------------------------------------------ ------------- ------------------ ------------ ------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00022_0683717387.001 9860008 16-APR-09 11:11:56 9860069 16-APR-09 12:12:59
SYS@orclnew AS SYSDBA>FLASHBACK DATABASE TO TIMESTAMP to_timestamp('2009-04-16 12:12:59','YYYY-MM-DD HH24:MI:SS');
FLASHBACK DATABASE TO TIMESTAMP to_timestamp('2009-04-16 12:12:59','YYYY-MM-DD HH24:MI:SS')
*
ERROR at line 1:
ORA-38726: Flashback database logging is not on.
RESTORE DATABASE; -- from last full backup
RMAN> recover database until SCN 9860069;
Starting recover at 17-APR-09
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/17/2009 10:04:12
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
Issue because I reset logs yesterday 04/16
RMAN> list incarnation of database orclnew;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCLNEW 3405949784 PARENT 1 30-AUG-05
2 2 ORCLNEW 3405949784 PARENT 534907 04-AUG-08
3 3 ORCLNEW 3405949784 PARENT 7648711 19-FEB-09
6 6 ORCLNEW 3405949784 PARENT 7648714 23-FEB-09
7 7 ORCLNEW 3405949784 PARENT 7656456 24-FEB-09
4 4 ORCLNEW 3405949784 ORPHAN 7671524 23-FEB-09
5 5 ORCLNEW 3405949784 ORPHAN 7736513 23-FEB-09
8 8 ORCLNEW 3405949784 PARENT 9060462 25-MAR-09
9 9 ORCLNEW 3405949784 PARENT 9533465 08-APR-09
10 10 ORCLNEW 3405949784 PARENT 9535505 09-APR-09
11 11 ORCLNEW 3405949784 CURRENT 9860069 16-APR-09
and after reset logs there have been no logs archived and the CURRENT redo log got corrupted.
Now I am restoring Control file to before resetlogs
RMAN> restore controlfile from 'C:\Oracle\product\10.2.0\admin\orclnew\bdump\C-3405949784-20090415-01';
Starting restore at 17-APR-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=385 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\CONTROL01.CTL
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\CONTROL02.CTL
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\CONTROL03.CTL
Finished restore at 17-APR-09
RMAN> list incarnation of database orclnew;
released channel: ORA_DISK_1
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCLNEW 3405949784 PARENT 1 30-AUG-05
2 2 ORCLNEW 3405949784 PARENT 534907 04-AUG-08
3 3 ORCLNEW 3405949784 PARENT 7648711 19-FEB-09
6 6 ORCLNEW 3405949784 PARENT 7648714 23-FEB-09
7 7 ORCLNEW 3405949784 PARENT 7656456 24-FEB-09
4 4 ORCLNEW 3405949784 ORPHAN 7671524 23-FEB-09
5 5 ORCLNEW 3405949784 ORPHAN 7736513 23-FEB-09
8 8 ORCLNEW 3405949784 PARENT 9060462 25-MAR-09
9 9 ORCLNEW 3405949784 PARENT 9533465 08-APR-09
10 10 ORCLNEW 3405949784 CURRENT 9535505 09-APR-09
NAME FIRST_CHANGE# TO_CHAR(FIRST_TIME NEXT_CHANGE# TO_CHAR(NEXT_TIME,
------------------------------------------------------------------------------------------ ------------- ------------------ ------------ ------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00005_0683717387.001 9555080 09-APR-09 16:53:56 9555127 09-APR-09 16:54:24
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00007_0683717387.001 9642083 14-APR-09 15:06:45 9662098 14-APR-09 15:14:17
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00006_0683717387.001 9555127 09-APR-09 16:54:24 9642083 14-APR-09 15:06:45
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00008_0683717387.001 9662098 14-APR-09 15:14:17 9691409 14-APR-09 16:19:15
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00009_0683717387.001 9691409 14-APR-09 16:19:15 9757691 15-APR-09 09:37:15
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00010_0683717387.001 9757691 15-APR-09 09:37:15 9760219 15-APR-09 10:05:16
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00011_0683717387.001 9760219 15-APR-09 10:05:16 9760221 15-APR-09 10:05:17
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00012_0683717387.001 9760221 15-APR-09 10:05:17 9760224 15-APR-09 10:05:21
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00013_0683717387.001 9760224 15-APR-09 10:05:21 9760232 15-APR-09 10:05:38
SYS@orclnew AS SYSDBA>recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database
Failed because FRA was full and some archivelogs had to cleaned out.
SYS@orclnew AS SYSDBA>recover database using backup controlfile;
ORA-00279: change 9369624 generated at 04/03/2009 11:01:00 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00005_0682424915.001
ORA-00280: change 9369624 for thread 1 is in sequence #5
Specify log: {
AUTO
ORA-00279: change 9422740 generated at 04/04/2009 10:57:31 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00006_0682424915.001
ORA-00280: change 9422740 for thread 1 is in sequence #6
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00005_0682424915.001' no longer needed for this recovery
ORA-00279: change 9517452 generated at 04/06/2009 04:00:17 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00007_0682424915.001
ORA-00280: change 9517452 for thread 1 is in sequence #7
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00006_0682424915.001' no longer needed for this recovery
ORA-00279: change 9533465 generated at 04/08/2009 12:51:05 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00001_0683643065.001
ORA-00280: change 9533465 for thread 1 is in sequence #1
ORA-00279: change 9535505 generated at 04/09/2009 09:29:47 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00001_0683717387.001
ORA-00280: change 9535505 for thread 1 is in sequence #1
ORA-00279: change 9555057 generated at 04/09/2009 16:53:14 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00002_0683717387.001
ORA-00280: change 9555057 for thread 1 is in sequence #2
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00001_0683717387.001' no longer needed for this recovery
ORA-00279: change 9555069 generated at 04/09/2009 16:53:46 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00003_0683717387.001
ORA-00280: change 9555069 for thread 1 is in sequence #3
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00002_0683717387.001' no longer needed for this recovery
ORA-00279: change 9555072 generated at 04/09/2009 16:53:51 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00004_0683717387.001
ORA-00280: change 9555072 for thread 1 is in sequence #4
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00003_0683717387.001' no longer needed for this recovery
ORA-00279: change 9555080 generated at 04/09/2009 16:53:56 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00005_0683717387.001
ORA-00280: change 9555080 for thread 1 is in sequence #5
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00004_0683717387.001' no longer needed for this recovery
ORA-00279: change 9555127 generated at 04/09/2009 16:54:24 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00006_0683717387.001
ORA-00280: change 9555127 for thread 1 is in sequence #6
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00005_0683717387.001' no longer needed for this recovery
ORA-00279: change 9642083 generated at 04/14/2009 15:06:45 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00007_0683717387.001
ORA-00280: change 9642083 for thread 1 is in sequence #7
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00006_0683717387.001' no longer needed for this recovery
ORA-00279: change 9662098 generated at 04/14/2009 15:14:17 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00008_0683717387.001
ORA-00280: change 9662098 for thread 1 is in sequence #8
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00007_0683717387.001' no longer needed for this recovery
ORA-00279: change 9691409 generated at 04/14/2009 16:19:15 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00009_0683717387.001
ORA-00280: change 9691409 for thread 1 is in sequence #9
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00008_0683717387.001' no longer needed for this recovery
ORA-00279: change 9757691 generated at 04/15/2009 09:37:15 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00010_0683717387.001
ORA-00280: change 9757691 for thread 1 is in sequence #10
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00009_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760219 generated at 04/15/2009 10:05:16 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00011_0683717387.001
ORA-00280: change 9760219 for thread 1 is in sequence #11
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00010_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760221 generated at 04/15/2009 10:05:17 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00012_0683717387.001
ORA-00280: change 9760221 for thread 1 is in sequence #12
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00011_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760224 generated at 04/15/2009 10:05:21 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00013_0683717387.001
ORA-00280: change 9760224 for thread 1 is in sequence #13
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00012_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760232 generated at 04/15/2009 10:05:38 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00014_0683717387.001
ORA-00280: change 9760232 for thread 1 is in sequence #14
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00013_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760482 generated at 04/15/2009 10:10:18 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00015_0683717387.001
ORA-00280: change 9760482 for thread 1 is in sequence #15
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00014_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760485 generated at 04/15/2009 10:10:24 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00016_0683717387.001
ORA-00280: change 9760485 for thread 1 is in sequence #16
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00015_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760492 generated at 04/15/2009 10:10:30 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00017_0683717387.001
ORA-00280: change 9760492 for thread 1 is in sequence #17
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00016_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760525 generated at 04/15/2009 10:10:39 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00018_0683717387.001
ORA-00280: change 9760525 for thread 1 is in sequence #18
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00017_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760530 generated at 04/15/2009 10:10:44 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00019_0683717387.001
ORA-00280: change 9760530 for thread 1 is in sequence #19
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00018_0683717387.001' no longer needed for this recovery
ORA-00279: change 9760551 generated at 04/15/2009 10:10:54 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00020_0683717387.001
ORA-00280: change 9760551 for thread 1 is in sequence #20
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00019_0683717387.001' no longer needed for this recovery
ORA-00279: change 9859309 generated at 04/16/2009 11:09:42 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00021_0683717387.001
ORA-00280: change 9859309 for thread 1 is in sequence #21
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00020_0683717387.001' no longer needed for this recovery
ORA-00279: change 9860008 generated at 04/16/2009 11:11:56 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00022_0683717387.001
ORA-00280: change 9860008 for thread 1 is in sequence #22
ORA-00278: log file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00021_0683717387.001' no longer needed for this recovery
Log applied.
Media recovery complete.
NAME FIRST_CHANGE# TO_CHAR(FIRST_TIME NEXT_CHANGE# TO_CHAR(NEXT_TIME,
------------------------------------------------------------------------------------------ ------------- ------------------ ------------ ------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00005_0683717387.001 9555080 09-APR-09 16:53:56 9555127 09-APR-09 16:54:24
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00007_0683717387.001 9642083 14-APR-09 15:06:45 9662098 14-APR-09 15:14:17
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00006_0683717387.001 9555127 09-APR-09 16:54:24 9642083 14-APR-09 15:06:45
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00008_0683717387.001 9662098 14-APR-09 15:14:17 9691409 14-APR-09 16:19:15
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00009_0683717387.001 9691409 14-APR-09 16:19:15 9757691 15-APR-09 09:37:15
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00010_0683717387.001 9757691 15-APR-09 09:37:15 9760219 15-APR-09 10:05:16
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00011_0683717387.001 9760219 15-APR-09 10:05:16 9760221 15-APR-09 10:05:17
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00012_0683717387.001 9760221 15-APR-09 10:05:17 9760224 15-APR-09 10:05:21
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ARCHIVE\ORCLNEW\ARC00013_0683717387.001 9760224 15-APR-09 10:05:21 9760232 15-APR-09 10:05:38
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO1A.LOG 0 0
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO1B.LOG 0 0
NAME FIRST_CHANGE# TO_CHAR(FIRST_TIME NEXT_CHANGE# TO_CHAR(NEXT_TIME,
------------------------------------------------------------------------------------------ ------------- ------------------ ------------ ------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2A.LOG 0 0
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\REDO2B.LOG 0 0
alter database open resetlogs;
SYS@orclnew AS SYSDBA>select group#,status,sequence#,first_change#,to_char(first_time,'dd-MON-yy hh24:mi:ss') from v$log;
GROUP# STATUS SEQUENCE# FIRST_CHANGE# TO_CHAR(FIRST_TIME
---------- ---------------- ---------- ------------- ------------------
1 CURRENT 1 9860069 17-APR-09 10:35:05
2 UNUSED 0 0
3 UNUSED 0 0
RMAN> list incarnation of database orclnew;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCLNEW 3405949784 PARENT 1 30-AUG-05
2 2 ORCLNEW 3405949784 PARENT 534907 04-AUG-08
3 3 ORCLNEW 3405949784 PARENT 7648711 19-FEB-09
6 6 ORCLNEW 3405949784 PARENT 7648714 23-FEB-09
7 7 ORCLNEW 3405949784 PARENT 7656456 24-FEB-09
4 4 ORCLNEW 3405949784 ORPHAN 7671524 23-FEB-09
5 5 ORCLNEW 3405949784 ORPHAN 7736513 23-FEB-09
8 8 ORCLNEW 3405949784 PARENT 9060462 25-MAR-09
9 9 ORCLNEW 3405949784 PARENT 9533465 08-APR-09
10 10 ORCLNEW 3405949784 PARENT 9535505 09-APR-09
11 11 ORCLNEW 3405949784 CURRENT 9860069 17-APR-09
No comments:
Post a Comment