Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> backup controlfile to trace

backup controlfile to trace

From: Fender <nospam.efender_at_ix.netcom.com>
Date: Wed, 21 Feb 2001 15:34:14 -0500
Message-ID: <9718oe$112$1@slb0.atl.mindspring.net>

I need some detailed help on creating a copy of a database. We made a cold backup last night. Currently, we are restoring the datafiles, control files and redo logs to a new location. We want to setup a test environment without creating the tablespaces, datafiles and doing an export/import. I've done an alter database backup controlfile to trace on the live database. The backup controlfile to trace was not done immediately before or after the shutdown for the cold backup. Does this matter? Can I change the database name, or must it stay the same? Should I use the current redo logs from the live DB and let the new database roll forward, or use the redo logs that were backed up? Can I change the database to noarchivelog mode at this time, since this is just for testing purposes?

I've already created an new init<sid>.ora and changed the names of the control files and set archive to false.

Thanks for any help,

Eric Received on Wed Feb 21 2001 - 14:34:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US