Home » RDBMS Server » Server Administration » error while cloning database
error while cloning database [message #128687] Wed, 20 July 2005 02:52 Go to next message
dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore
Member

i am cloning to mydb8 database to mydb9. while cloning am getting the following error.

ORA-00279: change 100961 generated at 07/20/2005 12:35:33 needed for thread 1
ORA-00289: suggestion :
/home/oracle/flash_recovery_area/MYDB9/archivelog/2005_07_20/o1_mf_1_35_%u_.arc
ORA-00280: change 100961 for thread 1 is in sequence #35


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

how do i solve this problem?
Re: error while cloning database [message #128694 is a reply to message #128687] Wed, 20 July 2005 03:18 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Looks like the database wants to recover from an archive log file. When it asked for the file name, it was told to try a file called "ALTER".

Is this running from a script? If so, fix the script or execute the commands one-by-one so it doesn't see successive commands as file names.

Best regards.

Frank
Previous Topic: Contraints-urgent
Next Topic: database creation problem
Goto Forum:
  


Current Time: Sat Jan 25 06:38:37 CST 2025