Home » Server Options » Data Guard » Log apply (Oracle 10.2.0.1.0 - Linux)
Log apply [message #380178] Fri, 09 January 2009 07:13 Go to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Hi all!!
I've got a mess...
A few time ago a tried to apply logs via rman an it worked perfectly.
Yesterday I tried it again but it didn't work. Logs are in the dir they are supposed to but it just says the follwing:

[oracle@test ~]$ /u02/app/oracle/product/10.2.0/bin/rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jan 9 11:10:07 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: TEST3 (DBID=3781993725, not open)

RMAN> recover database;

Starting recover at 09-JAN-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=214 devtype=DISK

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 09-JAN-09

RMAN>


...when I query the logs applied they are the same as before the recover.
What might be causing this?

Thanks in advance,
Daniela.
Re: Log apply [message #380184 is a reply to message #380178] Fri, 09 January 2009 07:23 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Oracle thinks that it already applied al the logs required for it to be in a fully recovered state.
Re: Log apply [message #380185 is a reply to message #380178] Fri, 09 January 2009 07:29 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
And how can I make it apply the ones I want it to?
Re: Log apply [message #380191 is a reply to message #380185] Fri, 09 January 2009 07:59 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
You can try to restore the database and do an incomplete recovery.
Re: Log apply [message #380222 is a reply to message #380185] Fri, 09 January 2009 10:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Do you see the logs listed with LIST ARCHIVELOG ALL. If not, you should try to CATALOG them and see if that helps.
Re: Log apply [message #382481 is a reply to message #380222] Thu, 22 January 2009 10:19 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
The 'list archivelog all' didn't show me the logs I ment to apply, so I "catalogued" them.
Before executing the recover database command, I executed this:
select sequence# from v$archived_log;
... which showed me the logs I wanted to apply ...
Then I made a "recover database" but it keeps saying ...

RMAN> recover database;

Starting recover at 22-JAN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=210 devtype=DISK

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 22-JAN-09

RMAN>


Then I wanted to open the database to see if it had really applied the logs but it asks to be opened with "resetlogs"
I don't want to reset logs!!!

What can I do?
Isn't there a way to restore without having to reset logs?
Re: Log apply [message #382483 is a reply to message #382481] Thu, 22 January 2009 10:28 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Ohh!! I'm so sorry!!
All I had to do was to open the database with "noresetlogs"!!
... but when I queried the database, the new rows that should appear didn't.

Heeelllppp!!

Re: Log apply [message #382532 is a reply to message #382483] Thu, 22 January 2009 19:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you followed the process indicated in Manually Determining and Resolving Archive Gaps ?
Re: Log apply [message #382638 is a reply to message #382532] Fri, 23 January 2009 05:48 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
I guess I missunderstood the concept... I wanted to apply logs to a primary database an they can only be applied to a standby. Am I wrong?
It's got sense... isn't it? I should have thought it for a moment...
Thanks a lot for your help an for you time.

Daniela.
Re: Log apply [message #382650 is a reply to message #382638] Fri, 23 January 2009 07:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Maybe I'm confused on what scenario you are trying to perform? The topic is listed under DataGuard ?

You are trying to recover the PRIMARY database ? If so, what steps did you take to perform the restore/recovery ? What provoked the need for recovery ?

Do you have the redo logs still in tact ?
Re: Log apply [message #382653 is a reply to message #382650] Fri, 23 January 2009 08:02 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
ebrian wrote on Fri, 23 January 2009 11:53
Maybe I'm confused on what scenario you are trying to perform? The topic is listed under DataGuard ?


Yes, Data Guard... but don't worry, it's just a test environment. I'm trying to solve things that can happen in case of "disaster".

Quote:

You are trying to recover the PRIMARY database ? If so, what steps did you take to perform the restore/recovery ?


I have restored a backup in a test server from a production database. I just wanted to know if I could apply the logs since the last backup from the production DB.

Quote:

What provoked the need for recovery ?


Just testing...

Re: Log apply [message #382661 is a reply to message #382653] Fri, 23 January 2009 09:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
OK...I think I understand your scenario now. Let me see if I have it right:

* You created a test database from production.
* You have been using the test database.
* You now want to bring the test database up-to-date with the production by applying the production database's archive logs.

If this is the case, then no, you can't perform this operation.

Where's the standby in this setup ?
Re: Log apply [message #382663 is a reply to message #382661] Fri, 23 January 2009 09:28 Go to previous message
danyromimd
Messages: 73
Registered: August 2008
Member
ebrian wrote on Fri, 23 January 2009 13:18
OK...I think I understand your scenario now. Let me see if I have it right:

* You created a test database from production.
* You have been using the test database.
* You now want to bring the test database up-to-date with the production by applying the production database's archive logs.

If this is the case, then no, you can't perform this operation.


I have not really been "using" it, just mounted the database and wanted to apply logs. But I guess it's much the same...

Quote:

Where's the standby in this setup ?


I ment that when I tried applying logs to the Standby database it did work. ... I thought it could be done on both Primary and Standby databases.
Previous Topic: how to make standy db consist wth primary db (merged)
Next Topic: Deletion oft Archive log on standby database
Goto Forum:
  


Current Time: Thu Mar 28 04:48:54 CDT 2024