Dear All,
I am new to this Forum, what my prob in ORACLE 8I i have primary database i am trying to put all the data in test database which was not in network for that i am using archive logs. The procedure what i am doing is
Taking cold backup(Oradata Folder) from primary database and copying the same in test database in place of Oradata folder, after that for every one hour i am getting archives from primary db to test db to recover test db but it was not happening pls suggest me...
Error: ORA-01152 file one was not restored from a sufficently old backup (But i copy all datafiles and redos etc what ever exist in primary that was copied)
ORA-01110 datafile 1: 'D:\ORACLE\ORAD ATA\NAVATA\SYST EM01.DBF'
what to do.....?
5  2435 
Why not backup and restore using EXP and IMP commands?
Why not backup and restore using EXP and IMP commands?
Ya i can do that but while executing EXP the server becoming very slow and cpu usage is going HIGH (100%) and the users which making complaint that the program is very slow.. thats why we are in proposal to update data to test database server via archives... pls suggest me...
Ya i can do that but while executing EXP the server becoming very slow and cpu usage is going HIGH (100%) and the users which making complaint that the program is very slow.. thats why we are in proposal to update data to test database server via archives... pls suggest me...
Why not make the backups when users are not using the system. Is the system always being used?
Why not make the backups when users are not using the system. Is the system always being used?
Thanks for Reply, Ya my server has to run 24X7, right now we are using the method cold backup for recovery, we stopped to take logical backup using EXP and IMP, as my production database is around 35GB, for EXP it is taking 5 hrs time and for IMP it is taking 24hrs. So we moved to cold backup, right now as i joined new i preferred to take recover production database using archives, for that i am trying to recover database using archives. What my main idea is taking backup of archives from production database and trying to recover test database so that i can plan for replication basing only on archives, my test database has also same configuration which has production database server. Pls suggest me what to do, is the above method is correct or not? if not pls suggest me the right one.
AWAITING FOR GOOD RESPONSE...
Thanks for Reply, Ya my server has to run 24X7, right now we are using the method cold backup for recovery, we stopped to take logical backup using EXP and IMP, as my production database is around 35GB, for EXP it is taking 5 hrs time and for IMP it is taking 24hrs. So we moved to cold backup, right now as i joined new i preferred to take recover production database using archives, for that i am trying to recover database using archives. What my main idea is taking backup of archives from production database and trying to recover test database so that i can plan for replication basing only on archives, my test database has also same configuration which has production database server. Pls suggest me what to do, is the above method is correct or not? if not pls suggest me the right one.
AWAITING FOR GOOD RESPONSE...
8i is quite old. You'll probably get more problems with it again later. Is migrating to 10g or later an option? You could then use the DATAPUMP utility.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: DB2 Convert |
last post by:
Hi,
A few points to confirm as I am still new with DB2.
1. What will happen if archive logging is used, however there is no
userexit or manual process to move those online archived logs to
another directory. At this moment my LOGPRIMARY is set to 3. Will the
logging hang?
2. Does LOGSECOND apply to circular logging only? If if use archive
|
by: William |
last post by:
I am using DB2 8.2 on RH Linux 8.0.
I just compiled db2uext2.c but failed to archive the log files, did
anybody fix this problem before? TIA
db2diag.log
2005-06-12-12.39.52.305630-240 I3534G369 LEVEL: Error
PID : 3300 TID : 8192 PROC : db2logmgr
(SAMPLE)
INSTANCE: db2prd NODE : 000
|
by: mahr |
last post by:
Hello,
is there a way (Win 2003, DB2 UDB 8.1 Fixpack9), that the logs are
archived regularly? Our server writes logs (-> archive logs) only 1-3
times per day. I would like to have them more frequently, because I
move them (with OS tools) to another server for the case of desaster(
server destroyed completly).
Is the only way to schedule a job with the 'archive log'-command?
How do other DBAs handle this requirement of recoverability?...
|
by: saramathi |
last post by:
I am a little confused about the archive parameters work together. We
currently have LOGRETAIN=RECOVERY and LOGARCHMETH1=USEREXIT.
It appears that the logarchmeth1 can be set to DISK:<path>. Does this
mean that we can use DISK (rather than USEREXIT) and replace the <path>
to our existing archive log path, set USEREXIT OFF and db2 will
automatically copy files to this directory?
Thanks for any help.
|
by: Kush |
last post by:
Hi. I was just wondering if someone could help me understand the
relationship between the recv_hist_retention value and archive logs
(and pruning of history file).
My understanding is that the history file will be automatically pruned
at the number of days specified in the recv_hist_retentn parameter.
First of all, is that correct? Secondly, does the archive logs, that
are older than the value in recv_hist_retentn value, also get...
| | |
by: dave |
last post by:
Hi All,
I have configured the Netbackup to archive the logs and backup to the
tape device and it working fine it is actually starting archiving logs
to the tape but few logs are still there. do I need to worry about
those logs? Why those S0000000.LOG and S0000002.LOG are still there?
28 -rw------- 1 28672 Oct 23 16:31 S0000000.LOG
12 -rw------- 1 12288 Oct 23 16:47 S0000002.LOG
48008 -rw------- 1 49160192 Oct 25 13:29 S0000021.LOG
|
by: Snonck |
last post by:
Is is possible to recover deleted rows from a table from archive logs?
For example, say you have a database with archive logging turned off.
You create a table and populate it with records. You then reset the logs
and place the database in archivelog mode.
Then you
delete from table;
|
by: nevsoft |
last post by:
Hello
I have Oracle 10.2.0.1 on Solaris 10g.
I want to make level0 incremental backup every night and level1 incremental backup during the day.
Each level0 backup will be copied over network to machine with tape and will be moved to the tape.
Because there is need to be able to restore database to any point in time I have to retain all archive logs
from the start (database will be used for about 1 month). At the beginnig I will take...
|
by: prashanthdb2 |
last post by:
Hi,
Im new to db2.
Im using db2 ese 9.1 (fix pack 1) on SLES 9.0 32 bit. I have single instance on three logical nodes 0,1,2. i have cofigured userexit - on, logretain - on, trackmod - on.
when i take full offline backup i observe that more number of archive logs are backed up on logical node 0. But the less logs are getting backed up on logical nodes 1,2. So when i drop the database those logs are lost.
when i restore the database and...
|
by: Kofa |
last post by:
Hi,
we have an application which uses online backups, so archive logging
is a requirement. We have a small/moderate size database (a few
hundred megabytes isn't much by today's standards) with relatively low
insert/update activity (a few thousand per day).
How should I set up archive logging (number of primary and secondary
logs files, size of each log file)?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
