Oracle Database Discussions

SQL> select status from v$log where group#=3;

STATUS
----------------
INACTIVE

SQL> alter database drop logfile group3;
alter database drop logfile group3
*
ERROR at line 1:
ORA-02236: invalid file name


SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-00350: log 3 of instance data (thread 1) needs to be archived
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/product/10.2.0/db_1/oradata/data/redo03.log'


SQL> alter database clear logfile group 3;
alter database clear logfile group 3
*
ERROR at line 1:
ORA-00350: log 3 of instance data (thread 1) needs to be archived
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/product/10.2.0/db_1/oradata/data/redo03.log'


SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

Database altered.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;

Database altered.

SQL> alter system switch logfile;


________________________________********************** HERE it is hanged what to do suggest plz**************************


IN MY ALERT LOG
________________
Sun Apr 7 11:01:32 2013
ARCh: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:01:37 2013
ARCi: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:01:42 2013
ARCj: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:01:47 2013
ARCk: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:01:53 2013
ARCl: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:01:58 2013
ARCm: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:02 2013
ARCn: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:07 2013
ARCo: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:11 2013
ARCp: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:12 2013
ARCq: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:17 2013
ARCr: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:22 2013
ARCs: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:27 2013
ARC0: Failed to archive thread 1 sequence 11 (19504)
Sun Apr 7 11:02:32 2013
ARC1: Failed to archive thread 1 sequence 11 (19504)
"alert_data.log" 9807L, 389062C 9415,1 96%

******************************plz help me i want to over come this situation *******************************************
my pfile is
*.background_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/data/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/product/10.2.0/db_1/oradata/data/control01.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/data/control02.ctl','/u01/app/oracle/product/10.2.0/db_1/oradata/data/control03.ctl'
*.core_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/data/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='data'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dataXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=200278016
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=601882624
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/product/10.2.0/db_1/admin/data/udump'
db_unique_name='data'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(data,rawdata)'
LOG_ARCHIVE_DEST='/u01/app/oracle/product/10.2.0/db_1/oradata/data/arch/'
LOG_ARCHIVE_DEST='/u01/app/oracle/product/10.2.0/db_1/oradata/data/arch/VALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=data'
LOG_ARCHIVE_DEST='SERVICE=RAWDATA LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=rawdata'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s/%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
#STANDBY ROLE PARAMETERS ----------------
fal_server=data
fal_client=rawdata
standby_file_management=auto
db_file_name_convert='/u01/app/oracle/product/10.2.0/db_1/oradata/data/','//u01/app/oracle/product/10.2.0/db_1/oradata/rawdata/'
log_file_name_convert='/u01/app/oracle/product/10.2.0/db_1/oradata/data/','/u01/app/oracle/product/10.2.0/db_1/oradata/rawdata/'

THANKS ALLL