I took database backup without "change the controlfile configuration autobackup on".. and unfortunately i deleted my controlfile. Then I tried to restore my controlfile but it gives error,now how can i restore controlfile is there any other way to restore controlfile with aautobackup..
View 17 RepliesWe're running 10.2.0.4 Database on AIX with no catalog Database.We keep all the backup info in controlfiles only.When we do that backup, we're able to successfully back it up (including archivelogs). But I'm unable to find any records in the controlfiles.
SQL> select * from V$BACKUP_SET;
no rows selected
and
SQL> sho parameter control
NAME TYPE VALUE
------------------------------------ ------------------------------
control_file_record_keep_time integer 14
We have Oracle 11g on Windows and Daily full Netbackup on Tape @3:00 Am and on disk @3:00 Pm .When we try to restore DB with following command it restore control file from Disk and Not from Tape .
RMAN> RUN{
2> allocate channel t1 type 'sbt_tape' parms='SBT_LIBRARY=C:WINDOWSsystem32orasbt.dll';
SEND 'NB_ORA_POLICY=ORACLE_DBMS_KTPH12_PROD_BTS_Daily, NB_ORA_SERV=b-nimhp1sys101, NB_ORA_CLIENT= b-btshp1dbs213';4> restore until time "TO_DATE('17-02-2013 03:00:00','dd-mm-yyyy hh24:mi:ss')" controlfile to 'G:oradataTLPRDdcontrol01.ctl' from autobackup;
5> }
Why it is not restring from Tape and Restoring from DISK?
DB:11.2.0.2.0
Oracle Apps:12.1.3
O/S:AIX 6.1 64 bits
RMAN backup throws the error:
RMAN-06169: could not read file header for datafile 40 error reason 1
RMAN-06169: could not read file header for datafile 41 error reason 1
RMAN-06169: could not read file header for datafile 40 error reason 1
released channel: oem_disk_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/14/2012 07:54:43
[code]...
Could we skip the backup of the above missing files using RMAN -> backup database skip inaccessible;On further research, this would compromise tablespace SYSAUX recoverability...Questions:
1) What caused the above missing files to get created?
2) What is recommended: Recover the datafiles?
Can the control file be used to store scripts which are used to perform backups? I know the RMAN recovery catalog can.
Does the SHOW command display detailed reporting on the RMAN catalog contents other than configuration information?
This is what I run
run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dd_oraback/tkprod/%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
sql 'alter system archive log current';
[code]...
So /dd_oraback is a Data Domain mount. Not sure if that makes any difference or not.
How one should know whether RMAN is using target database control file or using separate catalog database. Also what one should do if he dont have catalog users credentials.
View 3 Replies View RelatedMy oracle backup via Netbackup failing with error 6 (Netbackup) and i have checked the logs please find the RMAN log file as well.
Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 15:27:46 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0
[code]....
I have recently patched my catalog home to 9208 from 9204; the target database is still on 9204 but now I cannot connect to the catalog database.
oracle@mogw:TES1:/u01/app/oracle/admin/TES1/bdump
rman rcvcat rman/rman@RMANDB
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
[code]...
While connecting to target database from stand database. I am getting below error.
calhost dbs]$ sqlplus system/oracle@proddb
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:10 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[standdb@localhost dbs]$ rman target system/oracle@proddb auxiliary system/oracle@standdb
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
I am cloning a database from a cold backup in archivelog mode using the control file script but failes:
STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD NORESETLOGS ARCHIVELOG
:
:
:
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORADATA\PROD\TEMP01.DBF'
[code]...
Tried again with RESETLOGS:
STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD RESETLOGS ARCHIVELOG
:
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-00344: unable to re-create online log 'D:\ORADATA\PROD\REDO01B.ORA'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:Users>rman
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 3 16:24:38 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target sys/@proddb
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04002: ocipi failed, ORA--1
when i try to connect with the prod database by logging in the server,then it raise the above error.
i want to aware you with what i have done before it--
(1) this database is running on the port 1526 not on 1521, because of some reason new listner have to made.
(2) i can easily access this database without any error from my local machine, then it doesnot raise-ORA-12154: TNS:could not resolve the connect identifier specified
now i am going to take backup from RMAN at my local machine of same database , then
C:UsersNeetesh>rman target /@proddb
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 3 16:29:47 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
C:UsersNeetesh>
One of database, while taking backup using RMAN, it failed with the following error:
RMAN-03009: failure of backup command on DISK4 channel at 11/28/2012 09:47:29
ORA-19566: exceeded limit of 0 corrupt blocks for file <faile_name>
I used DBV to identify the number of blocks corrupted.
I referred the Metalink iD 457422.1 & 336133.1. But it did not work since the corrupted blocks have got object in it.
I could able to find the object as well. it is one of the table in the datafile.
I used 'ALTER TABLE ... MOVE..' command to see if that works. But again getting the same error while taking the backup and corrupted blocks still exists.
DB Version : 10.2.0.5
OS Version : RHEL 5.6
while executing a clone script i got the below error : -
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/15/2011 20:07:34
RMAN-12010: automatic channel allocation initialization failed
RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog
Here i understand that RMAN couldn't find which SPFILE to use to restore the target DB.
How do i check for the DB_UNIQUE_NAME in recovery catalog?
The proposed solution that i found was Use the FOR DB_UNIQUE_NAME option to specify the name of the instance whose parameter file you want to restore. how to implement this in my clone script?
I have RMAN backup on TAPE. I need to restore control file for particular date on another host. How do I restore control file to new host for particular date?
EXAMPLE:
4949 Full 11.25M SBT_TAPE 00:01:09 06-AUG-12
BP Key: 4949 Status: AVAILABLE Compressed: NO Tag: TAG20120806T223455
Handle: COTSPRD_c-4007601229-20120806-00 Media: 030256
SPFILE Included: Modification time: 28-MAR-12
SPFILE db_unique_name: COTSPRD
Control File Included: Ckp SCN: 237324864 Ckp time: 06-AUG-12
Can I rrun command like :
RESTORE CONTROLFILE FROM TAG 'TAG20120806T223455;
I need to clone from tape to another server for particular date.
I want to use rman to restore all my control files, I just did a level 0 incremental backup and ran the following script.
rman <<EOF
connect target sys/sys@GOLD_AUX
connect catalog rman/rman@GOLD_CAT
RUN
{
STARTUP FORCE NOMOUNT;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN RESETLOGS;
}
EOF
My control files seem to be put back in the correct spot and suggest a way I can restore only my control files and have everything in sync with my datafiles.
end of out from rman script
====================
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/oracle/data/aux/control01.ctl
output filename=/oracle/data/aux/control02.ctl
output filename=/oracle/data/aux/control03.ctl
Finished restore at 29-AUG-10
[code]...
I've recently moved jobs and am doing a lot of the normal things getting familiar with my new company's databases.I was checking through our production backup logs and came across something that looks a little funny. From the last two days backups, I see:
select completion_time, marked_corrupt, media_corrupt, logically_corrupt
from v$backup_datafile
where controlfile_type = 'B'
order by completion_time desc
COMPLETION_TIME MARKED_CORRUPT MEDIA_CORRUPT LOGICALLY_CORRUPT
01/12/2011 11:27:252011 1201 2
01/12/2011 11:26:180 0 0
01/12/2011 11:25:242011 1201 1
01/12/2011 11:15:562011 1201 0
01/12/2011 01:40:100 0 0
30/11/2011 11:23:482011 1130 2
30/11/2011 11:22:440 0 0
30/11/2011 11:21:562011 1130 1
30/11/2011 11:13:002011 1130 0
30/11/2011 01:41:010 0 0
The 01:40 record will come from our nightly command:
BACKUP INCREMENTAL LEVEL=0 FILESPERSET=20 FORMAT 'full_%d_%t_%s_%p'
DATABASE INCLUDE CURRENT CONTROLFILE
The 11AM records will come from the command:
BACKUP INCREMENTAL LEVEL=0 FORMAT 'ctl_%t_%s_%p' CURRENT CONTROLFILE;
(I know backups shouldn't still be running at 11am and we don't need level 0 backups every night, that's a seperate issue I'll be addressing! ) I see there's been a similar entry here in v$backup_datafile for all backups that there's records for. The database is up and running just fine. There are no unusual errors being reported by the database in OEM or the alert log.I tried looking at both our control files (yes, should have 3 - something else I've listed to change!) with dbverify which showed no issues - though I'm not sure if this is designed to work with control files.
If so, how could I confirm whether it's an issue with a specific controlfile (I'm assuming it's not an issue with the backup to tape itself, as it's reporting the same corruption every day)?I'd obviously like to diagnose this now while the db is up and running, rather than at 4am some morning during a crash and finding out my backup control files are no good!
where does the control file auto-backup information gets stored? or how does a RMAN knows from where to restore a controlfile in auto backup?
View 12 Replies View RelatedI've pasted some of the results of an RMAN backup that I ran. It says that it's backing up both the Control File and the SPFILE, but it appears that only one file is being created. Is this correct? How does this work? Are both files combined into the C-3843121877-20120619-00 file?
Starting Control File and SPFILE Autobackup at 19-JUN-12
piece handle=C:ORACLEPRODUCT10.2.0DATABASEC-3843121877-20120619-00 comment=NONE
Finished Control File and SPFILE Autobackup at 19-JUN-12
Also, regarding the below configuration of RMAN - I can change this directory to whatever I want, correct? In other words, is it just the directory where I am putting the backup?
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:ORACLEPRODUCT10.2.0DATABASESNCFPLDG.ORA'; # default
I have installed oracle 11.2 on virtual machine and made two copy of this vm i.e vm1 and vm2...i have taken fullbackup with rman on vm1 and autobackup of control file.Now i want to restore this backup on vm2, for this i have configured channel and other setting. run following command
catalog start with '\server3database_backup
manC-3507808503-20130531-00';
"C-3507808503-20130531-00" is the name of control file autobackup.
RESTORE CONTROLFILE ;
it gives me error RMAN-06496: must use the TO clause when the database is mounted or open...then i use following command
RESTORE CONTROLFILE to 'C:oracleAdministratororadataslate';
then it gives me error RMAN-06024: no backup or copy of the control file found to restore...how to restore control file to vm2
Im trying to restore my spfile and (later controlfile) to a new location:
RMAN> connect catalog rman11cv/pwd@metarep
Connected...
RMAN> connect target
ansluten till msldatabasen: DATABASE (DBID=510270843)
RMAN> run
2> {
3> allocate channel ch1 type 'sbt_tape'
4> PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
5> TRACE 0;
6> Restore spfile to pfile 'y:
estorepfile.ora';
7> }
tilldelad kanal: ch1
kanal ch1: sid=537 devtype=SBT_TAPE
kanal ch1: CommVault Systems for Oracle: Version 9.0.0(BUILD84)
Starting restore at 2011-08-03
frigjord kanal: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore-command failed at 08/03/2011 11:39:26
ORA-27191: sbtinfo2 returned an error
The spfile and control file exists.
RMAN>list backup of spfile
BS-nyckel Typ N Storlek Enhetstyp Tidsσtgσng Slutf÷randetid
------- ---- -- ---------- ----------- ------------ --------------
736698 Full 256.00K SBT_TAPE 00:00:04 2011-08-02
BP-nyckel: 736705 Status: AVAILABLE Komprimerad: NO Tagg: TAG2011080
2T181240
Handtag: dkmj0i8p_1_1 Media: V_73870
SPFILE har inkluderats: Σndringstid: 2011-08-02
In order for the following command to work:
> recover database using backup control file until cancel;
what command must precede it, is it:
> alter database backup control file to trace;
I want to create binary copy of control file every time I do backup. I am using sql "alter database backup controlfile to ''+FRADG/TESTDB/controlfile/controlfile.ctl'' "; in my rman backup script. If I run it second time I got errors as it does does not allow to overwrite existing one.
View 5 Replies View RelatedI have restored all datafile to new location (that is ASM) earlier it was on file system using set new name command (RMAN). Now when i'm trying to update control file with swicth command it is prompting error. Version is 11g R2.
RMAN> SWITCH DATAFILE ALL;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "all": expecting one of: "double-quoted-string, integer, single-quoted-string"
RMAN-01007: at line 1 column 17 file: standard input
We are trying to restore a database to a cold backup DBID.However while our datafiles were backuped up for 6 months retention we found out subsequent delete obsolete command wiped out the Control file related to this backup piece..Now what is left with this backup piece is just datafiles..
Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?
I've got a legacy SAP system with oracle 8i on Tru64. No changes at all are made but for legal reasons we have to keep it up and running.
we currently do a full backup monthly by shutting down oracle and doing a backup of all the files to tape and that takes around 12 hours.
If I stop doing the full backup and I only backup the control file and the archived redo log files every month and I had to restore the full database years from now, would I be able to restore the database using the last full monthly backup and use the latest control file and archived redo log files?
We are getting below error while doing backup of the database through RMAN.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch02 channel at 04/11/2012 00:23:24
ORA-19502: write error on file "/backup/PDWH/RMAN/PDWH_data_820_1_780279469.rmn", block number 961920 (block size=8192)
ORA-27072: File I/O error
Linux Error: 25: Inappropriate ioctl for device Additional information: 4 Additional information: 961920 Additional information: 802816
Even i checked the space & it was good enough to hold the backup.
When we see archive log destination is full , in that case how to backup archive log files using RMAN ?
View 1 Replies View RelatedAfter running the following command:
RUN{
SET NEWNAME FOR DATAFILE 1 TO 'F:oracleproduct10.2.0oradata estsystem01.dbf';
SET NEWNAME FOR DATAFILE 2 TO 'F:oracleproduct10.2.0oradata estundotbs01.dbf';
SET NEWNAME FOR DATAFILE 3 TO 'F:oracleproduct10.2.0oradata estsysaux01.dbf';
SET NEWNAME FOR DATAFILE 4 TO 'F:oracleproduct10.2.0oradata estusers01.dbf';
SET NEWNAME FOR DATAFILE 5 TO 'F:oracleproduct10.2.0oradata estusers02.dbf';
SET NEWNAME FOR DATAFILE 6 TO 'F:oracleproduct10.2.0oradata estperfstat.dbf';
SET NEWNAME FOR TEMPFILE 1 TO 'F:oracleproduct10.2.0oradata est emp01.dbf';
[code]....
Recovery Manager complete.It seems when i run alter database open resetlogs i get this:
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATATESTSYSTEM01.DBF'
I'm trying to write a bat file for the rman backups that can be used for any of our databases. I'm passing variables into the bat file and that is working fine (i.e. oracle_sid, drive letter, oracle_home), my problem is when the rman actually runs and calls the ctl file, the variables aren't being passed thru to that file.
View 3 Replies View Related