hi All,
I am wrongly name the datafile without .dbf, then i cancel it and re add users03.dbf.
Now i can't drop the user03 as the status show need recover.
1. I was try to recovery it and it show "suggested archived log" but the named log was deleted, how can i drop it without recover, or recover without archive log?
2. I use RMAN to backup database and "backup database plus archivelog delete input;" <- is it better backup all archive log instead of delete input?
At OS
drwxr-x---. 2 oracle oinstall 4096 Oct 14 11:33 .
drwxr-x---. 4 oracle oinstall 4096 Oct 8 22:05 ..
-rw-r--r--. 1 oracle oinstall 551 Oct 7 03:59 07102015.start.log
-rw-r-----. 1 oracle oinstall 20660224 Oct 14 15:46 control01.ctl
-rw-r-----. 1 oracle oinstall 20660224 Oct 7 01:40 control02.ctl
-rw-r-----. 1 oracle oinstall 104858112 Oct 14 15:39 redo01.log
-rw-r-----. 1 oracle oinstall 104858112 Oct 14 15:46 redo02.log
-rw-r-----. 1 oracle oinstall 104858112 Oct 14 15:39 redo03.log
-rw-r-----. 1 oracle oinstall 17238597632 Oct 14 15:46 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 34359730176 Oct 14 15:44 system01.dbf
-rw-r-----. 1 oracle oinstall 10737426432 Oct 14 15:39 system02.dbf
-rw-r-----. 1 oracle oinstall 10493952 Oct 14 15:39 system03.dbf
-rw-r-----. 1 oracle oinstall 34358697984 Oct 14 11:39 temp01.dbf
-rw-r-----. 1 oracle oinstall 34359730176 Oct 14 15:44 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 34359222272 Oct 14 15:39 users01.dbf
-rw-r-----. 1 oracle oinstall 29024591872 Oct 14 15:39 users02.dbf
-rw-r-----. 1 oracle oinstall 104865792 Oct 14 15:36 users03
-rw-r-----. 1 oracle oinstall 104865792 Oct 14 15:39 users03.dbf
At EM console (it show 0 MB, is it true?)
| File Name | Tablespace | Status | Size (MB) | Used (MB) | Used (%) | Auto Extend |
| /home/oracle/oradata/asanacrm/sysaux01.dbf | SYSAUX | ONLINE | 16,440.000 | 13,985.250 | 85.07 | YES |
| /home/oracle/oradata/asanacrm/system01.dbf | SYSTEM | SYSTEM | 32,767.984 | 975.484 | 2.98 | YES |
| /home/oracle/oradata/asanacrm/system02.dbf | SYSTEM | SYSTEM | 10,240.000 | 7.000 | 0.07 | YES |
| /home/oracle/oradata/asanacrm/system03.dbf | SYSTEM | SYSTEM | 10.000 | 1.000 | 10.00 | YES |
| /home/oracle/oradata/asanacrm/temp01.dbf | TEMP | ONLINE | 32,767.000 | 0.000 | 0.00 | YES |
| /home/oracle/oradata/asanacrm/undotbs01.dbf | UNDOTBS1 | ONLINE | 32,767.984 | 452.000 | 1.38 | YES |
| /home/oracle/oradata/asanacrm/users01.dbf | USERS | ONLINE | 32,767.500 | 32,464.625 | 99.08 | YES |
| /home/oracle/oradata/asanacrm/users02.dbf | USERS | ONLINE | 27,680.000 | 26,188.625 | 94.61 | YES |
| /home/oracle/oradata/asanacrm/users03 | USERS | RECOVER | 0.000 | 0.000 | 0.00 | |
| /home/oracle/oradata/asanacrm/users03.dbf | USERS | ONLINE | 100.000 | 99.000 | 99.00 | YES |
Thanks & Regards
JOE