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

Linda,

You did not use a backup controlfile when you opened the database.

I believe if you do

alter database open resetlogs

that will fix the problem. Otherwise, on the original system, you need to do "alter database backup controlfile to <filename>" and copy that file over to the new system. Then on the new system

recover database until cancel using backup controlfile

you can either feed it archived logs and then cancel, or cancel at that point.

When you cancel, you then alter database open resetlogs

Rachel

>From: Linda Hagedorn <Linda_at_pets.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Hot backup files, FTP to different box, recovery session canceled
>Date: Tue, 06 Jun 2000 18:55:48 -0800
>
>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'
>
>to '/opt/oracle/app/oracle/oradata/PETS/data/snapshotlog2.log';
>
>alter database open;
>
>EOJ
>
>
>--
>Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Tue Jun 06 2000 - 21:43:05 CDT