| URGENT PLEASE - Cloning a database [message #64208] |
Mon, 03 January 2005 00:22  |
Josnei
Messages: 8
Registered: May 2004
|
Junior Member |
|
|
URGENT, PLEASE
Good Morning (in Brazil, 8:30 AM).
I'm trying to clone a archived log database, but I don't have all the archive logs to recover this database. what's the way to do this?
I obtained to create a new instance, recreate the control files, but I'm not obtaining to recover the database, because I not backed up the archive logs.
|
|
|
|
| Re: URGENT PLEASE - Cloning a database [message #64216 is a reply to message #64208] |
Tue, 04 January 2005 04:28  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
Windows or UNIX?
1- UNIX
you can shutdown your db, and copy files to other server (same operating system). Datafiles, controlfiles and redologfiles.
2-windows
shutdown db
stop services
copy files to other server (same operating system)
create service (same SID)
that's it.
Best luck.
|
|
|
|
| Re: URGENT PLEASE - Cloning a database [message #64227 is a reply to message #64208] |
Wed, 05 January 2005 01:14 |
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
|
Senior Member |
|
|
Hi,
This kind of work best performed using RMAN.
If you are cloning the database to another server then you need to ensure you have installed the Oracle home correctly, and that you have pre-created all the database directories. Then on the source database host:
rman nocatalog
connect target /
backup
device type disk
format = '/backuppath/dbname_%u%p%c'
database
current controlfile
spfile
plus archivelog ;
exit;
Then copy the backupsets to the clone host, create the oratab entry, copy the spfile and/or initora.
Then duplicate the database using RMAN after correctly setting the Oracle home and ORACLE_SID:
rman nocatalog
connect auxiliary /
connect target sys/password@sourcedatabase
duplicate target database
NOFILENAMECHECK
dorecover;
exit
Michael Hartley
Openfield Solutions Ltd
www.openfieldsolutions.co.uk
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
