Database Backup and Recovery (MOSC)

MOSC Banner

Clone database (running in noarchivelog mode) from cold backup using SQL

edited Sep 16, 2011 3:46AM in Database Backup and Recovery (MOSC) 8 commentsAnswered ✓
Hi,

I am used to cloning from a database in archivelog mode, but getting internal errors from cloning from database in noarchivelog mode - any suggestions.

Steps performed:-

[-]

SQL> alter database backup controlfile to trace as '/tmp/cr.trc';
scp /tmp/cr.trc newbox:/tmp/cr.sql

log on to new box

Edit cr.sql and substitue as per a normal clone, replacing oldsid with new etc

Performs typically

startup nomount
create controlfile set database newsid resetlogs noarchivelog
....
;
recover database using backup controlfile until cancel;
auto
alter database open resetlogs;

[-]

Shut down source database
Copy database files to new server and directory

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