Log apply [message #380178] |
Fri, 09 January 2009 07:13 |
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 #382481 is a reply to message #380222] |
Thu, 22 January 2009 10:19 |
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 |
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 #382638 is a reply to message #382532] |
Fri, 23 January 2009 05:48 |
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 #382653 is a reply to message #382650] |
Fri, 23 January 2009 08:02 |
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 #382663 is a reply to message #382661] |
Fri, 23 January 2009 09:28 |
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.
|
|
|