PL/SQL :: Backup Of Full Database Using EXP?
Aug 23, 2012
We are having 5 schemas in one database. Now we need to move Oracle server from one machine to another. I can take schema level back up using Export and Import in new server. I am not a DBA as we don't have a DBA I need to do this myself.
I want to know Is there an option to take full database back up including tablespaces and all the schemas in one shot. I read that RMAN is one option. But any option using EXP/IMP for same?
My plan is
-Take list of Tablespaces and create them in new server
-Take Exports of schemas from original server
-Create schemas and import the data in new server.
View 6 Replies
ADVERTISEMENT
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
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
Sep 5, 2012
One of my Friend gets error While datapump Export backup of Full database.
Pfa below error details:-
ORA-31693: Table data object "RADIOMIRCHI_PIP_HRMS"."GM_DEPT" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-21780: Maximum number of object durations exceeded.
[code]......
View 1 Replies
View Related
Nov 9, 2011
Environment:
oracle 10.2.0.1.0
Windows XP
I have taken the RMAN Full database backup through the following command.My database is in no archivelog mode.
AT RMAN prompt
Shutdown immediate;
Startup mount;
run
{
allocate channel c01 device type disk format 'd:
man_bkp est_%U';
allocate channel c02 device type disk format 'd:
man_bkp est_%U';
backup full database tag 'full_bkup_test_081111';
backup current controlfile;
backup spfile;
release channel c01;
release channel c02;
}
Now i have deleted my all controlfile and spfile/Pfile from the database.So how can i recover my SPfile and controlfile? i do not have autobackup on of SPfile/Controlfile.
View 7 Replies
View Related
Jun 4, 2013
Just now my database is hang due to the archivelog full. I try to use RMAN to delete the expired one and free space but encounter the error:
RMAN>crosscheck archivelog all;
archive log filename=/geodata/oraclelog/archive_log/ORAGF45/archivelog/2013_06_04/o1_mf_1_1444_8tsxvwc2_.arc recid=1350 stamp=817182450
validation succeeded for archived log
archive log filename=/geodata/oraclelog/archive_log/ORAGF45/archivelog/2013_06_04/o1_mf_1_1445_8ttx2q6j_.arc recid=1351 stamp=817214416
[code].......
So I try to back it up first by using the below command:
RMAN> backup archivelog all;
Starting backup at 04-JUN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
[code]......
I know that I have to extend the db_recovery_file_dest directory for "limit exceed" error but how can I safely delete the archivelog in order to bring up the database?
View 3 Replies
View Related
Feb 15, 2013
I am running full database backup it take 10hrs to complete.
Size of the database=590GB
Platform:Solaris 9
database version:10.2.0.5
using catalog database.
Is there any way to reduce the time ?
Is there any query to see how long does the backup runs?Monitor the backup time?
View 5 Replies
View Related
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
Jun 8, 2012
I use windows 2003 server, oracle 10.2.0.4.0.My question is related to maintaing a standby database
1. Do we need to take RMAN full backup of standby database on a regular basis? At the moment I dont take backups of standby database.
2. I have FRA on standby database. The archivelogs from primary go to FRA on standby. I delete my archivelogs as follows:
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';
Though the archivelogs are delete there are still empty folders of archivelogs that are not deleted. How to get rid of them automatically.
View 2 Replies
View Related
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
Jan 8, 2013
Does the full cold backup of rman include online redologs?
So that at the time of recovery when i restore the database the online redologs also restored to that point?
View 2 Replies
View Related
Jul 22, 2013
I am trying to practice some RMAN configuration settings.Version 11.2.0.1OS - Linux X86-64 What i wanted to validate is if there is no level 0 backup of database taken, then the level 1 backup will be automatically backing up all the blocks of the database(similar to full backup). RMAN> report schema; Report of database schema for database with db_unique_name DB101 List of Permanent Datafiles
File Size(MB) Tablespace RB segs Datafile Name----1 300 SYSTEM +DATA/db101/datafile/system.257.8208254172 200 SYSAUX *** +DATA/ db101/ datafile/sysaux.268.8208254253 820 UNDOTBS1 *** +DATA/db101/datafile/undotbs1.261.8208254294 5000 TPCCTAB *** +DATA/ db101/ datafile/tpcctab.266.820832485 List of Temporary Files=File Size(MB) Tablespace Maxsize(MB) Tempfile Name---- 1 200..
[code]....
I am not sure what these input bytes are which is not matching with the database size(posted in the beginning of thread)? why it has to show as db full when i actually run a incremental?
View 1 Replies
View Related
Dec 27, 2011
I am using the following query to determine if my rman backup succeeded for failed. I look for "COMPLETED WITH ERRORS"
col input_type format a10
col bck_hrs format 99.9 heading "Run|Time"
col status format a21
col end_dt format a20 heading "End|Time"
col mbytes_per_sec format 9,999 heading "Output|Rate|MB/sec"
[code]...
output
======
End Run Output Rate
INPUT_TYPE STATUS Time Time Size GB MB/sec
---------- --------------------- -------------------- ----- ---------- ------
ARCHIVELOG COMPLETED 2011-12-24 06:03:54 .5 189.4 106
DB INCR COMPLETED 2011-12-24 05:33:05 9.3 3,392.6 103
ARCHIVELOG COMPLETED 2011-12-23 10:12:27 .2 73.3 105
I know that the DB INCR is an INCR 0 backup but is there some way query I can join with my example above to tell me this is INCR 0 or FULL BKUP?
I was thinking maybe setting "COMMAND_ID" some text like INCR 0 or INCR 1 or FULL BKUP. Does that sound feasible
View 5 Replies
View Related
May 13, 2012
my restore scenario bellow.
I have hot full backup that processed by NetBackup Policy. the backup policy are;
1.Full backup database in Monday. Daily_Monday_RMAN <- 1 volume pool=1 media
2.Full backup database in Tuesday .Daily_Tuesday_RMAN <- 1 volume pool=1 media
3.Full backup database in Wednesday. Daily_Wednesday_RMAN <- 1 volume pool=1 media
4.Full backup database in Thursday. Daily_Thursday_RMAN <- 1 volume pool=1 media
5.Full backup database in Friday. Daily_Friday_RMAN <- 1 volume pool=1 media
6.Full backup database in Saturday. Daily_Saturday_RMAN <- 1 volume pool=1 media
How to restore database from one of medias?
View 5 Replies
View Related
Nov 30, 2012
on 10g R2 on AIX. today (30th of Nov at 7PM) I want to restore my DB from a full backup done on 21 of Nov at 9AM.
Should I :
RMAN> Run {
2> shutdown immediate;
3> startup nomount;
4> SET UNTIL TIME "TRUNC(SYSDATE) - 8";Is my "SET UNTIL TIME "TRUNC(SYSDATE) - 8" accurate ?
Or other value for SET UNTIL TIME ???
View 10 Replies
View Related
Aug 8, 2012
on our 10.2.0.5 database, when we run full backup, my system performance comes to an halt. we run full backup and then do a validate backup to validate the structure of the database etc. Database performance takes a hit and all of the application connections goes in wait mode: On ASH or AWR - this is the top wait i see:
RMAN backup & recovery I/O
Event % Event P1 Value, P2 Value, P3 Value % Activity Parameter 1 Parameter 2 Parameter 3
RMAN backup & recovery I/O 22.22 "1","32","2147483647" 21.79 count intr timeout
what can we do to over come this issue?
View 3 Replies
View Related
Aug 23, 2011
Just wanted to know if I do
ALTER SYSTEM ARCHIVE LOG CURRENT;
Then it archives the current redo and switches to next redo.
If again switching is done, then just wanted to know if redo is archived when its size is less than log_buffer, then is it resumed when it is switched into next time or after archiving it creates a empty redo file and then use it?
View 3 Replies
View Related
Sep 10, 2012
7 of days ago Full backup has been taken to disk due to issues with tape devices.3 days ago tape devices have been fixed and we switched to CommVault managed tape backups. CommVault calls RMAN with following command:
run {
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/usr/local/bin/simpana/Base/libobk.so,BLKSIZE=1048576,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 45 -a 2:71 -cl 9 -ins 9 -at 22 -j 294321 -jt 294321:4:1 -bal 1 -rcp 0 -ms 1 -data -ma 89 -cn oraclehost -vm Instance001)"
TRACE 0;
setlimit channel ch1 maxopenfiles 8;
backup
incremental level = 0
filesperset = 32
database
include current controlfile spfile ;
}
exit;
These backups done successfully.Then archivelog backup taken similar way.But when I issue RESTORE DATABASE PREVIEW SUMMARY; RMAN starts with Full backup set, though newer Incremental Level 0 ones are available.Why it does not use these newer ones?
Oracle 10.2.0.5 for Linux on IBM POWER
View 2 Replies
View Related
Dec 6, 2012
I have to recreate my standby database due to huge archive gap. I have full datafile backup of primary.
View 24 Replies
View Related
Aug 26, 2010
I started restoring and testing all the backups. So far I did good and I wanted to restore and test in different host. I couldn't find any online documentation regarding restore full back up in a new different server (With same OS and same version of Oracle) without RMAN catalog database.
View 4 Replies
View Related
Nov 27, 2012
I configured recovery catalog and started Full online backup using EMC Networker. In EMC Networker I set three months policy to keep Backup.I didn't change redundancy.
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
My question is, if I need to restore Backup of last 15 days then I can ?.
View 4 Replies
View Related
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
Dec 13, 2012
I am trying to export a full DATABASE using the command...EXP [username/password]@[CS]FILE=PATH\[filename.dmp] LOG=PATH\[logname.log] INDEXES=n STATISTICS=none COMPRESS=Y
the database begins to export as shown below, but the export terminates with the below error.
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user [username]
. exporting PUBLIC type synonyms
. exporting private type synonyms
[code],,,,
considering that i have exported full databases successfully before using the mentioned command above.
View 9 Replies
View Related
Oct 20, 2011
Source:Oracle 11g 11.1.0.2 32 bit on Windows 2003,Destination: Oracle 11g 11.1.0.2 64 bit on Windows 2008
In our Source Database, we are using following to create full export
Source database_name=dbfour,sid=dbfour1
I am creating full export by using following
expdp system/psswd full=y dumpfile=expdp_%date:~0,2%-%date:~3,2%-%date:~6,4%.dmp logfile=explog_%date:~0,2%-%date:~3,2%-%date:~6,4%.log FLASHBACK_TIME="to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')"
In my destination DB with database_name=dbfive and sid=dbfive1, i am trying to import whole database by using the file created above and use following
impdp system/pwd@dbfive DIRECTORY=DATA_PUMP_DIR DUMPFILE=EXPDP_20-10-2011.DMP
Process started but after sometime it gave 1200 errors. Is it due to the Different Database name or Is it because i did not create table space in destination database.
View 3 Replies
View Related
Nov 12, 2012
i wanna copy data from a table to another one (same structure, only difference is that the second table is partitioned). the origin table consists of about millions of lines so i made an insert :
insert into table2 select * from table1. the insertion doesn't end correctly : TOAD crashes, any line was inserted in table2 : select * from ...etc.
However, the file system becomes full. i would if there is a way to purge something like cache ..., are these lines inserted somewhere : temporary table...,
so i can reduce filesystem size.
View 13 Replies
View Related
Jan 2, 2013
I am doing an export using the following parfile information:
userid=/
directory=datapump_nightly_export
dumpfile=test_expdp.dmp
logfile=test_expdp.log
full=y
content=all
However when I run this I do not see the sys.aud$ in the log file. I know I can do a seperate export to specifically get the sys.aud$ table but is there any way to include it in with my full export?
View 8 Replies
View Related
Jun 20, 2013
I'm testing out various RMAN restore/recovery scenarios for 10g R1. Took a full level-0 backup of one of our larger databases (16 tb) and I'm trying to restore the whole thing on another server. While the backup was running (for about a day & a half), a few datafiles were added. The backup completed fine, including "backup current controlfile;". Now my restore is failing with "RMAN-06023: no backup or copy of datafile xxxx found to restore", with reference to the 4 files that were added while the backup was in progress.
I guess if the datafiles were added after the backup had finished, we'd be fine because they'd be created during recovery with our archive logs (we have all of those).
I found some suggestions for first doing a "restore controlfile;" -- did that and it worked fine -- then mounting the database and creating the datafiles manually. I added that to my RMAN restore script and tried it, like so:
run {
allocate channel d4 type disk format '/BK01/dbX/stream1/df_%t_s%s_s%p' ;
sql "alter database create datafile ''/uXX/oradata/dbX/datafile_58.dbf''";
restore database ;
}
The datafiles were created successfully, and the restore began .. but then it failed with this:
creating datafile fno=4216 name=/uXX/oradata/dbX/datafile_58.dbf
...
RMAN-03002: failure of restore command at 06/20/2013 17:27:28
ORA-01119: error in creating database file '/uXX/oradata/dbX/datafile_58.dbf
ORA-27038: created file already exists
So RMAN seems to be telling me that if these 4 datafiles don't exist in the backupset, then RMAN won't automatically create them. But if I manually create them first, then RMAN will try to restore them and complain that they already exist. And for that matter, I would have expected that RMAN would be smart enough to detect that those 4 files were added while the backup was active, and just include them in the backup. Maybe there's something I needed to do to tell RMAN to do that?
This is just a test, so of course I can redo the backup from scratch and try again, but we have some pretty large databases which cannot be shut down for cold backups, so it's entirely possible this scenario could show up in a real disaster recovery. RMAN does such a good job of managing things.
View 1 Replies
View Related
Oct 18, 2010
I am getting ORA-39127 while taking full database export using EXPDP on oracle 10g enterprise edition 10.1.0.2 . This is production database.
Details of the errors are:
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OBJECT_GRANT
ORA-39127: unexpected error from call to export_string :=SYS.LT_EXPORT_PKG.syste
m_info_exp(0,dynconnect,10.01.00.02.00',newblock)
ORA-06537: OUT bind variable bound to an IN position
ORA-06512: at "SYS.DBMS_METADATA", line 5107
Processing object type DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_PRE_SYSTEM_ACTION
[code]....
Datapump Export completes with these 2 errors and dumpfile is generated. Are these errors Problematic. Will these errors cause problems while taking import from the dumpfile .
View 1 Replies
View Related
Jul 30, 2012
i want to perform full export + import of an oracle 11g database as fast as possible. i was thinking to perform the exp+imp on the same command.in exp i can perform something like this :
mknod /oracle/migration/exp_pipe p
exp '/ AS SYSDBA' file= /oracle/migration/exp_pipe full=y | imp system/***@oracle_db file= /oracle/migration/exp_pipe full=y
i know that i can do both action in impdp when using a dblink, but the problem is that some objects in the database cannot be copied via a dblink. the question is if there's a corresponding datapump command to the old exp+imp command i presented.
View 5 Replies
View Related
Jun 20, 2008
i have full export dump file....from this, i need to import only one procedure belongs to schema : IC_MIGR_DATA... i need to import into SCHEMA : rep_user...
iam giving syntax:
impdp system/icg0ld@ICPRD directory=DUMPDIR dumpfile=IC_FULL_19062008.dmp logfile=imp_IC_FULL_190608.log schemas=rep_user parfile=imp_proc.par
parfile :
--------
INCLUDE=PROCEDURE:"LIKE 'IC_MIGR_DATA.JET_UPLIFT'"
while importing, iam getting below error,
*****[oracle10@AIICDELL IC]$ impdp system/icg0ld@ICPRD directory=DUMPDIR dumpfile=IC_FULL_19062008.dmp logfile=imp_IC_FULL_190608.log schemas=rep_user parfile=imp_proc.par
Import: Release 10.2.0.2.0 - 64bit Production on Friday, 20 June, 2008 16:19:46
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-31644: unable to position to block number 30698425 in dump file "/AIIC_backup/expbkp/dumps/IC/IC_FULL_19062008.dmp"
******
how to import this one procedure JET_UPLIFT , this has to be imported into REP_USER schema, owner of this procedure is IC_MIGR_DATA
View 5 Replies
View Related
