-
control file for data guard
Hi
I am in process to create standby database. I am wondering that while I issued this---
alter database create standby controlfile 'filename'
it will create only one controlfile ,do I needt to issue three file name or what?
Any help would be appreciated
thanks in advance
-
Just copy it to a new name as many times as you need.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
-
During standby database open up I am getting this error, so I am wondering do I need to recreate or modify standby controlfile?
C:\Documents and Settings\Lisa>set oracle_sid=newstand
C:\Documents and Settings\Lisa>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jul 28 09:22:51 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 126950220 bytes
Fixed Size 453452 bytes
Variable Size 109051904 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover automatic standby database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'
SQL> recover automatic standby database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'
Thanks in advance
-
you need to have db_filename_convert set (or whatever the parameter is) if the locations are not the same as the primary
-
Thanks davey23uk.
I did it in my init.ora file. *.db_file_name_convert='C:/oracle/oradata/standby',
'C:/oracle/oradata/NEWSTAND'
here do I need to specify each file or what?
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|