Backing redo logs using Oracle10g EM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Backing redo logs using Oracle10g EM

  1. #1
    Join Date
    Sep 2004
    Posts
    54

    Backing redo logs using Oracle10g EM

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why did you delete them? how is your database running more to the point.

    Are you sure you didnt delete archived redo logs?

  3. #3
    Join Date
    Sep 2004
    Posts
    54
    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 ?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    connect to rman and do crosscheck archivelog all; it will check against what it has and what it thinks it has.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width