Leave a Comment:
10 comments
Hi;
Just want to say Atul u r the best teacher.I’m learning alot from u. God bless ya!!
Hi Atul
We do not backup the redologs in hot backup.We backup the archives that are produced during the hot backup.
Also i did not understand why u want a human readable format of the controlfile? Instead you need to backup your controlfiles with .ctl extension, that is the correct procedure.
vikki
ReplyI try to generate script for begin and end backup, is most efficient:
set head off;
spool beginbackup.sql;
select ‘alter tablespace ‘ || tablespace_name || ‘ begin backup;’ from DBA_TABLESPACES where tablespace_name <> ‘TEMP’;
spool out;
and:
set head off;
spool beginbackup.sql;
select ‘alter tablespace ‘ || tablespace_name || ‘ end backup;’ from DBA_TABLESPACES where tablespace_name <> ‘TEMP’;
spool out;
but not understand the part for:
Then
1. Copy all your datafiles, redo logs and control files …..
“this copy is a normal os copy: cp *.dbf /u02/hot_backup/oradata”????
I need your help..
ReplyYes it is normal o.s. copy. Make sure you are backing up archives as well generated during this process.
ReplyThanks Athul, Your help resolve my big problem. I interest in your criteria about this:
Is mos efficient create multiples schema ‘s in oracle database for best manage and monitoring the db and efficient backup and restore process… or
Install oracle standard for a 5 standard tablespaces.
I ‘m show a presentation for my boss, he propose install oracle standard install, but i not…
I need your opinion respect to.
Thanks…
Replywhat do you mean by multiple schemas here ??
If you are talking about OATM , OATM in my opinion is better to manage.
ReplyMy English is not good, i from Dominican Republic, speak Spanish…
I ; m refer to distinct schemas, is a distinct users or (applications) for group your object in the database.
My work place is a Telecommunication company (ISP as residential telephonic services)
In Development ambient existing multiples Tablespaces: monitor, commissioning, billing, etc., .., .., .,
My boss said to production database not take a equal schema, but i not accord with her..
I write a propose for this to my boss.
thanks..
ReplyHi atul,
I am a Oracle Engineer, working in a MNC in india from last 4 year in DBA domain, but i did’t get as much exposure as experience i m showing. now i want to switch move farward. I am looking forward for Apps DBA, What you suggest to me for this? help me or suggest how i can move to apps dba or i should stay in oracle DBA
i am 10g ocp certified,and also RHCT.
Thanks
Arun
@ Arun,
Both DBA and Apps DBA are good , Do what you enjoy most .