Database Administration (MOSC)

MOSC Banner

clone a database with cold backup

edited Dec 12, 2013 10:29AM in Database Administration (MOSC) 16 commentsAnswered
 hi guys,
a quick check, i will be cloning a database with a set of cold backup files.
The cold backup was taken from a noarchivelog mode database

my question:
when my controlfile is already created, is it ok to use either alter database open resetlogs; 
or alter database open ?

my clone db will be in noarchivelog mode. so my guess it should just be alter database open . so that i can save my time in changing my db from archivelog mode to noarchivelog mode.

please further confirm. tks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center