Home » RDBMS Server » Backup & Recovery » Restore and Recovery using non-default archivelog destination
Restore and Recovery using non-default archivelog destination [message #292166] Tue, 08 January 2008 02:07 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,

I had a DB with Archivelog enabled and archive logs are generated at location G:\DBIRFAN\ARCHIVE
SQL> show parameter log_archive_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string LOCATION=G:\DBIRFAN\ARCHIVE 
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string



Now i had taken hot RMAN backup plus all archive logfiles

RMAN>backup database plus all archivelogs delete input;

Now i want to restore archivelogs at location d:\oracle\archive other than default location G:\DBIRFAN\ARCHIVE
set as parameter log_archive_dest_1= 'LOCATION=G:\DBIRFAN\ARCHIVE'


and recover the whole DB
i had the following recovery script

RMAN >run{
allocate channel ch1 device type disk;
set archive log destination to 'd:\oracle\archive';
restore database;
recover database;
}


i think it'll restore archivelogs at location 'd:\oracle\archive' and then restore & recover db?
should i need to set the parameter log_archive_dest_1 before starting restore & recovery?

SQL>alter system set log_archive_dest_1 ='LOCATION=d:\oracle\archive' scope=both;


Please suggest!

[Edit: By Arju -Added Code Tags.]

[Updated on: Wed, 09 January 2008 23:01] by Moderator

Report message to a moderator

Re: Restore and Recovery using non-default archivelog destination [message #292254 is a reply to message #292166] Tue, 08 January 2008 05:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You've made almost 200 hundred posts and you still can't (or simply refuse) to format your posts ??

If you can't take the time to format your post, why should we take the time to respond ??
Re: Restore and Recovery using non-default archivelog destination [message #292272 is a reply to message #292166] Tue, 08 January 2008 06:29 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
ok i'll try to post in correct format
thanx to u
Re: Restore and Recovery using non-default archivelog destination [message #292277 is a reply to message #292272] Tue, 08 January 2008 06:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start with editing and reformating the current post.

Regards
Michel
Re: Restore and Recovery using non-default archivelog destination [message #292813 is a reply to message #292166] Wed, 09 January 2008 23:04 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

should i need to set the parameter log_archive_dest_1 before starting restore & recovery?


No.
If nothing you do then it will check the currently set archive location if any archive log needed for recovery.

[Updated on: Thu, 10 January 2008 01:19] by Moderator

Report message to a moderator

Previous Topic: RMAN Backup - Applying Retention Policy takes very long
Next Topic: rman recovery of .dbf on unix
Goto Forum:
  


Current Time: Wed May 15 04:32:42 CDT 2024