How to backup oracle control file with database agent(rman integration) for Netbackup or Dataprotector

** Myself and Web
Method Backup controlfile (After backup done).
M1) Use OS method  by copy controlfile to other path or tape(post script call policy or backuspec file system) and restore by restore file system from NBU/DP

M2) Use oracle method by sqlplus script for 'alter database backup control file to '<path>'; and restore by os method

M3) Use oracle recovery catalog but  need know rman command for restore and concept.

M4) NBU/DP must be set autobackup controlfile for transfer to in backup tape.
Method Restore Control file
M1) In case backup to OS path replace by os copy command /In case backup to tape by file system will be restore by file system policy/backupspec.

M2) Replace by os copy command from OS backup path.

M3) Use rman catalog command. Example
rman targe / catalog "<catdb user>/<catdb password>"
restore controlfile;
M4.1) for NBU Step
1.Log onto the host as the Oracle user
2.Connect to the target database
3.Locate and set the DBID
4.Connect to the target database
5.Start Oracle in NOMOUNT
6.Run the appropriate configuration and restore string
7.Restore controlfile
8.Change Oracle to Mount Mode
su - <orauser>
rman target /
set dbid 1234567891;
startup nomount;
run {
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_POLICY=ORACLE_HISTO,NB_ORA_SERV=backupserver';
restore controlfile from autobackup maxdays=9 maxseq 5;
mount database;
}
 
M4.2) for DP Step same as NBU but **** looks for the older backupsets for controlfile ('c-1234567890-12345678-00’)  or by autobackup
su - <orauser>
rman target /
set dbid 1234567891;
startup nomount;
run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=central,OB2BARLIST=BACKUP_SPEC_NAME,OB2BARHOSTNAME=servername)';
restore controlfile from 'c-1234567890-12345678-00';
alter database mount;
}

0 comments:

Loading