-
When DBA's maintain scripts to re-create there database.
What exactly do they mean and what's the procedure.
Is it dropping the tablespaces, deleting the files and recreating them all or......
Thx
-
it means to include all the controlfiles, datafiles, redologs whenever you recreate them.
For this issue 'alter system backup controlfile to trace ' on your existing database.
Vinit
-
Hello All
DBA's maintian to scripts to recreate the database mens things like
a)Rebuilding the Database on to a different machine which is identical to the one on the production.
b)It could also mean that your script should rebuild the database on production server (say for example you want to change the db_block_size)
the database scripts to rebuild the database includes scripts to create to Physical (like control file ,datfiles,rollbacksegments etc) and logical structures of the database like tables indexes users etc....but without the actual data...
regards
Hrishy
-
Hello All
DBA's maintian to scripts to recreate the database mens things like
a)Rebuilding the Database on to a different machine which is identical to the one on the production.
b)It could also mean that your script should rebuild the database on production server (say for example you want to change the db_block_size)
the database scripts to rebuild the database includes scripts to create to Physical (like control file ,datfiles,rollbacksegments etc) and logical structures of the database like tables indexes users constraints etc....but without the actual data...(in most cases the data is loaded separately)
regards
Hrishy
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|