"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
news:e4hcm099dk5muc67ea44dar8cc5qnt0mit_at_4ax.com...
> On Fri, 08 Oct 2004 07:07:27 GMT, "marqzik" <marqzik_at_wp.pl> wrote:
>
> >Hello. Please take into consideratio a scenarrio...
> >on left and hardware the same server on right
> >
> >SUN server SUN server
> >Solaris
> >Oracle database
> >
> >And now.
> >Left server is working.
> >But I stopped whole server one month ago and did _full_ backup of all
> >filesystems.
> >After that server and database were operating back for one month.
> >Now.
> >I have second SUN identical server on the right. I did full restore on
this
> >server (of all filesystems). But of course database is not up to date.
> >I can stop oracle on left and move some files to right server.
> >My idea is to do:
> >On the right (new server) remove all (old) dbf files, controll files,
> >redologs.
> >Copy files from the original server (on left) that are has been in "work"
> >for recent month to the second server:
> >dbf files
> >control files
> >and redo logs.
> >
> >Then start new server on right?
> >Is it all I have to do? Or I will meet any problems?
> >Regards
> >
> >
>
>
> No
> On the old server issue (prior to copying anything)
> alter database backup control file to trace
> This will result in a .trc file in your user_dump_dest directory
> now shutdown immediate the old database
> copy database files, redolog files and init.ora to new server.
> Now copy trace file to new server.
> Edit the file, adjusting filenames as necessary
> Remove the comments and follow instructions in the file.
>
> This procedure is called 'cloning a database' and it is published in
> the manuals, and in this group.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Hm..
aha
Received on Fri Oct 08 2004 - 03:15:27 CDT
