Home » RDBMS Server » Backup & Recovery » Kind of Confused (Oracle 9i, Oracle Linux 5)
Kind of Confused [message #302361] Mon, 25 February 2008 05:47 Go to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
Is it okay if there are missing logs in specified locations? e.g.

log_archive_dest_1 = /log1
log_archive_dest_2 = /log2

log_archive_dest_state_1 = defer
log_archive_dest_state_2 = enable

then you perform an alter system switch logfile;
you inspect both directories
[root@omega log1]# ls
testdb_1_0000000027.dbf testdb_1_0000000030.dbf testdb_1_0000000033.dbf
testdb_1_0000000028.dbf testdb_1_0000000031.dbf testdb_1_0000000036.dbf
testdb_1_0000000029.dbf testdb_1_0000000032.dbf testdb_1_0000000037.dbf
[root@omega log1]# ls ../log2
testdb_1_0000000027.dbf testdb_1_0000000031.dbf testdb_1_0000000035.dbf
testdb_1_0000000028.dbf testdb_1_0000000032.dbf testdb_1_0000000036.dbf
testdb_1_0000000029.dbf testdb_1_0000000033.dbf testdb_1_0000000037.dbf
testdb_1_0000000030.dbf testdb_1_0000000034.dbf

if you have noticed, there are missing logs in /log1 directory. It missed out 34 and 35 since the state of the first location is set to defer. Will it have a recovery issue IF state of first location is set to enabled and performed another archiving?

Follow up question, this was taken from an Oracle manual:
Archiving is not performed to a destination when the state is set to DEFER. If the state of this destination is changed to ENABLE, any missed logs must be manually archive to this destination.

Does issuing ALTER SYSTEM ARCHIVE LOG CURRENT command bring back missing logs 34 and 35 (following the example above)? To find out the answer to my question, I tried executing the command, but oracle creates logfile with new sequence number and doesn't create the missing logs, is this okay for recovery?


Re: Kind of Confused [message #302362 is a reply to message #302361] Mon, 25 February 2008 06:04 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
As per oracle, If you specify multiple destinations for archive log s then oracle looks for missing logs at other specified locations.

In your case,recovery would be possible as other location location has all the logs.[I think so]
Re: Kind of Confused [message #302364 is a reply to message #302362] Mon, 25 February 2008 06:07 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
varu123 wrote on Mon, 25 February 2008 20:04
As per oracle, If you specify multiple destinations for archive log s then oracle looks for missing logs at other specified locations.

In your case,recovery would be possible as other location location has all the logs.[I think so]


hi varu, will it be done automatically? or will i have to manually copy the missing logs from other destinations?
Re: Kind of Confused [message #302368 is a reply to message #302361] Mon, 25 February 2008 06:22 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
RMAN would do it automatically.
try complete recovery and post what you did
Re: Kind of Confused [message #302468 is a reply to message #302364] Mon, 25 February 2008 18:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Is this a theoretical question? Are you altering the state of LOG_ARCHIVE_DEST_STATE_1 ?

In a DEFER state, Oracle isn't supposed to write to that location which obviously defeats the purpose of two locations. If you want to bring the locations into sync, then just manually copy the missing files with an O/S copy command from LOG_ARCHIVE_DEST_2 to LOG_ARCHIVE_DEST_1.
Re: Kind of Confused [message #302627 is a reply to message #302368] Tue, 26 February 2008 06:50 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
ok varu, i'll try to inform you if I've reached that part.
Re: Kind of Confused [message #302628 is a reply to message #302468] Tue, 26 February 2008 06:51 Go to previous message
kelvs
Messages: 15
Registered: December 2006
Junior Member
ebrian: now it was made clear to me. many thanks!
Previous Topic: I can not make the tablespace online?
Next Topic: RMAN: Recover from new backup set to point-in-time in the past
Goto Forum:
  


Current Time: Mon Dec 05 10:42:04 CST 2016

Total time taken to generate the page: 0.09147 seconds