OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Kind of Confused (Oracle 9i, Oracle Linux 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Kind of Confused [message #302361]

Mon, 25 February 2008 05:47

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?

Report message to a moderator

Re: Kind of Confused [message #302362 is a reply to message #302361]

Mon, 25 February 2008 06:04

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]

Report message to a moderator

Re: Kind of Confused [message #302364 is a reply to message #302362]

Mon, 25 February 2008 06:07

kelvs
Messages: 15
Registered: December 2006

Junior Member

varu123 wrote on Mon, 25 February 2008 20:04

hi varu, will it be done automatically? or will i have to manually copy the missing logs from other destinations?

Report message to a moderator

Re: Kind of Confused [message #302368 is a reply to message #302361]

Mon, 25 February 2008 06:22

varu123
Messages: 754
Registered: October 2007

Senior Member

RMAN would do it automatically.
try complete recovery and post what you did

Report message to a moderator

Re: Kind of Confused [message #302468 is a reply to message #302364]

Mon, 25 February 2008 18:59

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.

Report message to a moderator