Database Backup and Recovery (MOSC)

MOSC Banner

How to continue a broken duplicate database

edited May 7, 2009 11:59PM in Database Backup and Recovery (MOSC) 4 commentsAnswered
 Hi,

I'm duplicating a production DB to a test DB on the same Node, both 10.2.0.2.

Everything worked fine until the SET UNTIL clause.

executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 05/08/2009 09:21:49
ORA-01858: a non-numeric character was found where a numeric was expected

because I forgot to set the NLS_DATE_FORMAT format in the shell.

...I know that there is a to_date function...

Is there a way to continue the duplication or do I have to start all over again?

regards

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