| mms |
Posted: Jun 26, 2008 07:30:50 AM |
Total Post: 6
Joined: Apr, 2008
|
hi,
oracle 9i, OS linux 9
1.how can i apply a particular archive log on a database? i dont want to apply all my archive logs.
also i dont know the last SCN. what should i do in that situation?
2.how to do archiving on remote location?
any prompt response and help will b highly appreciated.
mms
|
|
|
 Gitesh |
| Posted: Jun 26, 2008 11:28:59 PM |  |
|
Total Post: 322
Joined: May, 2005
|
Why you need to apply archive log to database? Do you performing any recovery?
Map network/remote destination to your server and put same location in to log_archive_dest_2='LOCATION=/mapped_remote_location'
Archive will be generating in remote location also.
|
|
|
|
|
| mms |
| Posted: Jun 27, 2008 05:29:00 AM | |
|
Total Post: 6
Joined: Apr, 2008
|
hi,
yes i m performing recovery, but i nned to apply one perticular archive log.
pz give me one example of how to performing mapping?
for example host full name is localhost.localdomain of my machine and remote locations machine name is xyz.
|
|
|
|
|
| positive |
| Posted: Jun 27, 2008 06:42:16 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
May be u can make use of v$logmnr_contents view
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
