| Backup Control file [message #259017] |
Tue, 14 August 2007 02:54  |
preet_kumar
Messages: 204
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 #259023 is a reply to message #259017] |
Tue, 14 August 2007 03:43  |
preet_kumar
Messages: 204
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 #259028 is a reply to message #259017] |
Tue, 14 August 2007 04:10 |
preet_kumar
Messages: 204
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 |
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 |
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 #394266 is a reply to message #394164] |
Thu, 26 March 2009 06:07 |
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 #397358 is a reply to message #259021] |
Fri, 10 April 2009 05:33 |
trantuananh24hg
Messages: 744
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
$
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
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