| Recover redo log files with rman [message #242174] |
Thu, 31 May 2007 21:51  |
chara
Messages: 81
Registered: April 2005
Location: th
|
Member |
|
|
Dear all,
I tested recovery redo log files with rman as below step :
1.shutdown db
2.move redo log files
3.startup db
SQL> startup
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\DB3\REDO01.LOG'
4. select first_change# from v$log ;
FIRST_CHANGE#
-------------
396376
5.rman connect target /
6.RMAN> restore database until scn 396375;
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/01/2007 09:32:06
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
what happend ? Can anybody suggest me?
Thanks for advance.
Chara
|
|
|
|
|
|
| Re: Recover redo log files with rman [message #242229 is a reply to message #242209] |
Fri, 01 June 2007 02:50  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
The DB is in mount mode:
| Quote: | Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\DB3\REDO01.LOG'
|
Do a "list incarnation of database;" and pick a time after the last reset time.
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1334173 1334180 ORAWEB 1881601553 PARENT 1 12-JUL-05
1334173 1334174 ORAWEB 1881601553 CURRENT 524107 04-JUL-06 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
