Is connect internal,mounting the DB possible after Db crashes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Is connect internal,mounting the DB possible after Db crashes

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Hope you'll had a nice weekend!

    Query:

    1.Say,after I run the Analyze command on Scott.emp table.
    Wherein should I look For the analysed statistics for the above table.I mean to say which Table.Should I look into DBA_TABLES.

    2.After I run the command:

    ALTER DATABASE BACKUP CONTROFILE TO TRACE

    Should I run the TraceId File generated in the Nomount stage by doing the following:

    SVRMGR>@C:\oracle\oradata\admin\dbname\Tracefile

    which would create the new Control File for me.

    Is this Ok!

    3.If the DB crashes,could we at least connect as Internal and mount the DB.Is this possible!

    4.What are the possible steps to insert Datas into Datawarehousing Tables like Dimension Tables,Fact Tables,etc.,
    What tools should we use for the above to insert datas.


    Thanks&Regards

    Amit.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    why you dont try it on a test database?

    It wouldnt hurt if you have some reading on Oracle docos too

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