Solved

RMAN cold backup

Posted on 2004-03-30
7
4,357 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.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
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.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

821 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