Oracle Database Discussions

hi

i ve two server... test1 and test2

i have shutdown instance and copy all files redo, control , and init from TEST1 TO TEST2 at same location.

now i cant up the database..

i tried to backup controlfile to trace of TEST1 and tried to open database on TEST2

but it i cant open the db

here is some example ...


SQL> CREATE CONTROLFILE REUSE DATABASE "AMD751" RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 20
3 MAXLOGMEMBERS 5
4 MAXDATAFILES 999
5 MAXINSTANCES 1
MAXLOGHISTORY 292
6 7 LOGFILE
8 GROUP 1 (
9 '/oravl04/oradata/amd751/rdl/redo01a.log',
10 '/oravl03/oradata/amd751/rdl/redo01b.log'
11 ) SIZE 50M,
12 GROUP 2 (
13 '/oravl04/oradata/amd751/rdl/redo02a.log',
14 '/oravl03/oradata/amd751/rdl/redo02b.log'
15 ) SIZE 50M,
16 GROUP 3 (
'/oravl04/oradata/amd751/rdl/redo03a.log',
17 18 '/oravl03/oradata/amd751/rdl/redo03b.log'
19 ) SIZE 50M
-- STANDBY LOGFILE
20 21 DATAFILE
22 '/oravl04/oradata/amd751/dfl/system01.dbf',
23 '/oravl04/oradata/amd751/dfl/undotbs01.dbf',
24 '/oravl04/oradata/amd751/dfl/sysaux01.dbf',
25 '/oravl04/oradata/amd751/dfl/users01.dbf'
26 CHARACTER SET AL32UTF8
27 ;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
Control file created.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> ORA-00279: change 2797632 generated at 09/22/
2009 12:36:30 needed for thread 1
ORA-00289: suggestion : /oravl01/oracle/10.2.0.1/dbs/arch1_1_698243790.dbf
ORA-00280: change 2797632 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/oravl01/oracle/10.2.0.1/dbs/arch1_1_698243790.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log
'/oravl01/oracle/10.2.0.1/dbs/arch1_1_698243790.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3


SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> alter database noarchive log;
alter database noarchive log
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oravl04/oradata/amd751/dfl/system01.dbf'

============================================
============================================


specially

'/oravl01/oracle/10.2.0.1/dbs/arch1_1_698243790.dbf' this file don exist on test1 or test2

any idea guys how to open db in this situations.....

Edited by: jignesh kankrecha on Sep 22, 2009 2:24 AM