Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

RMAN cold backup

Posted on 2004-03-30
7
Medium Priority
?
4,384 Views
Last Modified: 2008-03-10
Oracle Version: Oracle8 Enterprise Edition Release 8.0.5
O/S: Windows NT 4.0

I am planning a full cold backup of my NOARCHIVELOG mode database using RMAN.

Example of a full backup with RMAN:

RMAN> run {
2> allocate channel dev1 type disk;
3> backup full
4> format '/tmp/backup_dir/db_t%t_s%s_p%p' (database);
5> release channel dev1;
6> }

Question: Is the control file being backed up in the above RMAN script or do I have to back up the control file separately?

Thank you
0
Comment
Question by:algotube
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 23

Expert Comment

by:seazodiac
ID: 10713776
I am positive that In oracle8 , Oracle RMAN cannot backup controlfile when it backup the database.

so you have to manually backup the control file...
0
 

Author Comment

by:algotube
ID: 10713910
Thank you seazodiac for you response if I use

RMAN> run {
2> allocate channel dev1 type disk;
3> backup full
4> format '/tmp/backup_dir/db_t%t_s%s_p%p' (database);
5> release channel dev1;
6> }

to take a full backup of my database, and backup my control files manually.

What would I use to recover from a cold backup? Let's assume that my NOARCHIVELOG database is lost due to a total media failure and requries a full database recovery. Am I on the right track if I use this?

the database is in the NOMOUNT state

RMAN> run {
allocate channel t1 type disk;
restore controlfile to '/ora05/oracle/data/testo82/control01.ctl';
restore controlfile to '/ora05/oracle/data/testo82/control02.ctl';
restore controlfile to '/ora05/oracle/data/testo82/control03.ctl';
sql "alter database mount";
restore database;
sql "alter database open resetlogs";
 }

Thank you
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 10713964
No need to put "restore controlfile" clause.

once database is crashed, you just need to manually put back the controlfile and then issue
RMAN> run {
allocate channel t1 type disk;
sql "alter database mount";
restore database;
sql "alter database open resetlogs";
}
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:algotube
ID: 10714126
Seazodiac:  

Could I use this to take a physical backup of the control file:

Svrmgrl> ALTER DATABASE
                   BACKUP CONTROLFILE TO
                  ‘G:\Oracle\Controlfile\Backups\ctl1pps.ora’ REUSE;

Or a logical backup of the control file:

Svrmgr> ALTER DATABASE
                  BACKUP CONTROLFILE TO
                  TRACE;


How would I put back the controlfile if the database crashes?


Thanks again (very much needed)

0
 
LVL 23

Accepted Solution

by:
seazodiac earned 800 total points
ID: 10714144
use the binary backup format , that's including some critical information not available from text format backup
0
 

Author Comment

by:algotube
ID: 10715939
Ok if I use the binary backup format

Svrmgrl> ALTER DATABASE
                   BACKUP CONTROLFILE TO
                  ‘G:\Oracle\Controlfile\Backups\ctl1pps.ora’ REUSE;

Once again how would I put back the controlfile if the database crashes? Would I use RESTORE can you provide an example:

Thanks

0
 
LVL 23

Expert Comment

by:seazodiac
ID: 10715965
you just need to copy that control file back to where it should be..

you don't need to issue restore command...

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question