Can you explain me this? I thought these were separate databases but not. There's only one database in there. Verified with (select * from v$database
This is only one database instance (probably called "SMART"). What you see here are are just different filesystems, holding tablespaces, redo-logs and controlfiles.
A little explanation about what an Oracle database comprises. Sorry in advance if some parts are only vague. I am a Sysadmin, not a DBA, and have only a passing knowledge of databases:
An Oracle database (more correctly: database instance) first has space to store data and index them. This is the DB equivalent of a filesystem. It is called "tablespaces" and from an OS POV it is one or several file(s). Usually one creates - one or more - filesystem(s) for these files because if I/O issues arise one wants to be able to balance the I/O-operations across the involved hardware (disks, adapters, ...).
Where (in the filesystem) all these tablespaces are to be found, how big they are and several other information - name of the instance, used codepage, .... - is stored in a set of "controlfiles". In fact these files are created first when the instance is initially created. These control files are relatively small (just a few MB), but are vital to the operation of the database. Without a fitting set of control files backups of the tablespaces are unusable.
This all is completed by a third class of files: redo-logs. As the database is under load, data get stored in it. Every such transaction is written to the redo log as it happens. Once such a redo-log is full it is moved to a certain location and called "archive-log" and a new redo-log is started. It is possible to have several redo-logs and use them round-robin (seems to be the case here), but the principle is always the same. With these logs it is possible to either reverse already done transactions (="roll back") or, using a previous version of the tablespaces and reapplying the transactions to duplicate them (="roll forward"). The redo-log in principle consists of 4 informations for every transaction:
1) What was the data before the operation;
2) What was the data after the operation;
3) a timestamp;
4) a transaction-ID so that the succession of the transactions is distinct.
OK, so far a (very incomplete) introduction to Oracle workings.
What you can do to free space:
1) check the tablespaces. It might be that they are not full at all. It is possible to resize them, just like filesystems, thereby freeing space. By moving them around you can maybe empty one of the filesystems in use so that you can scratch it. Ask a DBA about how you do that inside Oracle, i just know this is possible but not how it is done.
2) check the archive logs. Archive-logs are not necessary for the running database. Backup them and remove them afterwards, freeing space. If this is not a productive DB instance you might not need them altogether. It is possible to switch off the loging completely, which is done typically in test instances and for initial loads of new database instances, so that archive-logs and redologs are not created at all.
Hello,
My apache was working before, but not anymore. When I try to run this service this way: service httpd start
I get the following error:
Starting httpd: /usr/sbin/httpd: error while loading shared libraries: libpcre.so.0: cannot open shared object file: Permission denied
Anyone... (2 Replies)
Hi,
I am working on device drivers.Once If register a device i'll get one major no. If i unregister and register again i'll get a different major no.What i have to do to get same major no. each time :( (0 Replies)
Hello, I have 2 hp-ux both running 11.23, I have move one of a harddisk from "UNIX A" to "UNIX B", so how can I read back the data in "UNIX B"?
Thanks (5 Replies)
Hi.
I have these two variables:
My objective here is to reuse that $file_name variable again and again by resetting the $cv value.
for example, if i reissue the cv="$(print 'CV01')" command, thus $file_name is now should be "CP99978_CV01.TXT", not "CP99978_CV01.TXT" anymore.
How I'm... (7 Replies)
Hi,
I have done NIM restoration via nim_bosinst a lot of times but I have some doubts on restoring a server which is clustered specifically HACMP. Previously, I don't know the trend but after doing a nim_bosinst, I can see the client's hostname is back to "localhost" rather than its original... (0 Replies)
I am newbe to unix.
I have a very serious problem on my server.
I have a java application running, and all day on Monday morning, the process that is associated with this java is locked.
Usually I doing a shutdown by the shutdown java command , you have to kill the process with the kill-kill... (1 Reply)
I have a LUN (From HP-Storage VA7110) that is claimed on 2 servers, but is in used in one of the VG on Server-1 .
Now I want to shut Server-1 and re-use that LUN on server-2 .
Server-1
Path-1 : /dev/rdsk/c4t0d1
Path-2: /dev/rdsk/c6t0d1
Server-2
Path-1: /dev/rdsk/c5t0d1
Path-2:... (8 Replies)
Hi,
Can you help me on booting x86 server configured under VxVM. Server boots fine normally from both the disks but if I try to boot server from mirror disk without starting veritas, then it does not boot.
vxplex -g rootdg dis var-02
vxplex -g rootdg dis swapvol-02
vxplex -g rootdg dis... (2 Replies)
I have a collection of format strings for sscanf, such as
"%02d%*1s%02d%*1s%02d"
to read in certain formatted strings, such as dates, times, etc.
I wonder if there is a way to use them in printf without some changes? The example above would not work - at least I can't think of any ways to... (4 Replies)