Diskspace issue ARC Files....

[petek78]

Hi All,

I am a newbiee to oracle and have an issue with disk space. i have experience with MSSQL but i find it difficult to relate the oracle architecture to SQL.

We have a 100Gb worth of arc files, are these like SQL Transaction logs?
and can i delete these?

I am not sure of how to backup the database and some help with this would be appreciated.

Kind Regards

Pete

[davey23uk]

use rman to back them up, then delete them - and yes they are transaction logs

look up rman at otn.oracle.com for concepts.

Hwoever it is a very large subject and not something you can just easily pick up

[PAVB]

Let me translate for you a couple backup terms, that may help you to better relate your SQL Server experience to the Oracle world.

Simple Recovery Model = noarchivelog mode
Full Recovery Model = archivelog mode

Tip #1:
Since you have archivelog files that means your database is in archivelog mode then it allows for point in time recovery.

Tip #2:
While you may consider a fact of life a SQL Server full recovery model backup being consistent that is not true for a hot backup taken out of a Oracle database running on archivelog mode. To make it consistent you have to further apply archivelogs. That's why the concepts of "restore" and "recovery" are very different and specific in the Oracle world.

Check the documentation as suggested by Dave and have a lot of fun