db can only be opened if all the datafile and controlfiles are synchronize.I wonder if db crash and we dont have any kind of backup. is there some way to synchronize the control file with the datafile?....any way.db is not idle either when crashes we can manage data lose.just want our database open
View 1 RepliesI have an oracle autoback of controlfile and spfile. I am trying to restore the production database using this backup, into a new server with a different directory structure.
I have completed the following steps in the restore process.
1. Creating a pfile from spfile
2. Changing the the location of cdump, udump, bdump and the control files ( there are three )
3. Then creating a spfile from this pfile
I am stuck on the next step where to rename all the datafiles and tempfile and restore the database. Following is what I did.
After mounting the database in RMAN, tried to run the following.
RMAN> run
2> {
3> allocate channel c1 device type disk
4> ;
5> @/home/oracle/rman_scripts/newloc.rman
6> SET NEWNAME FOR DATAFILE 1 TO '/u02/oradata/dorian/system01.dbf';
7> SET NEWNAME FOR DATAFILE 2 TO '/u02/oradata/dorian/undotbs01.dbf';
8> SET NEWNAME FOR DATAFILE 3 TO '/u02/oradata/dorian/sysaux01.dbf';
9> SET NEWNAME FOR DATAFILE 4 TO '/u02/oradata/dorian/users01.dbf';
[code]....
I am getting the following error message.
Starting restore at 25-JAN-2012 21:26:48
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/25/2012 21:26:49
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28
[code]....
My server hard disc crashed yesterday and i don't have any backups.
I am able to recover the .dbf files by using a recovery tool.
is it possible to use this .dbf files into new server and recover my data.
I am trying to backup my entire database's files :
[oracle@testing-oracle-1 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 24 16:09:54 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1341263457)
RMAN> list backup;
using target database control file instead of recovery catalog specification does not match any backup in the repository
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
FOR DEVICE TYPE DISK TO '/u01/app/oracle/backupsets/control_files/cf_%F.BCKP';2>
[code]....
I see that a backup set was created to "/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/" , in spite of my specification.
So I asked RMAN to list all the backups I have:
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 41.14M DISK 00:00:00 24-JUN-13
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161025
Piece Name: /u01/app/oracle/backupsets/818957425_1_%r.BCKP
[code]....
Here I see that 4 backup sets have been created.The backup sets 1 & 3 containing the archived redo logs (818957425_1_%r.BCKP and 818957451_3_%r.BCKP) are placed as I wanted in /u01/app/oracle/backupsets/ dir.
The file containing the Control File and Spfile (cf_c-1341263457-20130624-00.BCKP) is placed as I wanted in /u01/app/oracle/backupsets/control_files/ dir.However, The backup set file containing the data files(o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp) is placed under the directory /u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/ ,and I don't understand why.
When I backup my database without the archived redo logs - it is saved correctly:
RMAN>
RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
[code]....
1. Why aren't my data files backed up to the location I specified when I backup using PLUS ARCHIVELOG syntax?
2. Why are my redo logs saved to two different backup sets and not just one?
3. Is there a way to combine backup of all files (data files, control file, spfile, redo logs & arch redo's) in one backup set, one file?
I have a 10G Express system running. I Have 2 tablespaces in production. WHen taking backup, it terminates unsuccessfully saying system01.dbf is damaged. The application works fine and no data loss is found through the application interface.
So can I shift the data to a new server using the dbf files of the tablespaces in use?
while opening my database i got this error i already increase my db_recovery_file_dest_size but still i got this error
E:oracleproduct10.2.0db_1BIN>SET ORACLE_SID=LIVEDB
E:oracleproduct10.2.0db_1BIN>SQLPLUS
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 22 11:14:47 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: SYS AS SYSDBA
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[code].....
I am having a issue, we are trying to restore our db from control files using Symantec Backup exec, but job fails giving me error go to table spaces select all table spaces and unchecked roll forward.
i am unable to find way to uncheck the table spaces. Here is the complete description.
Cause
The system catalog tablespace "syscatspace" contains all of the system catalog information for the tables. Syscatspace needs to be rolled forward first, and then the other tablespaces must be rolled forward.
Solution
Workaround:
When the restore operation is run from a tablespace level backup, perform the rollforward for the syscatspace tablespace first and then for other tablespaces.
Execute the rollforward operation as a DBA operation. The sequence of the recovery process should be as follows:
1. Select all tablespaces, uncheck the rollforward option and run the restore job.
2. Run the rollforward operation as a DBA initiated operation:
rollforward syscatspace to point in time / end of logs. e.g. db2 => rollforward database UEXIT to end of logs and complete Tablespace (SYSCATSPACE) online
3. Perform rollforward of all other tablespaces.
e.g. db2 => rollforward database UEXIT to end of logs and complete tablespace (SYSTOO LSPACE,USERSPACE1) online
Refer to IBM DB2 documentation for more information on DBA-initiated operations.
When we backup .arc files we issue a RMAN command similiar to this:
KEEP_ARCHIVE_HOURS=2
rman <<EOT
connect target ....
connect catalog ...
sql "alter system archive log current";
[code]....
The problem is at times there may not be any archive files that meet this criteria and RMAN throws an error
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the recovery catalog
I was considering using the following code to see if there are any available .arc files that meet the backup criteria.
set pagesize 0 feedback off verify off heading off echo off;
select count(1) from v$archived_log where
COMPLETION_TIME < sysdate-$KEEP_ARCHIVE_HOURS/24
and backup_count = 0 and name is not null;
While testing on several systems, I found that the above-mentioned query picked up some redo-logs (*.rdo) I can only assume that these redo logs were used for a DB recovery.
/u05/oradata/dmartdev/redo_01a.rdo120724-JUL-1125-SEP-11
/u15/oradata/dmartdev/redo_01b.rdo120724-JUL-1125-SEP-11
/u06/oradata/dmartdev/redo_02a.rdo120824-JUL-1125-SEP-11
/u16/oradata/dmartdev/redo_02b.rdo120824-JUL-1125-SEP-11
/u07/oradata/dmartdev/redo_03a.rdo120324-JUL-1125-SEP-11
[code]....
I have a few questions:
1) Is my assumtion correct about the .rdo files in the v$archived_logs table
2) I would hate to add special logic and look for something like name substr(name, *.arc) (pardon the syntax). Therefore, is there a way to get rid of these *.rdo files?
I had a production db with archive logging enabled
SQL> select name,status
2 from v$archived_log;
NAME STATUS
---------------------------------------- -
D:ORACLEARCHIVE_ORCL11_13.DBF A
D:ORACLEARCHIVE_ORCL11_14.DBF A
D:ORACLEARCHIVE_ORCL11_15.DBF A
[code]...
So i need to restore archivelogs by using sequence
RMAN>RESTORE ARCHIVELOG FROM SEQUENCE 20 UNTIL SEQUENCE 28;
So the restore is completed successfully
So its very hard to monitor archivelog files
i feel i should have included all archivelog files while taking RMAN backup
RMAN >backup database plus archivelog all delete input;
but the problem is my RMAN backup is already 360GB in size and it takes 4-5 hrs to complete .so i need to schedule RMAN backup at one time (e.g sunday) ,delete the archivelog files older than sundayand now schedule the archivelog backup at another day (e.g wed &sat)
my question is where i have to change my script to backup all avaialbe archivelog files if old archivelog files are deleted at os level?
RMAN> run {
2> allocate channel c1 type disk;
3> sql 'alter system archive log current';
4> backup archivelog all format 'D:oracleackuplog_t%t_s%s_p%p' delete input;
5> release channel c1;
6> }
My operation system is Linux,there is a database on it . the other server's operation system is windows.
SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL>
Now,i want to implement hot backup on my oracle database which install the linux operation system ,but i expect the hot backup files can storage on the servers of the Windows operation system directly.
I have one question to clarify regarding backup.
There is an incident that in production database 1000 archive log files generated.From 1000 files, 100 archive log files have been removed.When i take incremental backup next day , what will happen in database?
I have been experimenting with RMAN over the past few days and have a fairly strong grasp on it. I setup a test scenario using a three tier incremental approach as follows:
Every four weeks take level 0
Every 7 days take level 1
Every day take level 2
Obviously I'm only taking one per day, so on days I take a level 0, I'm not taking a level 1 or 2. My scripts look similar to the following, with change to incremental level number.
rman target / <<EOF
run {
configure device type disk parallelism 4 backup type to compressed backupset;
configure default device type to disk;
configure backup optimization off;
configure controlfile autobackup on;
configure retention policy to recovery window of 4 days;
[code]......
What I'm trying to understand is what files Oracle is creating in the flash recovery area. I have several sets of files:
In the root level of the FRA, I see several files per incremental backup with names such as aambg4sa_1_1, aqmbg5mj_1_1, b6mbg614_1_1, etc. I was under the impression that these were the incremental backup pieces, multiple files because I'm using parallelism of 4.
Under a /FRA/<SID> I see 3 directories: archivelog, autobackup, and backupset. I assume arhivelog is where Oracle is archiving the redo logs, autobackup is storing the SPFILE and CONTROLFILE as I have enabled controlfile autobackup. However, what is being stored in backupset?
When I do a crosscheck, it lists the files within backupset, but does not list the several files under the root of FRA (b6mbg614_1_1 and so on).
What's the difference between /FRA/<SID>/backupset and the files under root FRA? Do I need both for recovery - and if not, why is Oracle keeping both?
I have the following situation: a customer sent me a group of files, that he said to be a "backup" of an old database, that is no longer online (he doesn´t use our software anymore). However, he needs to recover the data in this database. The person at the company who generate these files doesn´t work there anymore, so we don´t have any of the following information:
- Database version, connection details, service names, user names neither tablespace names.
We were just told that these files were recorded in a DVD, and is que only source remaining.
The files he sent are the following:
ctrlcf_satp_01.ctl
ctrlcf_satp_02.ctl
ctrlcf_satp_03.ctl
daddf_satp_dad_01.dbf
[code]......
Is there a way to access this data? Or can I tell our costumer that your data is lost forever..
I had a database on an old P4 running but the motherboard got fried. I was able to recover all the data files (.ctl and *.dbf) plus the redo logs (.log). There is no export or backup taken - I have old ones, but I need to recover the latest which only existed in the data files.
I now have Oracle installed on a new P5 machine and was wondering if it is possible to use these data files in the new database? If so, how do I go by restoring the data files?
Both the P4 and P5 where running Red Hat Linux.
In the backup and recovery session i have miss my online redolog files. why the datafiles are recovered.it's possible to recovered to online redo logs?
View 3 Replies View Relatedwhat are the minimum files which are required to open the db ? take it as this
I have oracle installed in c drive. I have placed 3 datafile related to one tablespace say test: two in D and one in E. I have place 3 datafile related to tablespace say orcl : two in D and one in E.
my undo is in E scenario is that my E drive crashed . db is in no archive mode . no backup is there. to be more worst db shuts down abnormally. I want my db open with data of c drive and D drive.
Is it possible to recover files from backup tapes which are gone obsolete (as per retention policy)?
View 4 Replies View RelatedI took backup of Datafiles , archivelog files and controlfile through RMAN. Now, i want 3 backup file will created as a output of RMAN operation. It would be :
1 backupfile for all the datafiles
1 backupfile for all the archivelog files
1 backupfile for controlfile.
It have to be regardlessly whatevr my DB size is. It it possible to do so. How i can can write rman script to accomplish the task.
We have a nightly rman backup that was complete and clean.The backup contains a Data File, Control File and a backup Archive Log file.The database server crashed with all the subsequent archive logs lost.
We are trying to recover from the three backup files.We are bumping into the backup piece missing as all the archive logs are done. how to restore with the exising backup files. the lost archive logs are probably salvageable.
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 have four location, four database server separately, we need to synchronize all the servers.
for example. all the server having table parts. if the parts_count column change in server. it should be change all the four servers.
Now i have one problem. I have two database oracle 10g and install on two server (call is A and B). I already create database link between two database. Each database has over 200 tables.
Basically structure two database is same, but database A have data real time, database B is stand by server. Now i want to synchronize all data of database A to database B. What should i do?
We are using HP data Protector as oracle database backup tools.but we are facing below error. But we are able to login to the database through same user.
BR0301E SQL error -1033 at location BrDbConnect-2, SQL statement:
'CONNECT system/********'
ORA-01033: ORACLE initialization or shutdown in progress
BR0310E Connect to database instance ARP failed
We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?
We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.
I am making incremental backups via RMAN, the backups are staying at disk. And the infrastructure team will copy this files backups to tape. And they want delete the files that will staying in disk via RMAN. Until now it's ok.
But and if I need of backups that stay on tape, it's possible make a recovery of deleted files by rman.
Yesterday my colleague noticed that, the complete data (1 year) got missed out from a table and the data is available only from last friday.
And then we restroed the data from the backup.
Now we have been asked to find out who has deleted or truncated the data? But in the database, audit is enabled only to log sys operations.
So is there any way to find who ran the delete or truncate command on this DCA_CLA_BATCH table on friday?
SQL> show parameter audit
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
audit_file_dest string /dborafiles/edcap/edcapd/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string OS
Replication happens across the servers to make sure that the data is the same (synchronized). If one of the server crashes and later recovers, does it need to repair the data to keep them in sync with the other servers?
View 4 Replies View RelatedHere is the details
[oracle@localhost dbs]$ export ORACLE_SID=stby
[oracle@localhost dbs]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 20 09:47:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> !
[oracle@localhost dbs]$ pwd
/oraeng/app/oracle/product/10.2.0/dbs
[oracle@localhost dbs]$ exit
exit
[code].....
I have problem on using "delete obsolete" in RMAN.
First, let describe my backup configuration.
1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog
The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.
In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.
I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.
I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.
The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.
how to take backup and recover of oracle database and which method is best for to protect our data from lost
View 3 Replies View Related