Restore and Recovery using non-default archivelog destination [message #292166] |
Tue, 08 January 2008 02:07 |
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
|
|
|
|
|
|
|