Oracle does not start services after client copy

[manuel_sandoval4]

hi all!

I tell them my problem, yesterday began the principal copy from PRD to QAS client, this for reasons of space he was arrested.

Realizing this, we assign more space to QAS server, but when you try to lift the services again we are presented with the following error.

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 25 18:14:30 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 3405774848 bytes

Fixed Size 2024560 bytes

Variable Size 1711278992 bytes

Database Buffers 1677721600 bytes

Redo Buffers 14749696 bytes

Database mounted.

ORA-16038: log 4 sequence# 3548 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 4 thread 1: '/oracle/QAS/origlogB/log_g14m1.dbf'

ORA-00312: online log 4 thread 1: '/oracle/QAS/mirrlogB/log_g14m2.dbf'

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning and Data Mining options

Someone could give me some guidance on how to solve the problem.

thanks.

[former_member524429 · Accepted solution]

Hi,

Have you checked the space of ORAARCH or SAPARCH folder/directory ? The problem may be "Archive destination full". If its full then try to move some old Offline redo log file to other safe location as a backup and then try to restart the Oracle Instance again.

Regards

Bhavik G. Shroff

[manuel_sandoval4 · Accepted solution]

thanks for your answers.

and services are up and I could continue with the copy.

Besides the problem of space, was that the database was not down properly.

[former_member185031]

>>SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 25 18:14:30 2010

This Oracle version is not supported. You should try with 10.2.0.2.0 or 10.2.0.4.0

Regards,

Subhash