Archive Logs

daitaravi2002

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\ORADATA\NAVATA\SYSTEM01.DBF'

what to do.....?

r035198x

Why not backup and restore using EXP and IMP commands?

daitaravi2002

Quote:

Originally Posted by r035198x

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

r035198x

Quote:

Originally Posted by daitaravi2002

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?

daitaravi2002

Quote:

Originally Posted by r035198x

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

r035198x

Quote:

Originally Posted by daitaravi2002

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.

Archive Logs

re: Archive Logs

re: Archive Logs

re: Archive Logs

re: Archive Logs

re: Archive Logs

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about