Backing redo logs using Oracle10g EM

[avion1]

Hi everyone,

I am new to database admin. I have intalled Oracle10g on one of our server. Due to space issue, I deleted redo logs.

Now when I am taking full backup, the Enterprise Manager is looking for those redo logs. Is there a way to start backup from available redo logs.

What will happen if Issue

ALTER DATABASE RESET LOGS;

Please advice.


Thanks in Advacne.

[davey23uk]

why did you delete them? how is your database running more to the point.

Are you sure you didnt delete archived redo logs?

[avion1]

Sorry, I meant was ARCHIVE LOGS.

The database is up and running and we don't any recovery. I just want a full database from now onwards. How do tell rman backup to only user archive logs ?

[davey23uk]

connect to rman and do crosscheck archivelog all; it will check against what it has and what it thinks it has.