Database Reference
In-Depth Information
That error message is fine. The recovery process will restore and recover archive redo logs contained in the
backups, which should be sufficient to open the database. The recovery process doesn't know where to stop applying
archive redo logs and therefore will continue to attempt to do so until it can't find the next log. Having said that, now is
a good time to verify that your data files are online and not in a fuzzy state:
select file#, status, fuzzy, error, checkpoint_change#,
to_char(checkpoint_time,'dd-mon-rrrr hh24:mi:ss') as checkpoint_time
from v$datafile_header;
Step 13. Set the New Location for the Online Redo Logs
If your source and destination servers have the exact same directory structures, then you don't need to set a new
location for the online redo logs (so you can skip this step).
However, if the directory structures are different, then you'll need to update the control file to reflect the new
directory for the online redo logs. I sometimes use an SQL script that generates SQL to assist with this step:
set head off feed off verify off echo off pages 0 trimspool on
set lines 132 pagesize 0
spo renlog.sql
select
'alter database rename file ' || chr(10)
|| '''' || member || '''' || ' to ' || chr(10) || '''' || member || '''' ||';'
from v$logfile;
spo off;
For this example, here is a snippet of the renlog.sql file that was generated:
alter database rename file
'/u01/oraredo/O12C/redo01a.rdo' to
'/u01/oraredo/O12C/redo01a.rdo';
...
alter database rename file
'/u02/oraredo/O12C/redo03b.rdo' to
'/u02/oraredo/O12C/redo03b.rdo';
The contents of renlog.sql need to be modified to reflect the directory structure on the destination server. Here
is what renlog.sql looks like after being edited:
alter database rename file
'/u01/oraredo/O12C/redo01a.rdo' to
'/ora01/oraredo/DEVDB/redo01a.rdo';
...
alter database rename file
'/u02/oraredo/O12C/redo03b.rdo' to
'/ora01/oraredo/DEVDB/redo03b.rdo';
Update the control file by running the renlog.sql script:
SQL> @renlog.sql
 
Search WWH ::




Custom Search