Explaination
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Explaination

  1. #1
    Join Date
    Apr 2001
    Posts
    142
    Hello,

    can someone help me with the explaination of what the section of script below is doing?

    sql 'alter system archive log current';
    backup
    format 'c:\temp\al_t%t_s%s_p%p'
    archivelog all
    delete input;

    Thanks

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Archive current log, Archive archived redo logs result goes in one file with unique name then delete archived redo logs.
    Best wishes.


  3. #3
    Join Date
    Apr 2001
    Posts
    142
    OK,

    so if I then loose the redo logfile from the hard disk how do I recreate the file?

    Thanks

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    run {
    allocate channel ch1 type disk;
    resore archivelog all;
    }

  5. #5
    Join Date
    Apr 2001
    Posts
    142
    This recovers the archievelog but what about the redo log files?

    Thanks

  6. #6
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    It is the same,
    'archivelog' = 'archived redo logs' it is almost the same as 'redo log'


  7. #7
    Join Date
    Apr 2001
    Posts
    142
    I know but I have physically deleted one of the online redo logs to see how I recover from that and I get the following after restoreing the database :

    SVRMGR> STARTUP;
    ORACLE instance started.
    Total System Global Area 73242652 bytes
    Fixed Size 75804 bytes
    Variable Size 20631552 bytes
    Database Buffers 52428800 bytes
    Redo Buffers 106496 bytes
    Database mounted.
    ORA-00313: open failed for members of log group 1 of thread 1
    ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORA817\DATABASE\LOGPICIS1A.ORA'

    The LOGPICIS1A.ORA is the redo log.

  8. #8
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    You shoud not delete online redo logs. I told about archived redo logs.
    You should delete info from the db about your log member and add new member to log group.

  9. #9
    Join Date
    Apr 2001
    Posts
    142
    Ok what I am doing is creating different senarios and trying to recover from them, but this one is tricky. I had assumed that you could rebulid the redo logs somehow after said a hard disk failure. Is this not possible? What do you do if you loose the online redo logs?

  10. #10
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    It is possible rebuild online redo logs if you have lost them. Just recriate them. If I lose one online redo log from log group - I have another member on another HD, I hope 2 HD cant crush in the same time. So I just copy or rename log member.

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