[askdba] Re: Database Clone error -- advice for an Oracle Newbie

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Tue, 20 Sep 2005 08:27:21 +0100

Chirag,

Oracle Recovery does not know if your database were in Archive/No Archive 
mode ... 

You are using a Backup Control file command to open the DB .. When you are 
having a Cold Backup with the control Files why do you need to use a Backup 
Control file commnd ... You just need to do Recover Database and Alter 
Database Open Resetlogs.

When you said Backup Control Files .. There is no SCN in the Control file 
and he does not know if the Datafiles you have provided are uptodate that is 
the reason for oracle asking you for logs ... 

BTW - I have started a askDBA Group in orkut ..
[www.orkut.com<http://www.orkut.com>]
to discuss topics which dont belong to Oracle Offline ... :)

Join in guys and we can vent our feelings there ... :)

Cheers
Ganesh

On 18/09/05, Chirag DBA <chiragdba@xxxxxxxxx> wrote:
> 
> Well, well, well..., the whole mail didn answer my Question. But Please 
> read.
>  We have a requirement of a SENIOR DBA, permanent position and I am taking 
> interviews.
>  I am taking interview of guys having 10 -12 yrs experience guys and 
> asking 125,000 salary. 
>  Believe me those are not 10,000 salary p.a. eligible guys. I am surprised 
> to know that 10 -12 yrs guys knows this which is quite less then a guy like 
> me having 3 yrs of experience.
>  One of the lady having 9 yrs of experience working in an MNC, I asked her 
> what will be yr approach when user will come to you saying DB is slow, 
> operations getting hanged??? 
>  She replied me, " I WILL RESTART THE DATABASE." 
>  Our previous DBA having 10 yrs of experience was taking COLDBACKUP of the 
> database (ON SOLARIS) with Database up and running. And management came to 
> know this when they were looking for serious recoveries. Management 
> immediately kicked him out and he found another job in 2 weeks as a DBA. 
>  One guy I asked how will you make sure that all yr transaction will log 
> go to the standby database. I mean how will you make all logs compulsory of 
> the user to keep the standby sync. He told me that he has created and setup 
> the Standby database with Dataguard. 
>  He said, " How can u do that...?, U cant expect the behaviour of User."
>  I don wanna start a new thread here, or not pointing to anybody but just 
> to say that, 
> Yr knowledge depends on From which environment you came. I am in an 
> environment where I have to make all the setup here, while previously in 
> SUN, Everything was ready.
>  NEWBIES will not remain the newbies for long. 
>  BTW, I have solved the problem and my DB is up and running now. I just 
> copied the redolog file to the location it is asking and changed the name to 
> the one it is askingARC00047.001. 
>  But still curious to know that why it asking for the archive log file 
> even though my previous DB was in noarchive log mode. I used the cold backup 
> with redolog files.
>  Regards - 
>  Chirag Majmundar
>  A NEWBIE DBA...!!!
>  
> SQL> recover database using backup controlfile;
> ORA-00279: change 2982738 generated at 09/18/2005 13:55:21 needed for 
> thread 1
> ORA-00289: suggestion : D:\ORACLE\ORA92\RDBMS\ARC00047.001
> ORA-00280: change 2982738 for thread 1 is in sequence #47 
> 
> 
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> 
> Log applied.
> Media recovery complete.
> SQL> alter database open;
> alter database open
> *
> ERROR at line 1:
> ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
> 
> 
> SQL> alter database open resetlogs;
> 
> Database altered.
> 
> SQL> conn chirag/chirag
> Connected.
> SQL> select * from tab;
> 
> TNAME TABTYPE CLUSTERID
> ------------------------------ ------- ----------
> BONUS TABLE
> CHIRAG TABLE
> DEPT TABLE 
> DUMMY TABLE
> EMP TABLE
> SALGRADE TABLE
> 
> 6 rows selected.
> 
> SQL> select * from chirag;
> 
> NO
> ----------
> 1
> 2
> 3
> 4
> 5
> 
> SQL>
> On 9/18/05, Mladen Gogala <gogala@xxxxxxxxxxxxx> wrote: 
> > 
> > 
> > On 09/18/2005 01:46:33 PM, Chirag DBA wrote:
> > 
> > > But after that getting following error.
> > > My original db was not in Archivelog mode still this DB asks for the 
> > > archive file. I have copied redo logs too.
> > > Found on the net says CHECK THE ARCHIVE DESTINATION, but my primary db 
> > was
> > > not in archive log. Any Idea ???
> > ............
> > > 23 'D:\ORACLE\ORADATA\CLONE\XDB01.DBF' 
> > > 24 CHARACTER SET WE8MSWIN1252;
> > >
> > > Control file created.
> > >
> > > SQL> RECOVER DATABASE USING BACKUP CONTROLFILE
> > > ORA-00279: change 2974949 generated at 09/18/2005 12:34:04 needed for 
> > thread 
> > > 1
> > > ORA-00289: suggestion : D:\ORACLE\ORA92\RDBMS\ARC00047.001
> > > ORA-00280: change 2974949 for thread 1 is in sequence #47
> > >
> > >
> > > Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 
> > >
> > 
> > This is an example of the posts which convinced me that dispensing 
> > advice
> > for newbies is not a smart thing to do. The advice for newbies in any
> > kind of profession was given a long time ago. It reads "ora et labora". 
> > One needs to work and read and then work some more. The "ora" part is 
> > not
> > as necessary as the "labora" part. If I ever gave an advice to a newbie 
> > and
> > he came back with a question like this one, I'd have to cover my face 
> > with burka 
> > because I'd feel so ashamed that I would never want to show my face 
> > again. I
> > strongly advise against "introducing Oracle to newbies". If you have a 
> > competent
> > engineer, train him, if you have an incompetent, fire him. Good computer 
> > engineer 
> > must be capable of reading documentation. Messing things up and then 
> > asking not so
> > bright questions is a sign of a hopeless soul who would be better off by 
> > driving a
> > taxi or giving opinions on te Fox News Network then working with Oracle 
> > RDBMS. If 
> > any trainee of mine ever asked a question like this,
> > Lately, Oracle Corp. is stressing ease of use and its new mantra is the 
> > one about the
> > obsolescence not only of a DBA but any qualified technical professional. 
> > The message reads 
> > like this: "It's easy, you don't have to know anything, just buy the 
> > stuff and everything
> > will work". Unfortunately, artificial intelligence still cannot replace 
> > the one produced by
> > the mother nature. Computers in a professional environments are not to 
> > be managed by amateurs 
> > or chaos will ensue. Unfortunately, Oracle Corp. has contributed to such 
> > situation as it has
> > been dispensing OCP certificates to guys asking questions like this. 
> > Therefore, the best advice
> > I can dispense is still "close your eyes and think of England". 
> > 
> > 
> > --
> > Mladen Gogala
> > http://www.mgogala.com
> > 
> > 
> > 
>

Other related posts: