OraFAQ Forum: Backup & Recovery » create database from a standby database

Home » RDBMS Server » Backup & Recovery » create database from a standby database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create database from a standby database [message #198355]

Mon, 16 October 2006 14:06

aline
Messages: 92
Registered: February 2002

Member

hello,

I tried to create a new database (9.2.0.7) from cold backup of a standby (I can't stop the primary database).
So after the copy I recreated the control files. No problem for this. After I tried to open it.
I fired this query

RECOVER DATABASE USING BACKUP CONTROLFILE

and there oracle asked me for one archive log. I copied it from the primary and Oracle eat it. He asked then for another. And another....

I can't stop this backup controlfile
And I can't open my database


SQL>  startup mount;
ORACLE instance started.
 
Total System Global Area  300280520 bytes
Fixed Size                   745160 bytes
Variable Size             285212672 bytes
DATABASE Buffers           13265920 bytes
Redo Buffers                1056768 bytes
DATABASE mounted.
SQL> ALTER DATABASE open;
ALTER DATABASE open
*
ERROR at line 1:
ORA-01589: must USE RESETLOGS OR NORESETLOGS OPTION FOR DATABASE open
SQL> ALTER DATABASE open  resetlogs;
ALTER DATABASE open  resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: DATA file 1: '/opt/oracle/oradata/RH/system.dbf'
SQL> ALTER DATABASE open;
ALTER DATABASE open
*
ERROR at line 1:
ORA-01589: must USE RESETLOGS OR NORESETLOGS OPTION FOR DATABASE open
 
 
SQL> ALTER DATABASE open noresetlogs;
ALTER DATABASE open noresetlogs
*
ERROR at line 1:
ORA-01588: must USE RESETLOGS OPTION FOR DATABASE open

any idea?

Report message to a moderator