Backup & Recovery :: Clone Database Name Not Showing In Dbca

Aug 20, 2012

i have just create a clone database. it work very well.but when i open the dbca to delete this database.it not show in dbca prompt. why ?

View 4 Replies


ADVERTISEMENT

Backup & Recovery :: How To Clone Database

Jan 4, 2012

how to clone database using cold backup,I want step by step guide for it

I want to give clone of production database to developers

View 3 Replies View Related

Backup & Recovery :: Clone Database On Same Machine?

Apr 3, 2012

configure the clone the database on the same system. i m using window xp 2000 and oracle 10.2.1.

View 19 Replies View Related

Clone Testing Database From X86 To X64 Using DBCA Clonic Templates

Sep 14, 2012

I'm using Oracle Database 11g R2 for study purposes.Currently I'm learning about the DBCA clonic templates.I have an Oracle DB 11g R2 X86 running properly in Ms Windows XP Professional SP 3 X86, using DBCA I created the seed template file .dbc and the .CTL and .DBF files, later I copied those files to a server running Oracle DB 11g R2 X86 in Ms Windows 7 Ultimate X86. Again, using DBCA I successfully created the source database through the seed template file, everything was ok.

Now, I formatted my testing server and I installed Ms Windows 7 Ultimate X64 and Oracle Database 11g R2 X64. I copied the seed template file .dbc and the .CTL and .DBF files to "assistantsdbca emplates" directory. Well, I started DBCA to try create the source database and when the DBCA is creating and starting the Oracle instance it shows the errors:

ORA-00604: error occurred at recursive SQL Level 1
ORA-06553: PLS-801: Internal error [56327]

Is it possible to clone my testing DB from X86 to X64 using DBCA clonic templates?

View 8 Replies View Related

Backup & Recovery :: Clone Using OEM DB Control

Mar 9, 2011

My management is asking me to find the best way to migrate our 3.3 TB data warehouse to a new server. I currently use RMAN to back up the database. This is done offline on Sundays, and it takes about 9 hours, compressed backups to disk. Archived log backups are done online, not in conjuction with the db backup.

I have read a number of documents detailing step to use OEM Db Control (aka dbconsole) to clone the database to the new server.

I have a few questions:

1. I need to clone the Oracle SW first, as our current install has patches, so it should take less time.

2. Do you think just restoring from the last RMAN backup and doing recovery would be faster than cloning?

3. On the new server, I have assumed that the root user (not me) would have to pre-create the OFA structure, e.g.; we have some mount points like /f01/oracle/DBNAME or /g01/oracle/DBNAME. I cannot imagine that the Db control Gui or Rman could create that structure on the target server. Is that correct?

4. There seems to be an attitude in my shop that the storage array mount points and OFA would not have to be identical on the target server. Any opinions?

Back in 1995, I successfully manually cloned a database to a new server in an HP environment, but it was only about 70G!!

View 1 Replies View Related

Backup & Recovery :: Clone Large DB To DDL Only DB - EXP / IMP With Extents?

May 12, 2011

I am looking to create a DDL-only clone of a 2TB database. The purpose of this clone is to provide developers a preprod-like environment where they can test the syntax of their code changes before deploying to production. The database will reside on a seperate, small server.

As I only need the structure of the objects and not the data, my first port of call was EXP using rows=n. However, when I IMP to an indexfile I see that the initial extents have been defined on the tables (in some cases 1GB!). As stated my clone environment is small, so I would be looking to have these set at 1mb. how I can achieve this? I will want to be able to automate the cloning of the database as much as possible. Perhaps there's some other way other than EXP/IMP?

View 7 Replies View Related

Backup & Recovery :: Standby Clone Failure?

Mar 26, 2012

I have run a standby clone that terminated with error due to few missing LV-s. I removed all LV-s for the clone, recreated them including the missing ones. I ran the clone again,but it skips the files that were successfuly duplicated in the previous clone request that failed. I need to be able to start the clone all over again, but RMAN does persistantly skip duplicating the datafiles that were successfuly processed in the first atempt.

How to ignore the RESUME option so that the clone process would start from the beginning? Where does RMAN keep the info about the successfuly duplicated datafiles in clone standby process? I have tried few RMAN tables , but no luck.

View 1 Replies View Related

RMAN :: Clone 2 Node RAC Database To Single Instance Non-RAC Database Using Existing Backup

Jul 25, 2012

I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:

rman auxiliary sys/******@dbracdup
RMAN> duplicate database to dbrac spfile backup location '/oracle/backup';
...
...
Finished recover at 25-JUL-12
Segmentation fault

And the database was in mount stage, and when i tried to open database it failed with below error:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19838: Cannot use this control file to open database .

View 4 Replies View Related

Security :: How To Clone Database Using RMAN Full Backup On Different Machine

Oct 1, 2012

How to clone database using RMAN FULL BACKUP on different machine? I do not wants to use DUPLICATE Command......

Is there any other way to clone DB? I am using Oracle 11g R1 on Windows Server 2007 (64 bit)

View 2 Replies View Related

Backup & Recovery :: ORA-16004 / Backup Database Requires Recovery

Oct 20, 2011

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

View 1 Replies View Related

Backup & Recovery :: ORA-01139 / RESETLOGS Option Only Valid After Incomplete Database Recovery

Jan 25, 2011

SQL> alter database mount;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

View 5 Replies View Related

Backup & Recovery :: Recovery Of Database From Crashed Host Server?

Jul 20, 2012

Backgroud info:

host server crashed.

Database was not cleanly shutdown.

Database is not in archivelog mode.

Datafiles were saved.

My goal:I want to recover the database based on the available files.

My approach:

Install new database.

ALTER DATABASE BACKUP CONTROLFILE TO TRACE.

shutdown database.

Place available dbf files in the location for new database, replacing existing files.

edit trace file to create new controlfile. Script is:

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "newdatabase" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292

[code]....

View 12 Replies View Related

Backup & Recovery :: Oracle11gR2 Not Allow To Open Database After Complete Recovery?

Feb 24, 2012

My database is in NOARCHIVELOG mode.I took whole DB backup ( cold).Then just after half an hour I ran following script.

RMAN> RUN { RESTORE DATABASE;RECOVER DATABASE;alter database open;}

Starting restore at 24-FEB-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore

[code]...

Starting recover at 24-FEB-12
using channel ORA_DISK_1

starting media recovery archived log for thread 1 with sequence 2 is already on disk as file /u01/app/oracle/oradata/PROD/redo02.log
archived log file name=/u01/app/oracle/oradata/PROD/redo02.log thread=1 sequence=2
media recovery complete, elapsed time: 00:00:01

[code]...

Why do I need to specify an option at the first place?As my redo is intact, it is not incomplete recovery and, I do not want to generate new incarnation of my database.Why oracle simply not opening my database?

View 12 Replies View Related

Backup & Recovery :: Restore RMAN Backup Of Database To A New Database

Jan 25, 2011

I have oracle 10g installed on my system and name of the database is "ORCL" for which I have schedule the incremental backup everyday. Mentioned below are the steps followed

*************PARAMETERS TO BE CHANGED******************
configure channel 1 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
configure channel 2 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalcntrl_%U';
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
*******************************************************

*******COMMAND FOR THE CONNECTING TO RMAN**************
rman LOG = \192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incremental
rmanlog_%date:~4,2%-%date:~7,2%-%date:~10%.txt APPEND
CONNECT TARGET SYS/ORACLE@ORCL
*******************************************************

********INCREMENTAL BACKUP COMMAND*********************
RUN
{
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup' DATABASE;
BACKUP ARCHIVELOG ALL DELETE INPUT;
}
********************************************************************

Now I want to restore this backup to some other system with new database. How to do this recovery to some other database on new system.

View 2 Replies View Related

Backup & Recovery :: Error While Backup On Windows 7 Client Of Oracle 11gR2 Database

May 2, 2011

I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.

On Database Server

SQL> create directory win_expdp_dir as 'd:expimp';

Directory created.

SQL> grant read, write on directory win_expdp_dir to lab;

Grant succeeded.

On Windows 7 machine (client machine)

D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.

I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.

View 6 Replies View Related

Backup & Recovery :: ORA-19870 / Error Reading Backup Piece During Database Cloning

Mar 15, 2011

I am trying to clone a database on another server with different direcory structure. So that path on the source db server are /u04 whereas on on target db server it would be /u03.

Since this I am testing it on small database initially I have kept all datafiles, backup and archivelogs at /u04 and /u03 on the source and target db servers respectively Now I have copied the backups from source db server to target and since path is changed, I cataloged it

However during restore I am getting

Quote:ORA-19870: error reading backup

Here are the session details

RMAN> catalog start with '/u03/oradata/db7fra';
searching for all files that match the pattern /u03/oradata/db7fra
List of Files Unknown to the Database
=====================================
File Name: /u03/oradata/db7fra/DB7/archivelog/2011_03_15/o1_mf_1_16_6qyvpb3w_.arc
File Name: /u03/oradata/db7fra/DB7/backupset/2011_03_15/o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

I have altered permissions on the backup files as well but of no use

oracle@dev-biz:/u03/oradata/db7fra/DB7/backupset/2011_03_15 $ls -ltr
total 545260
-rwxrwxrwx 1 oracle dba 12419072 Mar 15 13:52 o1_mf_ncsnf_TAG20110315T123008_6qypyrz2_.bkp
-rwxrwxrwx 1 oracle dba 3072 Mar 15 13:52 o1_mf_annnn_TAG20110315T125043_6qyr54to_.bkp
-rwxrwxrwx 1 oracle dba 426496 Mar 15 13:52 o1_mf_annnn_TAG20110315T125006_6qyr3zk4_.bkp
-rwxrwxrwx 1 oracle dba 14336 Mar 15 13:52 o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

View 13 Replies View Related

Backup & Recovery :: Backing Up / Restoring Oracle Database Via Entire Backup Of Server

Aug 7, 2012

I've read a lot about the different types of backup available with Oracle (hot and cold backup). However, I was thinking of a different way of performing this task. I'm currently using Windows Server 2008 R2 and Oracle 11g Standard Edition. I'd like to schedule an entire backup of my server via the utility "Windows Server Backup" (available for free).That way, I could recover my entire server with all the programs and files in case the latter crashes.I'm wondering if this solution could be used as a way of backing up (and recovering) the Oracle database. Should I still set up a regular hot backup with the Archivelog mode enabled in case some operations/transactions were being done at the time of the crash (for the data integrity)?

View 2 Replies View Related

Backup & Recovery :: Database Size Is 30GB Is It Recommended For RMAN Backup

May 22, 2012

database size is 30GB is it recommended for RMAN backup

View 2 Replies View Related

Backup & Recovery :: Database Recovery With Missing One Of The Archivelog

Feb 10, 2011

I want to do the recovery of my database using the archive log files but one of the archive log in between is missing,

View 17 Replies View Related

Backup & Recovery :: Restore Database From Obsolete Backup Using RMAN

Dec 13, 2011

can we restore database from obsolete backup using rman

View 2 Replies View Related

Backup & Recovery :: Backup Full Database Throws Error?

May 13, 2012

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

after i backup my database,i check the alert log ,i found the following errror:

Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:

[code]....

the trace number 26967 :

[oracle@shenzhengair archivelog]$ cat /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc
/u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

[code]....

what does the error mean?

View 6 Replies View Related

Backup & Recovery :: Taking Online Backup Of Full Database

Jan 29, 2011

online backup done thru RMAN.Suppose i am taking online backup of full database. During the backup, user's are inserting/deleting/modifying data. This data is getting stored as online archives. Once the database backup is finished, how these archives are applied to the database to make the database up to date.

View 1 Replies View Related

Backup & Recovery :: How To Setup Database For Automated RMAN Backup

Mar 14, 2012

How to setup the database for automated RMAN backup. like if we want to have a backup exactly at 8:00 PM IST. So how to configure it.

View 6 Replies View Related

Backup & Recovery :: Backup Entire Database / Without Archived Logs

May 13, 2011

Backup entire database, without archived logs, while the database is open for user activity and also This backup should be the base for an incremental backup strategy.

View 10 Replies View Related

Backup & Recovery :: Apply The Backup Command To Each Database?

Feb 14, 2012

I am admin of my actual server and I want to backup all databases for later use. For that this is my approach.

1 - List all databases on the system

2 - Apply the backup command to each database

View 2 Replies View Related

Backup & Recovery :: RMAN Backup On DataGaurd Database?

Mar 4, 2011

We are running a 5Tb database backup which takes really a long time to backup and impacts the performance in general during the backup. We got a DataGaurd database in place which we want to utilize to run the RMAN backup on to avoid performance impacts and just use DG database for backup and DR purposes. My Question is if we run the backups on DataGaurd Database, How would a RMAN DG database backup would clear the archive logs from Primary production and from DataGaurd Database during the backup process?

View 7 Replies View Related

Backup & Recovery :: How To Perform Database Recovery And Up Database

Jan 16, 2012

1) i lost my control file number 'some loc'contol01.ctl

2) i have restore my old backup control file (single one).

3) while starting database i got error..

ORA-00214: control file '/...../control01.ctl' version 15166739 inconsistent with file '/...../control01.ctl'

how to perform database recovery and up the database?

View 1 Replies View Related

Backup & Recovery :: Restore Backup Of Database A From Into B

Jun 16, 2013

I need to restore a backup of database A from into Database B. Both have the same names. Database B is already up and running.

I have a full rman backup of Database A ( it was taken with a recovery catalog which I don't have access to now as it was deleted ). I just have the full backup pieces including the control files. Is it possible to recover this database into Database B from this stand point.

I was thinking

2. Shutdown database B
3. Mount database B. It has same name as Database A.
4. With RMAN restore controlfile. Will a new controlfile be created from the backup directory I have the rman pieces for the full backup in ?

View 9 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

Open Resetlogs Is Not  Working When Creating Clone DB With Online Backup

Jun 3, 2013

I am trying to create a clone database using hot backup of a database .

STEPS THAT I FOLLOWED
------------------------------------

LET ----- >CURRENT_DB NAME=DEV
CLONE DATABASE NAME=DEVCLONE

steps PERFORMED FORM DEV DB
-----------------------------------------------
- put the database in backup mode using 'alter database begin backup'
- copy all the data files to a different folder
- during copy i have performed some operations on the DB (creating users, tables, dmls etc...)
- in between copying i also performed log switch
- after completion of copy , "alter database end backup"
- created a backup control file in a human readable format (alter database backup controlfile to trace as ........)

steps performed for clone DB side ((DEVCLONE)
-------------------------------------------------------------------
- created a parameter file for the database .
- modified the backup control file so that it will point to the location of copied destination of datafiles
- set the ORACLE_SID
- then 'sqlplus / as sysdba
- starup nomount
- run the modified control file ( created a control file for the clone database)
- recover the database using "recover database using backup controlfile"
I have provided the archive files that it was asking for (archive logs that has been generated in DEV DB)
then i canceled the recovery by typing "cancel"
- recover database using backup controlfile until cancel;
then typed "cancel"
- then try to open the database with open resetlogs but it showed below error

alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:DATA_GUARDDEVHOTSYSTEM01.DBF'

View 6 Replies View Related







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