Solved

RMAN cold backup

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

Suggested Solutions

Title # Comments Views Activity
database upgrade 8 75
ORA-00923: FROM keyword not found where expected 3 62
Repeat query 13 46
Error querying database link from Oracle 10g to Postgresql 7 32
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…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

772 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