OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » DATAFILE HEADERS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DATAFILE HEADERS [message #159641]

Mon, 20 February 2006 14:09

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

I have a simple question regarding datafile headers

I was given a set of backup datafiles which were 300 in number.
They were in compressed format i.e a.dbf.z

I copied them into their destination directories in the server
recreated the create database script and started the
database

Later on i realized that i missed copying 20 datafiles from
my backup directory

Now i have copied them to their destination directory

I need to know that after editing my create database script
if i shutdown my database and recreate it using my script would i have any problems.

What i am worrying is that my datafiles would not be in sync

--prompt response would be appreciated

Thanks

Nitin

Report message to a moderator

Re: DATAFILE HEADERS [message #159681 is a reply to message #159641]

Mon, 20 February 2006 22:53

milind_sri
Messages: 70
Registered: February 2005
Location: Pune

Member

Hi,

I am not sure what you have done but from looking at your post i feel that you have created the database but not included the datafile names in the create database script.

If this is the case what you can do is:-

1. Take the backup of control file by:-

alter database backup controlfile to trace;

2. Copy the backup trace file from the USER_DUMP_DEST location.

3. Edit the controlfile script to include the names of the datafiles you missed to copy.

4. Take a clean shutdown of the database.

5. Copy the datafiles from the backup directory.

6. then Startup nomount.

7. Recreate the controlfile.

8. Then open the database :-Alter database open;

9. Then again backup your controlfile.

10.In order to find out the datafile names whether they are being consistently used by the DB you can try:-

Select file_name from dba_data_files;

I think this will resolve your problem.

HTH

Milind.

Report message to a moderator

Re: DATAFILE HEADERS [message #159714 is a reply to message #159681]

Tue, 21 February 2006 00:33

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

This is not the case. I did have 300 datafiles in my script with their names obviously. My problem is this:

/home/dbdump/backup

1.dbf.z
2.dbf.z
.
.
.
350.dbf.z

copied these files to

/develop1/data/

/develop2/data/
and
develop3/data/

But while copying i only copied 300 files instead of 350.
So i created the database using only 300 files.

My question was instead of copying all the files all over again
to /develop1 ,develop2 and develop3 directories and uncompressing them again which you know takes time is there any other
way to add those 50 extra datafiles which i missed.

My worry is the datafile headers would be not matching as 300 files were used for creating that database so all of them
have the new database name in their header while 50 files have a
different name as those files are originally from some source database.

Any suggestions???

Thanks,
Nitin

Report message to a moderator

Re: DATAFILE HEADERS [message #159717 is a reply to message #159714]

Tue, 21 February 2006 00:38

milind_sri
Messages: 70
Registered: February 2005
Location: Pune

Member

Hi,

If this is the case then you should try re-creating the control file adding the remaning datafiles and see that database can be opened in RESETLOG mode.

HTH
Milind.

Report message to a moderator

Re: DATAFILE HEADERS [message #159718 is a reply to message #159714]

Tue, 21 February 2006 00:43

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

thanks. I will try that tommorrow and will let you
know if it worked

Thanks,
Nitin

Report message to a moderator

Previous Topic:	Nologging
Next Topic:	ORAPWD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:20:48 CDT 2024