We help IT Professionals succeed at work.

Archive Log File error

patmoli
patmoli asked
on
1,055 Views
Last Modified: 2013-12-19
Hi,

I have one Database called PDXAPPDB is running I decide to create a duplicate database (PDXAPPDB) in a different system I fallow these steps

1-Create a text version of the control file from Original PDXAPPDB
2-Then copy all files (Parameter/Data/Redo log/Archive Log) into NEW system
3-Make directory structure for duplicate database into new system
4-Edit the parameter file and change locations of (control/dump/archive) and change DB Name/Instance Name
5-Then I create new SID for the Database into new system
6-Start the Database in nomount (Startup nomount --- I already copy parameter file into default location (oracle_home/database)  
7-When the Instance is Start I make a password file for new database into default location (oracle_home/database)
8-Then I use the script from control Files Text Version( take the part with resetlogs  and change the Database name & files locations and run it. I create control file successfully  

When I am try to Open my Database I face this error

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-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\CR_PDXAPPDB_CTRL_FILE\SYSTEM001.DBF'


then I use this command

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 389651 generated at 09/28/2007 18:58:56 needed for thread 1
ORA-00289: suggestion : C:\ORA9I\RDBMS\ARC00017.001
ORA-00280: change 389651 for thread 1 is in sequence #17


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'C:\ORA9I\RDBMS\ARC00017.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-00308: cannot open archived log 'C:\ORA9I\RDBMS\ARC00017.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\CR_PDXAPPDB_CTRL_FILE\SYSTEM001.DBF'


There is no Archive file Associated with this name ( 'C:\ORA9I\RDBMS\ARC00017.001' )in Original Database(PDXAPPDB) as well (I have only two files :\ORA9I\RDBMS\ARC00015.001/C:\ORA9I\RDBMS\ARC00016.001 ) then How I get this file or use any other command to consistent my Datafiles then I am able to open my database.


Here is the commands I use to create the duplicate database ...
I am waiting for your relpy


Bye




c:\>set oracle_sid
oracle_sid=pdxtest

c:\>
c:\>
c:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Sep 28 19:15:25 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>
SQL>
SQL> connect sys/oracle as sysdba;
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  126950220 bytes
Fixed Size                   453452 bytes
Variable Size             109051904 bytes
Database Buffers           16777216 bytes
Redo Buffers                 667648 bytes
SQL>
SQL>
SQL>


SQL>  CREATE CONTROLFILE REUSE SET DATABASE "PDXTEST" RESETLOGS  ARCHIVELOG
           MAXLOGFILES 32
           MAXLOGMEMBERS 2
           MAXDATAFILES 32
           MAXINSTANCES 16
           MAXLOGHISTORY 1815
        LOGFILE
         GROUP 1 (
          'C:\cr_pdxappdb_ctrl_file\LOG001A.RDO',
          'C:\cr_pdxappdb_ctrl_file\LOG001B.RDO'
        ) SIZE 50M,
        GROUP 2 (
          'C:\cr_pdxappdb_ctrl_file\LOG002A.RDO',
          'C:\cr_pdxappdb_ctrl_file\LOG002B.RDO'
        ) SIZE 50M,
        GROUP 3 (
          'C:\cr_pdxappdb_ctrl_file\LOG003A.RDO',
          'C:\cr_pdxappdb_ctrl_file\LOG003B.RDO'
        ) SIZE 50M
     
      DATAFILE
        'C:\cr_pdxappdb_ctrl_file\SYSTEM001.DBF',
        'C:\cr_pdxappdb_ctrl_file\UNDO001.DBF',
        'C:\cr_pdxappdb_ctrl_file\INDEXS.NDX',
        'C:\cr_pdxappdb_ctrl_file\USERS_DATA.DBF'
    CHARACTER SET US7ASCII
SQL> /

Control file created.

SQL>
SQL>
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-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\CR_PDXAPPDB_CTRL_FILE\SYSTEM001.DBF'


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 389651 generated at 09/28/2007 18:58:56 needed for thread 1
ORA-00289: suggestion : C:\ORA9I\RDBMS\ARC00017.001
ORA-00280: change 389651 for thread 1 is in sequence #17


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'C:\ORA9I\RDBMS\ARC00017.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-00308: cannot open archived log 'C:\ORA9I\RDBMS\ARC00017.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\CR_PDXAPPDB_CTRL_FILE\SYSTEM001.DBF'


SQL>
Comment
Watch Question

Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.