Home » RDBMS Server » Backup & Recovery » Recover redo log files with rman
Recover redo log files with rman [message #242174] Thu, 31 May 2007 21:51 Go to next message
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 #242209 is a reply to message #242174] Fri, 01 June 2007 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recover until change must be done in mount state not in open one.

Regards
Michel
Re: Recover redo log files with rman [message #242229 is a reply to message #242209] Fri, 01 June 2007 02:50 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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
Re: Recover redo log files with rman [message #242232 is a reply to message #242229] Fri, 01 June 2007 03:22 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh yes! my bad, I missed it. Embarassed

Regards
Michel
Previous Topic: 10.2.0.3 patch set installation over 10.2.0.2
Next Topic: DATABASE
Goto Forum:
  


Current Time: Fri Dec 02 12:32:57 CST 2016

Total time taken to generate the page: 0.12317 seconds