Home » RDBMS Server » Backup & Recovery » Backup Control file
Backup Control file [message #259017] Tue, 14 August 2007 02:54 Go to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
Is it possible to make a backup of the control file Oracle 10gR2 on a production system using the below command
Alter database begin backup
alter database create standby controlfile as '/u01/app/oracle/standby.ctl';
alter database backup controlfile to '/u01/app/oracle/control01.ctl';
alter database end backup

I tried to use both the above control files on standby and it gives the error

On standby database
--------------------
sqlplus /nolog
connect / as sysdba
startup no mount
alter database mount standby database

Unable to open the control file
ORA-27047: unable to read the header block of file


I checked the path of control files on primary and secondary both the same

Re: Backup Control file [message #259020 is a reply to message #259017] Tue, 14 August 2007 03:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What are the additional information?
Re: Backup Control file [message #259021 is a reply to message #259017] Tue, 14 August 2007 03:25 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
Primary is on Solaris 5.10 on AMD 64bit and Secondary is on Solaris 5.9 Sparc 64bit
Re: Backup Control file [message #259023 is a reply to message #259017] Tue, 14 August 2007 03:43 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
ORA-00202: control file:
ORA-27047: unable to read the header block of file
Additional information: 2
ORA-205 signalled during: alter database mount standby database...
Re: Backup Control file [message #259026 is a reply to message #259017] Tue, 14 August 2007 04:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I think your controlfile is not available. Check init.ora file to it's path and see in that path it is available or not. Also chack whether oracle has permission on it or not.
Re: Backup Control file [message #259028 is a reply to message #259017] Tue, 14 August 2007 04:10 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member

The control file is also available i checked the path of spfile
show parameter spfile and its available
Also oracle has rw permission on all the 3 control files
Re: Backup Control file [message #259184 is a reply to message #259028] Tue, 14 August 2007 10:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Alter database begin backup
alter database create standby controlfile as '/u01/app/oracle/standby.ctl';
alter database backup controlfile to '/u01/app/oracle/control01.ctl';
alter database end backup



Why you put the whole database in backup mode for controlfile???
bring it back in normal mode and enter this command.

•	SQL> Alter database create standby controlfile as ‘c:\oracle\backup\standcontrol.ctl’;
Re: Backup Control file [message #394163 is a reply to message #259184] Wed, 25 March 2009 22:04 Go to previous messageGo to next message
mtrothe
Messages: 3
Registered: March 2009
Location: Sydney
Junior Member
I created my backup control file that way, renamed all the datafiles and redo files and reset the Log_archive_dest in the INIT.ora file , but when I got to the restore on the standby database I got;


SQL> recover standby database;
ORA-00279: change 244889854 generated at 03/26/2009 10:44:02 needed for thread
1
ORA-00289: suggestion : /rman_bkp/sd-db/archives/arch_1_15264.arc
ORA-00280: change 244889854 for thread 1 is in sequence #15264


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log '/rman_bkp/sd-db/archives/arch_1_15264.arc'
ORA-27047: unable to read the header block of file
Additional information: 2


ORA-00308: cannot open archived log '/rman_bkp/sd-db/archives/arch_1_15264.arc'
ORA-27047: unable to read the header block of file
Additional information: 2


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/rman_bkp/sd-db/dbssystem01.dbf'

Anybody know what causes this or how to fix it
Re: Backup Control file [message #394164 is a reply to message #259017] Wed, 25 March 2009 22:07 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>SQL> recover standby database;
>ORA-00279: change 244889854 generated at 03/26/2009 10:44:02 needed for thread 1
>ORA-00289: suggestion : /rman_bkp/sd-db/archives/arch_1_15264.arc
>ORA-00280: change 244889854 for thread 1 is in sequence #15264


Supply the missing /rman_bkp/sd-db/archives/arch_1_15264.arc file
Re: Backup Control file [message #394266 is a reply to message #394164] Thu, 26 March 2009 06:07 Go to previous messageGo to next message
mtrothe
Messages: 3
Registered: March 2009
Location: Sydney
Junior Member
It isnt missing an Archivelog it has them , it cant open them

ORA-00308: cannot open archived log '/rman_bkp/sd-db/archives/arch_1_15264.arc'
ORA-27047: unable to read the header block of file
Additional information: 2
Re: Backup Control file [message #394273 is a reply to message #394266] Thu, 26 March 2009 06:29 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Try Cancel based recover

babu
Re: Backup Control file [message #394292 is a reply to message #394273] Thu, 26 March 2009 07:02 Go to previous messageGo to next message
mtrothe
Messages: 3
Registered: March 2009
Location: Sydney
Junior Member
Laughing I am trying to create a standby database, it has to be able to read the archive logs of the original database to update the standby database, so cancel isnt a good idea

I created my backup control file that way, renamed all the datafiles and redo files and reset the Log_archive_dest in the INIT.ora file , but when I got to the restore on the standby database I got;


SQL> recover standby database;
ORA-00279: change 244889854 generated at 03/26/2009 10:44:02 needed for thread
1
ORA-00289: suggestion : /rman_bkp/sd-db/archives/arch_1_15264.arc
ORA-00280: change 244889854 for thread 1 is in sequence #15264


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log '/rman_bkp/sd-db/archives/arch_1_15264.arc'
ORA-27047: unable to read the header block of file
Additional information: 2


ORA-00308: cannot open archived log '/rman_bkp/sd-db/archives/arch_1_15264.arc'
ORA-27047: unable to read the header block of file
Additional information: 2


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/rman_bkp/sd-db/dbssystem01.dbf'

Anybody know what causes this or how to fix it


Re: Backup Control file [message #394954 is a reply to message #394292] Mon, 30 March 2009 21:14 Go to previous messageGo to next message
adhika_rexuss
Messages: 3
Registered: March 2009
Junior Member
Why don't you just recreate the dataguard?
Re: Backup Control file [message #397358 is a reply to message #259021] Fri, 10 April 2009 05:33 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
preet_kumar wrote on Tue, 14 August 2007 15:25
Primary is on Solaris 5.10 on AMD 64bit and Secondary is on Solaris 5.9 Sparc 64bit


I'm very surprise if you can configure DataGuard in the Little Edian(AMD) & Big Edian(Sparc).

First, following the Oracle documents:
Quote:

2.3.1 Hardware and Operating System Requirements

The following list describes hardware and operating system requirements for using Data Guard:

* All members of a Data Guard configuration must run an Oracle image that is built for the same platform.

For example, this means a Data Guard configuration with a primary database on a 32-bit Linux on Intel system can have a standby database that is configured on a 32-bit Linux on Intel system. However, a primary database on a 64-bit HP-UX system can also be configured with a standby database on a 32-bit HP-UX system, as long as both servers are running 32-bit images.

* The hardware (for example, the number of CPUs, memory size, storage configuration) can be different between the primary and standby systems. If the standby system is smaller than the primary system, you may have to restrict the work that can be done on the standby system after a switchover or failover. The standby system must have enough resources available to receive and apply all redo data from the primary database. The logical standby database requires additional resources to translate the redo data into SQL statements and then execute the SQL on the logical standby database.

* The operating system running on the primary and standby locations must be the same, but the operating system release does not need to be the same. In addition, the standby database can use a different directory structure from the primary database.


"Getting Started with Data Guard"

Second, the stack, block size,.. of files are different between them. Example:

In the x86_64 Solaris:
$ su
Password:
# psrinfo -v
Status of virtual processor 0 as of: 04/10/2009 17:34:29
  on-line since 03/30/2009 12:29:31.
  The i386 processor operates at 2991 MHz,
        and has an i387 compatible floating point processor.
# ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 65536
memory(kbytes) unlimited
# ulimit -Ss
10240
# df -g | grep "block size"
/                  (/dev/dsk/c0t0d0s0 ):         8192 block size          1024 f
rag size
/devices           (/devices          ):          512 block size           512 f
rag size
/system/contract   (ctfs              ):          512 block size           512 f
rag size
/proc              (proc              ):          512 block size           512 f
rag size
/etc/mnttab        (mnttab            ):          512 block size           512 f
rag size
/etc/svc/volatile  (swap              ):         4096 block size          4096 f
rag size
/system/object     (objfs             ):          512 block size           512 f
rag size
/lib/libc.so.1     (/usr/lib/libc/libc_hwcap2.so.1):     8192 block size
  1024 frag size
/dev/fd            (fd                ):         1024 block size          1024 f
rag size
/tmp               (swap              ):         4096 block size          4096 f
rag size
/var/run           (swap              ):         4096 block size          4096 f
rag size
/swap              (/dev/dsk/c0t1d0s0 ):         8192 block size          1024 f
rag size
/export/home0      (/dev/dsk/c0t1d0s7 ):         8192 block size          1024 f
rag size
/export/home       (/dev/dsk/c0t0d0s7 ):         8192 block size          1024 f
rag size
/vnpbackup_level0  (/dev/dsk/c0t0d0s3 ):         8192 block size          1024 f
rag size
/vnpbackup_level1  (/dev/dsk/c0t1d0s1 ):         8192 block size          1024 f
rag size
#


And in the Sparc
$ psrinfo -v
Status of virtual processor 0 as of: 04/10/2009 17:38:37
  on-line since 03/29/2009 20:20:42.
  The sparcv9 processor operates at 1800 MHz,
        and has a sparcv9 floating point processor.
Status of virtual processor 2 as of: 04/10/2009 17:38:37
  on-line since 03/29/2009 20:20:37.
  The sparcv9 processor operates at 1800 MHz,
        and has a sparcv9 floating point processor.
Status of virtual processor 16 as of: 04/10/2009 17:38:37
  on-line since 03/29/2009 20:20:42.
  The sparcv9 processor operates at 1800 MHz,
        and has a sparcv9 floating point processor.
Status of virtual processor 18 as of: 04/10/2009 17:38:37
  on-line since 03/29/2009 20:20:42.
  The sparcv9 processor operates at 1800 MHz,
        and has a sparcv9 floating point processor.
$ ulimit -s
8192
$ ulimit -Ha
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
coredump(blocks)     unlimited
nofiles(descriptors) 65536
vmemory(kbytes)      unlimited
$ df -g | grep "block size"
/                  (/dev/md/dsk/d10   ):         8192 block size          1024 f
rag size
/devices           (/devices          ):          512 block size           512 f
rag size
/system/contract   (ctfs              ):          512 block size           512 f
rag size
/proc              (proc              ):          512 block size           512 f
rag size
/etc/mnttab        (mnttab            ):          512 block size           512 f
rag size
/etc/svc/volatile  (swap              ):         8192 block size          8192 f
rag size
/system/object     (objfs             ):          512 block size           512 f
rag size
/platform/sun4u-us3/lib/libc_psr.so.1(/platform/sun4u-us3/lib/libc_psr/libc_psr_
hwcap2.so.1):     8192 block size          1024 frag size
/platform/sun4u-us3/lib/sparcv9/libc_psr.so.1(/platform/sun4u-us3/lib/sparcv9/li
bc_psr/libc_psr_hwcap2.so.1):     8192 block size          1024 frag size
/dev/fd            (fd                ):         1024 block size          1024 f
rag size
/tmp               (swap              ):         8192 block size          8192 f
rag size
/var/run           (swap              ):         8192 block size          8192 f
rag size
/u01               (/dev/md/dsk/d30   ):         8192 block size          1024 f
rag size
/u02               (/dev/md/dsk/d40   ):         8192 block size          1024 f
rag size
/vnprctl           (/dev/dsk/c4t600A0B8000482FB20000044C47E9CED8d0s0):     8192
block size          1024 frag size
/vnporadataSYSTEM  (/dev/dsk/c4t600A0B8000482FB20000045247E9D08Ad0s0):     8192
block size          1024 frag size
/vnporadataUSERS   (/dev/dsk/c4t600A0B8000482FB20000044F47E9CF52d0s0):     8192
block size          1024 frag size
$


Previous Topic: when i am trying to import files in ora9i, I am getting the following error.
Next Topic: Unable to perform restore
Goto Forum:
  


Current Time: Wed Dec 07 10:48:05 CST 2016

Total time taken to generate the page: 0.07124 seconds