Pages

Monday, January 5, 2015

DBID


Contents:- Recovery DBID


Recover DBID for Recovering the Control File ( When DBID Not Known )

Steps

SQL> Startup nomount

SQL> Alter session set tracefile_identifier=ebs;

/* Dump the First Few Blocks of the Datafile. The file of the System Tablespace works perfectly. So dump 10 blocks in which you will find dbid */

SQL> Alter system dump datafile '+PROQA3DATA1/PROQA3/PROQA1_system_01.dbf' block min 1 block max 10;


/* Check the trace file directory for a file with the term "EBS" in it you will find your database dbid into that */

No comments:

Post a Comment