[Ashish]

database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/26/2012 13:28:51
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/oas.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/system01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_10_7xgyw7gg_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_9_7xgyw6h6_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_8_7xgyw5hl_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_7_7xgyw4jj_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_6_7xgyw3kt_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_5_7xgyw2kn_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_4_7xgyw1o6_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo02.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo01.log conflicts with a file used by the target database

RMAN>

[Ashish]

When i am trying to run below commond on oracle table where we need to change Varchar2  to date DATA type for resp column: 

insert into evaluation_new (CREATEDDATE)
(Select  To_date(CREATEDDATE,’yyyy-mm-dd hh24:mi:ss’)
from evaluation_detail);

 

Error:

ORA-01830: date format picture ends before converting entire input string
01830. 00000 –  “date format picture ends before converting entire input string”
*Cause:   
*Action:

(Note: Old str of column   “2009-09-16 18:38:00.000”)

 Please help me for the same

[Ashish]

Thanx Amit,

Via Sql loader i loaded one sql server table data in Oracle by changing the datatype to varchar2 ,  Now i want to change as it is, so how to write Procedure for the same by which i can changed the data type of oracle Table? (  I was facing problem in date format so i changed it to varchar, then all data loaded proprly appx 140524 rows)

OR

Please tell me any other way to chage data type.

Regards,

AShish

[Ashish]

Thanx Saurabh

[Ashish]

Apology for that,

Please tell whats logic behind this preinstaalation step wen we need to install Database in Linux system?

It’s only for Block size?

[Ashish]

Hi Amit,

Still i am confused on this point,

When we take database in backup mode (User-manage Backup) so more redo is generated .

and In RAMAN , if u take DB in Backup mode Redo generated?

If it genarate less than User-manage ,so how?

Please cleare my confusion.

Regards,

Ashish

[Author]

Posts