Home » Server Options » Data Guard » Standby Database error
Standby Database error [message #252704] Thu, 19 July 2007 13:21 Go to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

i was trying to create a standby database on a remote machine and did the following steps

1. shutdown the production database
2. did a backup of the datafiles to tape
3. transfered thefiles from the tape to the standby machine
4. Configured a new DB instance service for the standby database
5. configured teh parameters
6. started the database using
startup nomount;
   alter database mount standby database
SQL> recover automatic standby database
ORA-00279: change 1057430757 generated at 07/18/2007 18:34:14 needed for thread
1
ORA-00289: suggestion : H:\ARCHIVE\GPKA\STANDBYGPKAT001S14278.ARC
ORA-00280: change 1057430757 for thread 1 is in sequence #14278
ORA-00278: log file 'H:\ARCHIVE\GPKA\STANDBYGPKAT001S14278.ARC' no longer
needed for this recovery
ORA-00308: cannot open archived log 'H:\ARCHIVE\GPKA\STANDBYGPKAT001S14278.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
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: 'E:\ORACLE\ORADATA\GPKA\SYSTEM01.DBF'


ORA-01112: media recovery not started   




Re: Standby Database error [message #252705 is a reply to message #252704] Thu, 19 July 2007 13:24 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

This is urgent can anyone help
Re: Standby Database error [message #252706 is a reply to message #252705] Thu, 19 July 2007 13:30 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you take backup through rman ?
Did you create Standby controlfile or just copy the existing controlfile?
If your backup was hot did you move all archivelogs?
Re: Standby Database error [message #252707 is a reply to message #252706] Thu, 19 July 2007 13:41 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

i did a manual backup to tape after downing the database
i created a standby controfile
and i copied all the logs
Re: Standby Database error [message #252708 is a reply to message #252707] Thu, 19 July 2007 13:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
i did a manual backup to tape after downing the database


What is manual backup?? you mean cold?

Quote:
i created a standby controfile


In mount stage or open stage.? If you took cold backup then make standby controlfile in mount stage.
Re: Standby Database error [message #252712 is a reply to message #252708] Thu, 19 July 2007 13:56 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

cold backup

and i used

alter datatbase create standby controlfile as 'h:directory'
Re: Standby Database error [message #252714 is a reply to message #252712] Thu, 19 July 2007 14:02 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
bank_master wrote on Thu, 19 July 2007 12:56
cold backup

and i used

alter datatbase create standby controlfile as 'h:directory'




In mount or open stage??
Re: Standby Database error [message #252715 is a reply to message #252714] Thu, 19 July 2007 14:07 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

mounted and opened. that is the production version that i did this on
Re: Standby Database error [message #252716 is a reply to message #252704] Thu, 19 July 2007 14:14 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

can u bare with me a bit i have been forcd into the DBA role because the DBA resigned before completing training so i am a bit at sea for a while

another question how does the database know where to look fo rto get the archive logs
Re: Standby Database error [message #252717 is a reply to message #252716] Thu, 19 July 2007 14:21 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u200/oracle/espsvcs/oraarc
Oldest online log sequence     932
Next log sequence to archive   941
Current log sequence           941


and

SQL> ;
  1   select name from v$archived_log;
NAME
--------------------------------------------------------------------------------
/u200/oracle/espsvcs/oraarc/arch_1_933_623881327.arc
/u200/oracle/espsvcs/oraarc/arch_1_934_623881327.arc
/u200/oracle/espsvcs/oraarc/arch_1_935_623881327.arc
/u200/oracle/espsvcs/oraarc/arch_1_936_623881327.arc
/u200/oracle/espsvcs/oraarc/arch_1_937_623881327.arc
/u200/oracle/espsvcs/oraarc/arch_1_938_623881327.arc
/u200/oracle/espsvcs/oraarc/arch_1_939_623881327.arc
Re: Standby Database error [message #252718 is a reply to message #252717] Thu, 19 July 2007 14:31 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            e:\oracle\ora81\RDBMS
Oldest online log sequence     108636
Next log sequence to archive   108638
Current log sequence           108638

SQL> select name from v$archived_log;

no rows selected


Im getting that but how do u set the archive destination i didnt set that in my PFILE
Re: Standby Database error [message #252720 is a reply to message #252718] Thu, 19 July 2007 14:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL>  show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string      $ESPSVCS_ORAARC
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string


entries from PFILE

###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
#log_archive_start = true
log_archive_dest = $ESPSVCS_ORAARC
log_archive_format = arch_%t_%s_%r.arc



you can change it like
SQL> alter system set log_archive_dest='/export/home/oracle';

System altered.

SQL>

[Updated on: Thu, 19 July 2007 14:43]

Report message to a moderator

Re: Standby Database error [message #252721 is a reply to message #252720] Thu, 19 July 2007 14:42 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

what should the archive log entries look like in the pfile for the standby
Re: Standby Database error [message #252724 is a reply to message #252721] Thu, 19 July 2007 15:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Are you wanna configure dataguard?
Do you want specify one archive location to standby?

Log_archive_dest_2=’Service=to_standby
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=standby’
Re: Standby Database error [message #252854 is a reply to message #252720] Fri, 20 July 2007 07:02 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

how do u tell teh standby database where to get the archive logs from?
Re: Standby Database error [message #252890 is a reply to message #252854] Fri, 20 July 2007 08:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I have one question for you .
Do you want to configure dataguard for your Database?


Quote:
how do u tell teh standby database where to get the archive logs from?


It have lot of steps how standby knows about the archivelogs and how to apply those logs on standby datafiles.

Let suppose we have two server A & B.Let A is your prod and B is your standby,we do some parameters changes in PFILE/SPFILE on both A & B side for database syncrohnization.
And on server B we execute some commands in mount stage in order to apply archivelogs shipped from server A.There are some tables/views from where you can monitor the whole activity.
Re: Standby Database error [message #252932 is a reply to message #252890] Fri, 20 July 2007 13:53 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

i am running the standby on oracle 8i but the logs dont sem to be applying from the right directory it is looking elsewhere
Re: Standby Database error [message #252937 is a reply to message #252932] Fri, 20 July 2007 15:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Post Archive log list from both primary and standby.
Re: Standby Database error [message #253017 is a reply to message #252937] Sat, 21 July 2007 09:31 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

these are the logs on the production machine as you cansee the logs on the production machine continue to generate but i have stopped the transfer to the standby site

GPKAT001S14277.ARC
GPKAT001S14278.ARC
GPKAT001S14279.ARC
GPKAT001S14280.ARC
GPKAT001S14281.ARC
GPKAT001S14282.ARC
GPKAT001S14283.ARC
GPKAT001S14284.ARC
GPKAT001S14285.ARC
GPKAT001S14286.ARC
GPKAT001S14287.ARC
GPKAT001S14288.ARC
GPKAT001S14289.ARC
GPKAT001S14290.ARC
GPKAT001S14291.ARC

These are the logs on the standby
GPKAT001S14277.ARC
GPKAT001S14278.ARC
GPKAT001S14279.ARC
GPKAT001S14280.ARC
GPKAT001S14281.ARC

Re: Standby Database error [message #253329 is a reply to message #253017] Mon, 23 July 2007 09:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
post the result of these 2 queries.

run on Primary
==============
•	SQL> Select Status, Error 
from v$Archive_dest 
where dest_id=2;



Run on standby
==============
•	SQL> Select Name, Applied, Archived
from v$Archived_log;
Re: Standby Database error [message #253723 is a reply to message #253329] Tue, 24 July 2007 13:15 Go to previous message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

im away for a while as soon as i get back i will get the info thanks for the support.

Regards,
Kieron.
Previous Topic: logical stanby with wirte acess
Next Topic: ora_mrp0 in Oracle 10g
Goto Forum:
  


Current Time: Fri Mar 29 08:24:32 CDT 2024