alter database open resetlog with ora-01666: controlfile is from standby
I have an issue here after I restore/recovered a backup from source.
On target, restore/recover all finished successfully, but alter database open resetlog with following errors:
ora-01666 .
My steps are following:
1). make a full backup as follows on source (which is a prod standby)
configure controlfile autobackup on;
configure snapshot controlfile name to '/oracle_backup/rman/snapf.f'
BACKUP DATABASE TAG 'FULL'
2). scp the backupsets over to the target
3). in rman , set dbid as the source dbid, restored the snapf.f and then catalog the lcoation.
4). then restore, recover ( all went well).
5). when I did alter database open resetlogs, it give me ora-01666 error.
6). alter database open worked, but the db is now in the standby mode and readonly .
I checked the parameters, the dbname points to the dbname in source, and db_unique_name point to the test name on target. All those two parameters were reset by RMAN Duplicate.
We don't want a standby db, we need a test environment copied from the sourc.e
How do I proceed from here?
Thanks