Re: Oracle Recovery

Thank you for replying.

Tried that and ran the SQL through the server manager. Unfortunately it still wont let me log in as a user.

Nigel.

On Mon, 24 Jul 2000 19:18:04 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>On the old database
>issue
>alter database backup controlfile to trace
>
>This will create a file in the <user_dump_dest> directory.
>Run this file (if necessary adapted) on the destination box.
>
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>"Nigel" <ntavendaleREMOVE_at_FORsaegroupSPAM.com> wrote in message
>news:69nonsceoihiv5uli1r0qmo48d1fnajvmi_at_4ax.com...
>> Here is my problem:
>>
>> I am running Oracle 805 On A Solaris 7 Sparc Box. I want to do a cold
>> backup and then restore the database on another, separate Solaris 7
>> sparc Box.
>>
>> Here is what I did:
>>
>> I installed Solaris on the new box.
>>
>> I installed oracle on this box with an identical directory structure
>> to the old one.
>>
>> I shut down the instance. (I diddn't run the catrep.sql file as I
>> diddn't thing it needed to be doone since I would be copying an entire
>> new set of files).
>>
>> I did my cold backup on the Old Box.
>>
>> I pullled over all the files (Control files, log files and data files
>> as well as the initsid.ora and configsid.ora files and the orapwsid
>> file) onto the new box.
>>
>> I copied the files ionto their correct locations.
>>
>> I started up the database which mounted and opened.
>>
>> Now I can log into sqlplus as SYS and select from v$datafile etc but
>> when I try to log in as an ordinary user I get the following:
>>
>> ORA-00600 arguments [12700],[10],[4294455],[1],[],[],[],[]
>>
>> I looked into the alert file which told me there was an error in the
>> .trc file and in the trc file it had an error that said SNAPSHOT too
>> old. Neither database was or is in Archive Log Mode.
>>
>> I have two questions:
>>
>> 1 - Is what I am trying to do possible?
>>
>> 2 - Where did I go wrong if it is?
>>
>> Any help greatly appreciated,
>>
>> Nigel.
>
Received on Mon Jul 24 2000 - 00:00:00 CDT