Backup & Recovery :: How To Link ASM File Alias And Database File Names

Nov 12, 2012

During a duplicate process to a new database name, rman crashed after the restore but before the switch datafile all.So now, we have under ASM the data files under the correct (new) diskgroup but v$datafile contains the previous names (and so diskgroup) and v$datafile_header is empty. RMAN is completly lost, our solution is to manually rename each file under SQL*Plus using ALTER DATABASE RENAME FILE. Unfortunately, we are using or migrating to OMF, so file names are meaningless and we are unable to associate ASM files with database files.

Any way (query or anything else) to associate the ASM files to the database files. Here's an abstract of what we have for one (small) tablespace:

ASMCMD [+ORAXQG1_L136_DG1/ORAXPG1/DATAFILE] > ls -l N47CAW*
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE NOV. 12 10:00:00 Y N47CAW1.276.799152039
DATAFILE UNPROT COARSE NOV. 12 10:00:00 Y N47CAW1.318.799151641
SQL> select file#, name from v$datafile where ts#=17
2 /
[code]...

View 11 Replies


ADVERTISEMENT

Backup & Recovery :: ORACLE Dump File To Text File

Apr 9, 2011

Oracle10g to Sybase12.5 Migration:- How a Oracle dump file can be converted to any text file/xls file which will be loaded in sybase database later through BCP.

means
1.Exporting objects as dump file from Oracle.
2.Is there any tool/process available that can convert this into csv/txt/xls file.
3.This files can be loaded in sybase.

View 2 Replies View Related

Backup & Recovery :: RMAN Using Target Database Control File / Separate Catalog Database

Mar 14, 2012

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 Related

Backup & Recovery :: Restore Database Using Control File Until Cancel

May 17, 2012

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;

View 4 Replies View Related

Backup & Recovery :: Running RMAN Commands In RUN File To Duplicate A Database

Dec 17, 2012

I have a RUN file within a script to duplicate a database. As part of this RUN file I also run the command configure controlfile autobackup off; as part of this RUN file. However, this command has turned off backup of the control file on the AUXILLARY database (i.e. production) as well as the TARGET database (test). Is this supposed to happen?

My run file is:

rman TARGET sys/XXXX@${DB}-SOURCE AUXILIARY /
RUN {
allocate AUXILIARY channel a1 type disk;
allocate AUXILIARY channel a2 type disk;
allocate AUXILIARY channel a3 type disk;
allocate AUXILIARY channel a4 type disk;

[Code]....

View 7 Replies View Related

Backup & Recovery :: ORA-01161 Database Name CCSPS In File Header Doesn't Match Given Name Of CCSP

Nov 25, 2011

While creating a controlfile while bringing the database up we are consistently getting the below error

ORA-01161: database name CCSPS in file header does not match given name of CCSP
ORA-01110: data file 312: '/aoq53/appl/oracle/ccsps/dtmcs01_07.dbf'

The controlfile creation script is as follows.

CREATE CONTROLFILE SET DATABASE "CCSPS" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 255
MAXLOGMEMBERS 2
MAXDATAFILES 1022
MAXINSTANCES 8
MAXLOGHISTORY 904
[code]....

our production database is not coming up due to this issue and we are on the verge of missing SLA.

View 6 Replies View Related

Backup & Recovery :: Cannot Update Recovery Area Reclaimable File List

Oct 18, 2012

I just switched my STBDY DB to a PRIMARY DB and I am ran the following:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
ORA-00245: control file backup operation failed

RMAN-08132: WARNING: cannot update recovery area reclaimable file list

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORARZULB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
[code]....

what causes this warning and how to get rid of it?

View 2 Replies View Related

Application Express :: Link Local File With Browse File Dialog

Aug 15, 2012

I'm looking for a solution to hyperlink to a local file (i.e. C:/test.txt). I want that the user clicks on a "browse file" button like the file browse item. after the user selected a file or just a folder the path should be shown in a display only item. this item should be clickable...

Is it possible to create a "Browse file" dialog? I know that to link to a file is possible with some HTML tags in the "pre element text" and "post element text" fields. something like "<a href="... but I don't know how this works.

View 2 Replies View Related

Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?

Jan 28, 2011

I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...

brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap

The backup goes thru but i get this erro on the end...

BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28

[code]...

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42

[code]...

Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman

[code]...

I have check on the system .. There is not file like that but thwre on on the db i,e

eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1

View 13 Replies View Related

Backup & Recovery :: Can A Control File Backed Up Be Present In Multiple Backup Pieces

Sep 27, 2011

Suppose I take a multi stream backup, say 3 streams.

So if a control file is backed up in say backup set 1, so is the whole control file is backed up in one backup piece or it may span multiple pieces?

A backup set may have multiple backup pieces.

View 2 Replies View Related

Backup & Recovery :: Restoring Later Backup Control File And Recovering Till Past Scn

Jul 11, 2012

I want to ask if I restore a control file from backup of say day2 and I recover till day1 using RMAN script, then what will be the state of my database? I mean day2 control file may be having SCN-Day2, and I am instructing RMAN to recover till past point in time that is SCN-Day1.

View 3 Replies View Related

Backup & Recovery :: Configuration Can't Be Changed For BACKUP Or STANDBY Control File

Sep 18, 2012

On my stand by DB when I run the following command I get this error:

Is this line really needed based on my run block?

run
{
sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';
allocate channel t1 type 'SBT_TAPE'

[Code]....

View 4 Replies View Related

Backup & Recovery :: RMAN Backup Fails On Windows When Using Batch File?

May 3, 2011

I am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.

D:> \3.193.211.19sgdba
mankp_acressit.bat
D:>rman catalog rman/******@acressit target / cmd
file=E:sgdba
mankp_arch.rcv log E:sgdba
mansit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:sgdba

[code]....

Both single and double quotes (' or ") are accepted for a quoted-string.

Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:sgdba
mankp_arch.rcv"

[code]....

* on my DB server I am login using my administrator account, on my PC I dont have admin account.

* I have checked remote execution using local user as well as admin user.

* I have checked the permission and my local ID & EVERYONE has all permission in that folder.

View 2 Replies View Related

Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?

May 30, 2012

How can be identify a particular archive-log file have backup or not from rman catalog?

View 2 Replies View Related

Backup & Recovery :: RMAN Control File Auto Backup Error?

Dec 13, 2011

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.

View 1 Replies View Related

Backup & Recovery :: Changing Location Of Data And Temp Files From Auto-backup Of Control-file?

Jan 26, 2012

I 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]....

View 14 Replies View Related

Backup & Recovery :: Backup Of Control File On Standby Node?

Apr 3, 2013

I am trying to backup my control on a STBBY DB(RAC) and I am getting the ollowing error.

ORA-00245: control file backup failed; target is likely on a local file system

what the issue is? Note the FS is ACFS and can see on all my nodes

show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PA01INS_IM3L059B are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default

[code]...

ACFS file system

df -h /share/dbbkup/oracle/PA01INS/rman
Filesystem Size Used Avail Use% Mounted on
/dev/asm/pa01ins-33 75G 2.6G 73G 4% /share/dbbkup/oracle/PA01INS
rman cmdfile=control.rman

[code]...

View 2 Replies View Related

Backup & Recovery :: Change Backup Datafile Name Into Its Original File Name?

Dec 16, 2011

how i can change backup datafile name into its original file name,bcoz at time backup datafile name is different and how i can change that name into its original datafile name so i apply recovery command in user managaed recovery..

View 7 Replies View Related

Backup & Recovery :: ORA-01152 / File 1 Was Not Restored From Sufficiently Old Backup

Sep 27, 2011

I am trying to open my Mounted database with

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'F:APPADMINISTRATORORADATATHIRDBSYSTEM01.DBF'

To get rid of this , I tried following,

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1004739 generated at 09/26/2011 10:31:34 needed for thre
ORA-00289: suggestion :
F:APPADMINISTRATORFLASH_RECOVERY_AREATHIRDBARCHIVELOG2011_09_27O1_M

[code].....

View 2 Replies View Related

Backup & Recovery :: ORA-01194 / File 1 Needs More Recovery To Be Consistent

May 16, 2012

I am trying to open the database bur gettinf following errors

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'

SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes

[code]....

View 1 Replies View Related

Backup & Recovery :: ORA-01113 - File 5 Needs Media Recovery

May 11, 2012

I am trying to move my data files from one location to other as i ran out of space.

SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATA.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATA.DBF';
Database Altered

SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATATEMP.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATATEMP.DBF'
Database Altered

Now when i am trying to run Alter Database open I get ORA-01113: file 5 needs media recovery error

View 11 Replies View Related

Backup & Recovery :: Restore Control File Backup

Feb 10, 2011

I take hot backup of database at 10:00 am.After taking the hot backup 50 archived logs are created.Out of 50 i have backed up first 25 of them and at 5:00pm i lose complete database including control,data and the last 25 archived log files that were not backed up.So I am using latest hot backup to recover

I restore the control file backup and datafile backup taken during ho tbackup(10 am) and i issue the command

.......startup mount
>>>>>>>Recover database until cancel
!!!!!!! Apply the available 25 archive logs

then i give "cancel" since I dont have the next redo log .Now in which mode will the database open(Reset logs or no reset logs)

View 6 Replies View Related

Backup & Recovery :: To Restore Control File From Backup Set

Dec 9, 2011

I want to restore control file from backup set,just as the flowing command,where location does the control file be restored to? how can i specify the location when restore control file?

restore controlfile from '/u01/rman_backup/mybak/df_768589733_7_1.bak';

View 2 Replies View Related

Backup & Recovery :: Backup Control File To Trace?

May 28, 2012

taking the backup of a control file, as i am taking online backup, archive mode.

At first i have executed the statement

sql> alter database backup control file to trace;

then i have removed the control files and enterd some data in a table and committed it.As my oracle is not shutting down, so i shut aborted it. Now after saving the last file from the udump as obkp.sql i am unable to edit this file and use.

how to edit and use this file, so that i can startup my database normally.

View 4 Replies View Related

Backup & Recovery :: How Many Times To Backup Control-file

Jan 5, 2012

When i issue this command ,how many times to backup controlfile?

RMAN> BACKUP CURRENT CONTROLFILE INCLUDE CURRENT CONTROLFILE;

Is there difference between 'BACKUP CURRENT CONTROLFILE INCLUDE CURRENT CONTROLFILE' and 'BACKUP CURRENT CONTROLFILE'?

View 2 Replies View Related

Backup & Recovery :: Log File Concept In Oracle

Dec 10, 2011

what is the process of creating log file in database, Suppose if we have two user ,and both are logon through id & password,at that condition i want all log file from users who done at the database like any events.

View 1 Replies View Related

Backup & Recovery :: Archive Log File Using RMAN

Feb 1, 2012

When we see archive log destination is full , in that case how to backup archive log files using RMAN ?

View 1 Replies View Related

Backup & Recovery :: Archive Log File Missed

Jan 30, 2012

Today we have taken a backup of the Live database, due to some issue, it got deleted before applying into the Disaster Recovery Location.

View 12 Replies View Related

Backup & Recovery :: Restore File From Oracle 11g To 10 G

Nov 19, 2012

I have Backup File created in Oracle 11 g . How To restore it in Oracle 10g ?

View 12 Replies View Related

Backup & Recovery :: Corrupt Control File?

Dec 2, 2011

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!

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved