| 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?
|
|
|
|
| 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]
|
|
|
|
| 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 | 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?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
