Oracle Database Discussions

hi all ,

please advice i want to recreate the controlfile but this issue occur



SQL> l
1 CREATE CONTROLFILE set DATABASE "TABSTSTD" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 17528
7 LOGFILE
8 GROUP 1 (
9 '/films/u01/PRODTABS/redo01_1.log',
10 '/films/u02/PRODTABS/redo01_2.log'
11 ) SIZE 100M,
12 GROUP 2 (
13 '/films/u01/PRODTABS/redo02_1.log',
14 '/films/u02/PRODTABS/redo02_2.log'
15 ) SIZE 100M,
16 GROUP 3 (
17 '/films/u01/PRODTABS/redo03_1.log',
18 '/films/u03/PRODTABS/redo03_2.log'
19 ) SIZE 100M
20 -- STANDBY LOGFILE
21 DATAFILE
22 '/films/system01.dbf',
23 '/films/sysaux01.dbf',
24 '/films/TABST01F01',
25 '/ccbstst/oradata/TABSTSTD/tabs_data01.dbf',
26 '/ccbstst/oradata/TABSTSTD/TABST01F03.DBF',
27 '/ccbstst/oradata/TABSTSTD/TABST01F04.DBF',
28 '/films/undo.dbf'
29 CHARACTER SET AL32UTF8
30*
SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oraccbs:/ccbstst/appl/oracle $cd /ccbstst/oradata/TABSTSTD
oraccbs:/ccbstst/oradata/TABSTSTD $ls
TABST01F03.DBF control01.ctl control03.ctl
TABST01F04.DBF control02.ctl tabs_data01.dbf
oraccbs:/ccbstst/oradata/TABSTSTD $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 14 15:17:43 2012

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-09817: Write to audit file failed.
SVR4 Error: 28: No space left on device
ORA-01075: you are currently logged on


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oraccbs:/ccbstst/oradata/TABSTSTD $
oraccbs:/ccbstst/oradata/TABSTSTD $
oraccbs:/ccbstst/oradata/TABSTSTD $
oraccbs:/ccbstst/oradata/TABSTSTD $
oraccbs:/ccbstst/oradata/TABSTSTD $df -h
Filesystem size used avail capacity Mounted on
/dev/dsk/c0t0d0s0 19G 19G 0K 100% /
/devices 0K 0K 0K 0% /devices
ctfs 0K 0K 0K 0% /system/contract
proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
swap 14G 1.4M 14G 1% /etc/svc/volatile
objfs 0K 0K 0K 0% /system/object
/platform/SUNW,Sun-Fire-T200/lib/libc_psr/libc_psr_hwcap1.so.1
19G 19G 0K 100% /platform/sun4v/lib/libc_psr.so.1
/platform/SUNW,Sun-Fire-T200/lib/sparcv9/libc_psr/libc_psr_hwcap1.so.1
19G 19G 0K 100% /platform/sun4v/lib/sparcv9/libc_psr.so.1
fd 0K 0K 0K 0% /dev/fd
swap 17G 2.8G 14G 18% /tmp
swap 14G 56K 14G 1% /var/run
/dev/dsk/c0t0d0s3 32G 28G 4.4G 87% /films
/dev/dsk/c0t2d0s5 74G 35G 38G 48% /ccbstst/oradata
/dev/dsk/c0t2d0s3 9.8G 58M 9.7G 1% /ccbstst/archv
/dev/dsk/c0t1d0s4 20G 19G 818M 96% /medtst/appl
/dev/dsk/c0t2d0s4 20G 20G 0K 100% /ccbstst/appl
/dev/dsk/c0t2d0s6 4.9G 77M 4.8G 2% /ccbstst/cdrs
/dev/dsk/c0t2d0s7 4.9G 5.0M 4.9G 1% /ccbstst/bill
/dev/dsk/c0t1d0s3 4.9G 3.2G 1.6G 67% /medtst/archv
/dev/dsk/c0t1d0s5 25G 17G 7.0G 72% /medtst/oradata
/dev/dsk/c0t1d0s6 4.9G 431M 4.5G 9% /medtst/cdrs
oraccbs:/ccbstst/oradata/TABSTSTD $ls ltrh
ltrh: No such file or directory
oraccbs:/ccbstst/oradata/TABSTSTD $cd
oraccbs:/ccbstst/appl/oracle $ls -ltrh
total 6274
drwxr-xr-x 4 oraccbs dba 512 Dec 5 2007 5965763
-rw-r--r-- 1 oraccbs dba 30K Feb 15 2008 utltzpv4.sql
drwxr-xr-x 6 oraccbs dba 512 Apr 7 2008 Disk1
-rw-r--r-- 1 oraccbs dba 2.4K Dec 17 2008 prepare_tzuv.sql
-rw-r--r-- 1 oraccbs dba 174 Feb 4 2009 local.profile
-rw-r--r-- 1 oraccbs dba 157 Feb 4 2009 local.login
-rw-r--r-- 1 oraccbs dba 136 Feb 4 2009 local.cshrc
drwxr-xr-x 2 oraccbs dba 512 Mar 10 2009 Desktop
-rw-r--r-- 1 oraccbs dba 3.0M May 20 2009 RDA.PRODTABS1_billdb00.zip
drwxr-xr-x 2 oraccbs dba 512 Jun 15 2009 logs
-rw-r--r-- 1 oraccbs dba 0 Jun 22 2009 vi
-rw-r--r-- 1 oraccbs dba 0 Jun 22 2009 log_rebuild.log
drwxr-xr-x 4 10 143 512 Apr 13 2010 SUNWj6rtx
drwxr-xr-x 4 10 143 512 Apr 13 2010 SUNWj6dvx
drwxr-xr-x 4 10 143 512 Apr 13 2010 SUNWj6dmx
-rw-r--r-- 1 oraccbs dba 3.7K Apr 13 2010 COPYRIGHT
drwxr-xr-x 3 oraccbs dba 512 Jun 23 2010 oms
drwxrwx--- 7 oraccbs dba 512 Jun 23 2010 oraInventory
drwxr-xr-x 3 oraccbs dba 512 Jul 13 2010 agent_down
-rw-r--r-- 1 oraccbs dba 12K Jul 28 2010 formsweb.cfg
-rw-r--r-- 1 oraccbs dba 0 Jun 14 2011 aaa.sql
-rw-r--r-- 1 oraccbs dba 0 Jun 15 2011 DMP
-rw-r--r-- 1 oraccbs dba 0 Jun 15 2011 DMP
-rw-r--r-- 1 oraccbs dba 0 Jun 15 2011 DMP
drwxr-xr-x 3 oraccbs dba 512 Sep 6 2011 product
drwxr-x--- 3 oraccbs dba 512 Sep 8 2011 oradata
drwxr-x--- 3 oraccbs dba 512 Feb 26 18:47 admin
-rw-r--r-- 1 oraccbs dba 0 Mar 13 15:23 afiedt.buf
oraccbs:/ccbstst/appl/oracle $mv log_rebuild.log RDA.PRODTABS1_billdb00.zip /ccbstst/archv
oraccbs:/ccbstst/appl/oracle $df -h
Filesystem size used avail capacity Mounted on
/dev/dsk/c0t0d0s0 19G 19G 0K 100% /
/devices 0K 0K 0K 0% /devices
ctfs 0K 0K 0K 0% /system/contract
proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
swap 14G 1.4M 14G 1% /etc/svc/volatile
objfs 0K 0K 0K 0% /system/object
/platform/SUNW,Sun-Fire-T200/lib/libc_psr/libc_psr_hwcap1.so.1
19G 19G 0K 100% /platform/sun4v/lib/libc_psr.so.1
/platform/SUNW,Sun-Fire-T200/lib/sparcv9/libc_psr/libc_psr_hwcap1.so.1
19G 19G 0K 100% /platform/sun4v/lib/sparcv9/libc_psr.so.1
fd 0K 0K 0K 0% /dev/fd
swap 17G 2.8G 14G 18% /tmp
swap 14G 56K 14G 1% /var/run
/dev/dsk/c0t0d0s3 32G 28G 4.4G 87% /films
/dev/dsk/c0t2d0s5 74G 35G 38G 48% /ccbstst/oradata
/dev/dsk/c0t2d0s3 9.8G 61M 9.7G 1% /ccbstst/archv
/dev/dsk/c0t1d0s4 20G 19G 818M 96% /medtst/appl
/dev/dsk/c0t2d0s4 20G 19G 3.0M 100% /ccbstst/appl
/dev/dsk/c0t2d0s6 4.9G 77M 4.8G 2% /ccbstst/cdrs
/dev/dsk/c0t2d0s7 4.9G 5.0M 4.9G 1% /ccbstst/bill
/dev/dsk/c0t1d0s3 4.9G 3.2G 1.6G 67% /medtst/archv
/dev/dsk/c0t1d0s5 25G 17G 7.0G 72% /medtst/oradata
/dev/dsk/c0t1d0s6 4.9G 431M 4.5G 9% /medtst/cdrs
oraccbs:/ccbstst/appl/oracle $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 14 15:18:25 2012

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> show parameter control;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /ccbstst/oradata/TABSTSTD/cont
rol01.ctl, /ccbstst/oradata/TA
BSTSTD/control02.ctl, /ccbstst
/oradata/TABSTSTD/control03.ct
l
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01079: ORACLE database was not properly created, operation aborted


please advice i aleardy search in google but it's said you must drop database or controlfile

i try to drop controlfile but the same issue occur????????????