Home » RDBMS Server » Backup & Recovery » create database from a standby database
create database from a standby database [message #198355] Mon, 16 October 2006 14:06 Go to next message
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?
Re: create database from a standby database [message #198368 is a reply to message #198355] Mon, 16 October 2006 18:47 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>RECOVER DATABASE USING BACKUP CONTROLFILE
Do not do that.
Just create the controlfile(s) & open the database.
Re: create database from a standby database [message #198400 is a reply to message #198368] Tue, 17 October 2006 01:19 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

After create control file possibly oracle ask for media recovery then give simple >
sql> recover database;
sql>alter database open;

Re: create database from a standby database [message #198445 is a reply to message #198355] Tue, 17 October 2006 03:52 Go to previous message
aline
Messages: 92
Registered: February 2002
Member
thk all for your answer. U both are right.
I recreate a second time the controlfile and opened the database.
All is ok now
Previous Topic: VNI-2024 : Couldnt fork authentication process.
Next Topic: Backup a particular partition
Goto Forum:
  


Current Time: Fri Dec 09 23:31:10 CST 2016

Total time taken to generate the page: 0.14735 seconds