Hot backup files, FTP to different box, recovery session canceled

From: Linda Hagedorn <Linda_at_pets.com>
Date: Tue, 6 Jun 2000 18:46:17 -0700
Message-Id: <10520.107988@fatcity.com>

Hello,

I am working on a database which was created from hot backup files from another instance. The files were ftp'd over, and ALTER DATABASE RENAME FILE was done to 21 files (copy below). When I start the database, the following error occurs:

SVRMGR> alter database open

     2> ;
alter database open
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf' SVRMGR> recover

ORA-00283: recovery session canceled due to errors
ORA-00322: log 5 of thread 1 is not current copy
ORA-00312: online log 5 thread 1:

'/opt/oracle/app/oracle/oradata/PETS/log2/red' ORA-00322: log 5 of thread 1 is not current copy ORA-00312: online log 5 thread 1:
'/opt/oracle/app/oracle/oradata/PETS/log1/red' SVRMGR> I'm quite sure the problem is related to the renamed datasets, although I don't know how to diagnose the problem to discover what to change to fix it. If anyone recognizes this error, I'd be glad to know the resolution.

Thank you.

Best regards, Linda

These are the files which were FTP'd:
loaddb1:/opt/oracle/app/oracle/oradata/PETS/data$ ls -l

-rw-r--r-- 1 oracle dba 629147648 Jun 6 15:44 rbs01.dbf
-rw-r----- 1 oracle dba 83888128 Jun 6 15:45 system01.dbf
-rw-r----- 1 oracle dba 15005696 Jun 6 15:45 control02.ctl
-rw-r--r-- 1 oracle dba 288360448 Jun 6 15:48 temp01.dbf
-rw-r--r-- 1 oracle dba 1934624768 Jun 6 16:04 snapshotlog.dbf
-rw-r--r-- 1 oracle dba 26216448 Jun 6 16:16 tools01.dbf
-rw-r--r-- 1 oracle dba 1562380288 Jun 6 16:16 users01.dbf
-rw-r--r-- 1 oracle dba 2112882688 Jun 6 16:34 users02.dbf
-rw-r--r-- 1 oracle dba 62916608 Jun 6 16:34 index01.dbf
-rw-r--r-- 1 oracle dba 104859648 Jun 6 16:35 temp02.dbf
-rw-r--r-- 1 oracle dba 1142949888 Jun 6 16:45 users03.dbf
-rw-r--r-- 1 oracle dba 1073743872 Jun 6 16:54 snapshotlog2.log

loaddb1:/opt/oracle/app/oracle/oradata/PETS/log1$ ls -l total 102576

drwx------   2 oracle   dba         8192 May  8 16:00 lost+found


-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS01.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS02.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS03.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS04.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS05.log


loaddb1:/opt/oracle/app/oracle/oradata/PETS/log1$ ls -l
total 102576
drwx------   2 oracle   dba         8192 May  8 16:00 lost+found


-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS01.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS02.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS03.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS04.log

-rw-r-----   1 oracle   dba      10486272 Jun  6 16:54 redoPETS05.log

 

These are the ALTER DATABASE RENAME FILE statements: loaddb1:/opt/oracle/app/oracle/product/8.0.5/build$ more alterdf.ksh

svrmgrl << EOJ

connect internal;

shutdown immediate;

startup mount;

ALTER DATABASE RENAME FILE '/oradata/PETS/log1/redoPETS01.log'

to '/opt/oracle/app/oracle/oradata/PETS/log1/redoPETS01.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log1/redoPETS02.log'

to '/opt/oracle/app/oracle/oradata/PETS/log1/redoPETS02.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log1/redoPETS03.log'

to '/opt/oracle/app/oracle/oradata/PETS/log1/redoPETS03.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log1/redoPETS04.log'

to '/opt/oracle/app/oracle/oradata/PETS/log1/redoPETS04.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log1/redoPETS05.log'

to '/opt/oracle/app/oracle/oradata/PETS/log1/redoPETS05.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log2/redoPETS01.log'

to '/opt/oracle/app/oracle/oradata/PETS/log2/redoPETS01.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log2/redoPETS02.log'

to '/opt/oracle/app/oracle/oradata/PETS/log2/redoPETS02.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log2/redoPETS03.log'

to '/opt/oracle/app/oracle/oradata/PETS/log2/redoPETS03.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log2/redoPETS04.log'

to '/opt/oracle/app/oracle/oradata/PETS/log2/redoPETS04.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/log2/redoPETS05.log'

to '/opt/oracle/app/oracle/oradata/PETS/log2/redoPETS05.log';

ALTER DATABASE RENAME FILE '/oradata/PETS/data1/system01.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data1/rbs01.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/rbs01.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data2/temp01.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/temp01.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data2/tools01.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/tools01.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data2/users01.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/users01.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data2/snapshotlog.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/snapshotlog.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data3/index01.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/index01.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data3/users02.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/users02.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data3/temp02.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/temp02.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data3/users03.dbf'

to '/opt/oracle/app/oracle/oradata/PETS/data/users03.dbf';

ALTER DATABASE RENAME FILE '/oradata/PETS/data3/snapshotlog2.log' Received on Tue Jun 06 2000 - 20:46:17 CDT