I want to know how can i create an empty database in oracle 10g and what is the meaning of empty database. basically i want to perform migration from one database to another database by using exp and imp.
How to create empty database and migrate the database one platform to another platform by using the exp and imp. I have oracle 10g (10.2.0.1.0) on both xp and linux.
Does change in segment size effect the rman backup size..??
I'm trying to understand do Rman backup the empty block from datafiles..?? And if it escape the empty block than inserting data in tables (increasing the number of used block) might change the size of total backup (Rman) size
Database version : 11.1.0.7
Applications R12 (12.1.3)
Operating system : Redhat linux 5.5
I would like to know how to create recovery catalog database to acheive rman backups as control file will not keep backup info longer. This is for our production database what are the requirements before doing so and what happens to configure retension policy to recovery window.
Initially plan of taking backup to disk and later moving backups to tape device
On production environment i am running Oracle 10g (10.2.0.4) on windows server 2003. and take full compress backup through rman .
I have create a new machine from scratch OS (windows 2003 server) Database Oracle 10g R2 (10.2.0.4) same architecture as live,
Can i standup a instance with the backup i have taken from my live database. And if yes .......how can i ......means i want to take backup from live and restore it on new created machine
I need to now how can i create a new database from the RMAN Full Backup , is it possible or not? and if possible how?
View 8 Replies View RelatedHow can i create an oline back up of database using RMAN?
View 1 Replies View RelatedI 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.
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 RelatedI created a tablespace named 'data'.During create a new user with default tablespace 'data',I got following error message:
SQL> create user rman identified by rman default tablespace data
temporary tablespace temp
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace
OS:Windows XP
Oracle 10g
I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?
View 1 Replies View Relatedhow to migrate oracle database from 10g to 11g
View 1 Replies View Relatedhow to start database in oracle
View 2 Replies View RelatedI am new in oracle. I want to restore my database in oracle 10g enterprise. Actually i have a backup file(.bkp file) from oracle 10g xe and now i wanna restore in oracle 10g enterprise.
View 5 Replies View RelatedI need the step by step procedure for the cloning of database in linux environment .
View 2 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].....
We have faced database(10.2.0) issue cause incomplete recovery and have performed open resetlogs. This DB is of 12Tb. In 10g opening database with reset logs do not invalidate previous backups. we have another replica(no reset state)of this database which we sync using archives.how we can apply those archives(reset database)to previous database?
View 7 Replies View RelatedI want a copy of data from oracle database in Production to my local machine as upgrade is going to be there soon. How can I do that so that I may check my old data later irrespective of upgrade?
View 9 Replies View RelatedWe are in the process of setting up a DR environment for our SAP and Oracle databases . The netapp and our architects came up with solution as follows .
1.Standby databases are built for all production databases.
2.The SAP file systems are replicated to the secondary site
3.The Oracle logfiles and controlfiles are replicated by netapp snap mirror every 10 mins interval
4.The database is recovered through recover standby database every 15 mins at standby site
5.Please note there is no data guard involved .
6.To test the failover , the mirror is broken .The standby controlfile is replaced with Production controlfile and Redo logs files.
7.The standby database issued a startup comnmand and it worked .
Would like to know whether the step 6 is a correct approach ? I tried to convince the architects that this will result in a very disastrous situation for us but none is listened to .
I want to do cloning of a database on my standalone pc having oracle 10g on windows 7. PC is P4 with 2GB RAM.
The database is installed on my pc and i want to clone it on the same pc.
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
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]....
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?
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.
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].....
database size is 30GB is it recommended for RMAN backup
View 2 Replies View RelatedI 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 Relatedcan we restore database from obsolete backup using rman
View 2 Replies View RelatedSQL> 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?
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 RelatedHow 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