help help script ran accidentally
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: help help script ran accidentally

  1. #1
    Join Date
    Jan 2001
    Posts
    72
    Hey gys,
    I accidentally run this script today. Is it going to have any effect on the database apart from log switching?

    I checked from v$instance and it says that the ARCHIVAL is STOPED. Is the below script that caused archival to stop? I don't know either if the db runs in no archive mode or not but I will chek from the ini.ora file to find out. But right now I will be glad if some one can answer this for me.
    Below is the script that I accidentally ran

    set head off
    set pagesize 0
    set linesize 150
    select to_char(sysdate,'MON-DD-YYYY HH24MISS') from dual;
    select * from v$database;
    alter system switch logfile;
    commit;
    select * from v$datafile;
    select * from v$logfile;
    select * from v$log;
    commit;
    alter database backup controlfile to trace noresetlogs;
    alter database backup controlfile to
    '/KK1/DDD1/dbname/trace/udump/dbname_ctl.trc' reuse;

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    don't worry; be HAPPY !!!

    you didn't break anything

    you just switched the logfile which is not a problem.
    you took a backup of the controlfile, that too is not a problem.

    - Rajeev

  3. #3
    Join Date
    Jan 2001
    Posts
    72

    Unhappy

    OH my God. I can breathe now. Thanks so much I am very very very very very very relived right now.
    Thank "U" very much

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Thats a kinda dba script to avoid recreation of control file if something happens. All you are doing is
    taking time stamp and details of database with a list of all datafiles,controlfiles,logfiles and a controlfile backed up to trace and to a seperate location at the end.

    If you want to check your database archive mode enabled or not, see below
    <font face=courier>
    SVRMGR> connect internal
    Connected.
    SVRMGR> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination /ven01/oracle/admin/o817/arch
    Oldest online log sequence 7800
    Next log sequence to archive 7802
    Current log sequence 7802
    </font>



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