Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

recover database until cancel using backup controlfile Fails with ORA-01547

980804Apr 2 2013 — edited Apr 7 2013
Hi
First of all, I'm sorry for posting in this community as my issue doesn't have any thing to do with Rman, but I couldn't find any more relative Community to post in

our System is Oracle EBS 11i and the OS on the production is AIX 5.2 / and the DR is 5.3 / DB version is 9i

we have our Oracle ERP scheduled using crontab to take a database COLD backup daily using gtar -cvzf .
yesterday I needed to clone the database only, so I used my usual method witch is
1) on the source SQL> alter database backup controlfile to trace as '<dest>/makecntrlfil.sql'
then you can delete the Commented header and change the first command from
"CREATE CONTROLFILE REUSE DATABASE <SOURCE> NORESETLOGS ..."
TO
CREATE CONTROLFILE SET DATABASE <TARGET> RESETLOGS <NO>ARCHIVELOG
2) de-compress the tgz files
3) on the target edit the $ORACLE_HOME/dbs/init<source>.ora, $ORACLE_HOME/environment file
4)run /ORACLE_HOME/appsutils/clone/bin/adcfgclone.prl
5) delete old controlfiles
6) on the database run the script you created on firs t step to create a new control fole
7)recover database until cancel using backup controlfile
8) alter database open resetlogs
add new temp file system

this way I used to do it
but yesterday when trying to execute recover database it didn't work, and gave this error

ORA-00279: change 6450277404 generated at 02/28/2013 02:47:56 needed for thread
1
ORA-00289: suggestion : /ERPDEV/DBASE/devdb/9.2.0/dbs/arch1_188462.dbf
ORA-00280: change 6450277404 for thread 1 is in sequence #188462
Specify log: {<RET>=suggested | filename | AUTO | CANCEL} >> I gave cancel >> so >>

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/ERPDEV/DBASE/SYS/devdata/system01.dbf'


nothing strange in the original alert log file in the time of taking the backup

So can You please tell me what maybe wrong and why it used to work before and now it's not

take in consideration that we are on archive log mode, but not using Rman or the archived Logs for backup and the sequence it needed ( 188462 ) is too old and already deleted on Production.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2013
Added on Apr 2 2013
15 comments
8,124 views