Solved

RMAN cold backup

Posted on 2004-03-30
7
4,349 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 200 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
oracle query help 18 78
PL/SQL LOOP CURSOR 3 40
dates - loop 12 41
SQL Retrieve Values 4 43
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now