OraFAQ Forum: Data Guard » Standby Database error

Home » Server Options » Data Guard » Standby Database error

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

Standby Database error [message #252704]

Thu, 19 July 2007 13:21

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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Standby Database error [message #252705 is a reply to message #252704]

Thu, 19 July 2007 13:24

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

This is urgent can anyone help

Report message to a moderator

Re: Standby Database error [message #252706 is a reply to message #252705]

Thu, 19 July 2007 13:30

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?

Report message to a moderator

Re: Standby Database error [message #252707 is a reply to message #252706]

Thu, 19 July 2007 13:41

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

Report message to a moderator

Re: Standby Database error [message #252708 is a reply to message #252707]

Thu, 19 July 2007 13:43

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.

Report message to a moderator

Re: Standby Database error [message #252712 is a reply to message #252708]

Thu, 19 July 2007 13:56

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

cold backup

and i used

Code: [Select all] [Show/ hide]

alter datatbase create standby controlfile as 'h:directory'

Report message to a moderator

Re: Standby Database error [message #252714 is a reply to message #252712]

Thu, 19 July 2007 14:02

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

Code: [Select all] [Show/ hide]

alter datatbase create standby controlfile as 'h:directory'

In mount or open stage??

Report message to a moderator

Re: Standby Database error [message #252715 is a reply to message #252714]

Thu, 19 July 2007 14:07

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

mounted and opened. that is the production version that i did this on

Report message to a moderator

Re: Standby Database error [message #252716 is a reply to message #252704]

Thu, 19 July 2007 14:14

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

Report message to a moderator

Re: Standby Database error [message #252717 is a reply to message #252716]

Thu, 19 July 2007 14:21

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Standby Database error [message #252718 is a reply to message #252717]

Thu, 19 July 2007 14:31

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Standby Database error [message #252720 is a reply to message #252718]

Thu, 19 July 2007 14:38

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

###########################################
# 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

Code: [Select all] [Show/ hide]

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

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

what should the archive log entries look like in the pfile for the standby

Report message to a moderator

Re: Standby Database error [message #252724 is a reply to message #252721]

Thu, 19 July 2007 15:22

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Are you wanna configure dataguard?
Do you want specify one archive location to standby?

Code: [Select all] [Show/ hide]

Log_archive_dest_2=’Service=to_standby
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=standby’

Report message to a moderator

Re: Standby Database error [message #252854 is a reply to message #252720]

Fri, 20 July 2007 07:02

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

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

Report message to a moderator

Re: Standby Database error [message #252890 is a reply to message #252854]

Fri, 20 July 2007 08:50

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.

Report message to a moderator

Re: Standby Database error [message #252932 is a reply to message #252890]

Fri, 20 July 2007 13:53

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

Report message to a moderator

Re: Standby Database error [message #252937 is a reply to message #252932]

Fri, 20 July 2007 15:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Post Archive log list from both primary and standby.

Report message to a moderator

Re: Standby Database error [message #253017 is a reply to message #252937]

Sat, 21 July 2007 09:31

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

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

GPKAT001S14277.ARC
GPKAT001S14278.ARC
GPKAT001S14279.ARC
GPKAT001S14280.ARC
GPKAT001S14281.ARC

Report message to a moderator

Re: Standby Database error [message #253329 is a reply to message #253017]

Mon, 23 July 2007 09:35

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

post the result of these 2 queries.

run on Primary
==============

Code: [Select all] [Show/ hide]

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

Run on standby
==============

Code: [Select all] [Show/ hide]

•	SQL> Select Name, Applied, Archived
from v$Archived_log;

Report message to a moderator

Re: Standby Database error [message #253723 is a reply to message #253329]

Tue, 24 July 2007 13:15

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.

Report message to a moderator

Previous Topic:	logical stanby with wirte acess
Next Topic:	ora_mrp0 in Oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 10 02:28:22 CDT 2025