alter system switch log file

[hrishy]

Hi

I was cloning a database from a hot backup..and during the process i had to apply the generated archived logs.started applying one by one..and then when all the archive logs that were shipped to me were exhausted ..(the hotbackup was shipped to me from a remote site by the DBA) i tried to open the database by saying

svrmgrl>alter database open reselogs

I had a message saying file sys1.dbf needs more recovery..and after that i again tried

svrmgrl>recover database using backup controlfile until cancel

then it prompted me for a archive log file that was not there at all..(mean not shipped to me at all)..and i couldnt open the database with resetlogs optin..i suspect that the DBA there did not issue

alter system archive log current..in his hot backup script ?am i right can i reproduce this situation..

regards
Hrishy

[adewri]

You should have asked for the redolog files as well...

[hrishy]

Hi Amar

Thanks for the quick reply :-)..well i did have the online redologs..i forgot to mention it in my previous post..

regards
Hrishy

[adewri]

What is the Oldest online log sequence and Current log sequence in

SQL> Archive log list;

do you have all of them, between oldest and current??

[hrishy]

Hi Amar

Yes i have all the log files from archive log list..there are no files that are mising..

regards
Hrishy

[adewri]

Originally posted by hrishy
Hi Amar

Thanks for the quick reply :-)..well i did have the online redologs..i forgot to mention it in my previous post..

regards
Hrishy

Why are you doing open resetlogs ??

[hrishy]

Hi Amar

Thats because i wanted to change the name of the database..and when i recreated the controlfile with a new databse name we should use the resetlogs option..

regards
Hrishy

[adewri]

Oh in that case...

1. put the parameter _allow_resetlogs_corruption=true in your parameter file.
2. Then shutdown the database
3. startup mount
4. alter database open resetlogs.

Its possible that the command alter system archive log current was not given i see you mentioned it earlier, it takes time for me to grasp the situation

If possible get every thing again or follow what i showed above

HTH

[hrishy]

Hi Amar

Yes..i would surely try it out..but i am kind of curious on how to reproduce this kind of thing probably at home on my home computer..any ideas ;-) ?

Thanks for the suggestions so far..

regards
Hrishy

[adewri]

Originally posted by hrishy
Hi Amar

Yes..i would surely try it out..but i am kind of curious on how to reproduce this kind of thing probably at home on my home computer..any ideas ;-) ?

Thanks for the suggestions so far..

regards
Hrishy

He he he...

create a default database, ORCL with archive log mode enabled. use hotbackup to backup the tablespaces. meanwhile do some inserts, updates or deletes. end backup, delete the sample database .

use the bakups and archived redologs to restore and recreate the new database, apply archive logs should get the same scenario

best of luck, if i get time and can find space i'll try it too