Skip to Content
author's profile photo Former Member
Former Member

why we need to Remove all the content above the line STARTUP NOMOUNT and below CHARACTER SET URF8?

Hi,

any one please give me the proper reason?

Thanks,

Prasad.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 19, 2015 at 03:28 AM

    Hi Prasad,

    Hope you studied trace file well,as trace file itself is suggesting answer of your query

    why we need to Remove all the content above the line STARTUP NOMOUNT and below CHARACTER SET URF8?

    Please read below contents from the trace file,you'll be able to get your answer.

    Below are two sets of SQL statements, each of which creates a new

    -- control file and uses it to open the database. The first set opens

    -- the database with the NORESETLOGS option and should be used only if

    -- the current versions of all online logs are available. The second

    -- set opens the database with the RESETLOGS option and should be used

    -- if online logs are unavailable.

    -- The appropriate set of statements can be copied from the trace into

    -- a script file, edited as necessary, and executed when there is a

    -- need to re-create the control file.

    Set #1. NORESETLOGS case

    --

    -- The following commands will create a new control file and use it

    -- to open the database.

    -- Data used by Recovery Manager will be lost.

    -- Additional logs may be required for media recovery of offline

    -- Use this only if the current versions of all online logs are

    -- available.

    -- After mounting the created controlfile, the following SQL

    -- statement will place the database in the appropriate

    -- protection mode:

    #2. RESETLOGS case

    --

    -- The following commands will create a new control file and use it

    -- to open the database.

    -- Data used by Recovery Manager will be lost.

    -- The contents of online logs will be lost and all backups will

    -- be invalidated. Use this only if online logs are damaged.

    -- After mounting the created controlfile, the following SQL

    -- statement will place the database in the appropriate

    -- protection mode:

    Generally we requires SQL statements to execute from the above two cases,that's why we need only statements not text from the trace,so we omits the unwanted text or lines from the trace to create script for generation of control files.

    Hope this will help you.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2015 at 03:08 PM

    Hi,

    If resolved kindly close the thread.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.