Home » RDBMS Server » Backup & Recovery » Regarding Cold Backup (9i,10g)
Regarding Cold Backup [message #392137] Mon, 16 March 2009 10:09 Go to next message
asmfloyd
Messages: 2
Registered: March 2009
Junior Member
Hi all,
I am new to DB backups.I have 2 questions which are as follows:

Que1.
If I do a cold backup using RMAN which is as follows:
"backup database"

Under which path by defalut the back up gets saved?Is it under the same path as
C:\Oracle\oradata\dbname
Or is it under some other path?

Que2.I can do a cold back by finding the path of the files:
select * from v$datafile;
select * from v$controlfile;
select * from v$logfile;
Get the path from the above three queries.Go there and copy all the files.In this backup, why I need to shut down the database before copying the files?Why can't I copy the files while the database is running too?

Please let me know.

Thanks,
Floyd
Re: Regarding Cold Backup [message #392140 is a reply to message #392137] Mon, 16 March 2009 10:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on various parameters set.
You can manually control it inside rman script.

>>I can do a cold back by finding the path of the files:
You dont have to. It is old school. RMAN will just backup everything required for you.
>>Why can't I copy the files while the database is running too?

Because it is 'cold' bakup. You do a consistent backup. otherwise, you need to a hot backup.
if you are doing with rman, just bring the database to mount stage.
Re: Regarding Cold Backup [message #392142 is a reply to message #392140] Mon, 16 March 2009 10:35 Go to previous messageGo to next message
asmfloyd
Messages: 2
Registered: March 2009
Junior Member
Thanks Mahesh for the immediate response.
I)Then can you tell me how I will point the output of "backup database",to a particular folder(Say D:\backup).I did some backup by saying "backup database".But I do not know now under which path it got saved to. (:
II) Ok.So you mean like if I copy the same files while the DB is running(as a hot backup),still the same will work (till the point to which I took the backup)?
Sorry for troubling much
Re: Regarding Cold Backup [message #392144 is a reply to message #392137] Mon, 16 March 2009 10:43 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
The following & others can be found at http://tahiti.oracle.com

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: Regarding Cold Backup [message #392145 is a reply to message #392142] Mon, 16 March 2009 10:44 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i)use allocate channel or set it in RMAN configuration.
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta4.htm
ii)>>Ok.So you mean like if I copy the same files while the DB is running
I never said that.
I said, you do not copy the files with RMAN (hot or cold).
Copying the files is old school, user managed backups.
With RMAN use
rman> backup database;

if you are doing RMAN hot, use
rman> backup database plus archivelog


And just refer docs. It is all written there.
And please search this forum/google/docs before posting.
Previous Topic: Database transform with RMAN
Next Topic: TSPITR via RMAN in a Data Guard Environment
Goto Forum:
  


Current Time: Tue Dec 06 00:27:22 CST 2016

Total time taken to generate the page: 0.22049 seconds