Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4393
  • Last Modified:

RMAN cold backup

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
algotube
Asked:
algotube
  • 4
  • 3
1 Solution
 
seazodiacCommented:
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
 
algotubeAuthor Commented:
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
 
seazodiacCommented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
algotubeAuthor Commented:
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
 
seazodiacCommented:
use the binary backup format , that's including some critical information not available from text format backup
0
 
algotubeAuthor Commented:
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
 
seazodiacCommented:
you just need to copy that control file back to where it should be..

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

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now