Is it possible to rename redo_G_M1 to redo_G_M1 .log ?

[liliya13]

Hi ,

I work under SunOS5.9 Oracle9i

I have a problem...
Having created a database instance I copied redo01.log file:

cd~
mkdir DISK1
cd DISK1
cp -pr /ORACLE9i/BASE/oradata/mySID/redo01.log redo_G_M1

Unfortunately I did mistake and copied it to redo_G_M1 ...rather than to copy it to redo_G_M1.log

In other words I copied redo01.log to the file WITHIOUT AN EXTENSION!
Moreover...after that I removed the original file redo01.log

After I sutdown and startup I get a message
ORA-00313 : OPEN FAILED FOR MEMBERS OF LOG GROUP 1 OF THREAD 1
ORA-00312: online log 1 thread 1: '/ORACLE9i/BASE/oradata/mySID/redo01.log to '/export/home/oracle9i/DISK1/redo_GI_M1.log';

My question is:
Is there any way to rename redo_G_M1 to redo_G_M1.log so that it work or I should recreated an instance from scratch?


Thank YOu in advance,

Liliya

 

[SantaMufasa]

Liliya,

I'm not sure what you were attempting to do when you say:

Having created a database instance I copied redo01.log file...

...but the error message appears to indicate that it cannot find a file named '...redo_GI_M1.log'. At this point, there will be no additional harm if you try to rename the file at the operating system level and try again:

mv <current_file_name> <expected_file_name>

Let us know what you discover.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 16:49 (28Nov04) UTC (aka "GMT" and "Zulu"),
@ 09:49 (28Nov04) Mountain Time

 

[liliya13]

Mufasa,

I tried but I got a message as below mv:cannot access redo_G1_MI
Does it mean that the system cannot access a file without
extension .log? Is there anything else I can attemp in this situation?

Thank You for your help,

Liliya

/ORACLE9i/HOME/bin/sqlplus
bardeen% cd $ORACLE_HOME/dbs
bardeen% cd ~
bardeen% ls
DISK1 DISK2 dbcatest nsmail oracle.csh
bardeen% cd DISK1
bardeen% mv redo_G1_MI redo_G1_M1.log
mv: cannot access redo_G1_MI
bardeen%

 

[SantaMufasa]

Liliya,

While you are in the directory DISK1, could you please do an "ls -ltr" so we can see the permissions and confirm the existence of the file?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 02:13 (29Nov04) UTC (aka "GMT" and "Zulu"),
@ 19:13 (28Nov04) Mountain Time

 

[liliya13]

Mufasa,

The only thing I can see is : total 0

bardeen% setenv ORACLE_SID bardeen
bardeen% setenv ORACLE_HOME /ORACLE9i/HOME
bardeen% setenv ORACLE_BASE /ORACLE9i/BASE
bardeen% setenv PATH $ORACLE_HOME/bin:$PATH
bardeen% which sqlplus
/ORACLE9i/HOME/bin/sqlplus
bardeen% cd $ORACLE_HOME/dbs
bardeen% cd ~
bardeen% cd DISK1
bardeen% ls -ltr
total 0
bardeen%

 

[SantaMufasa]

Liliya,

If the "ls -ltr" produces those results, then that directory is empty and your "mv" will not produce the results you want. As you know, you'll need to determine the location of "redo_G1_MI" before you can rename (mv) it.

Let us know when you find it and successfully "mv" it to the correct name that Oracle expects.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 02:40 (29Nov04) UTC (aka "GMT" and "Zulu"),
@ 19:40 (28Nov04) Mountain Time