How to backup and restore Oracle controlfile with nocatalog rman mode

[Krisw]

I run rman with nocatalog mode. How can I backup controlfile to have possibility to restore this from NetWorker in case of disaster.

Thank in advance

 

[Rexxy]

RMAN should be backing up everything when a Level 0 is performed, the "nocatalog" just means your backup is not updated the RMAN catalog server.

try this to see if the controlfile is in fact being backed up...
RMAN> backup full database filesperset 1;
This will be your Level 0 backup

RMAN> list backup of controlfile summary;
take note of rman keyset # (e.g 1234)

RMAN> list backupset 1234;
Now take note of TAG #

RMAN> list backup of database summary;
Compare the TAG#'s

there is a lot more that can be done, but i am a networker person, not oracle....but this should help.

 

[a060463xyz]

Newer implementations of Orcale have an controlfile autobackup activated. If your oracle version does not support this, or you are not comfortable with it, you can put following line at the end of the rman commandfile :

UX :
connect target ....
run
{
... all other commands

sql"ALTER DATABASE BACKUP CONTROLFILE TO ''/orasik/ctrl.bak'' REUSE";
}

Windows:
sql"ALTER DATABASE BACKUP CONTROLFILE TO ''C:\orasik\ctrl.bak'' REUSE";


keep in mind when running under Linux/Unix the oracle user who owns the rman process has to have sufficient filesystem rights in the target directory.
Under Windows normaly everyone has "full control" in the filesystems so everything should work.
You have to create the targetfile once eg. using touch
You can use a post commands with nmo 4.2 and later so a

save -s servername -c clientname -g groupname /orasik/ctrl.bak

as an postcommand would save the controlfile to tape.

 

[Krisw]

Thank you for the advices.

I try to precise my problem:
1. Oracle restores data according the backup information data located in Oracle controlfile.
I assume that I make controlfile backups from rman only (not by file) and I lose the whole database with all files. Is any possibility to restore the controlfile saved by rman from NetWorker on a newly created Oracle database in this situation?

2. On the other hand – which way backup Oracle controlfile by file.
I use only one nsrnsmo.bat file for many type of backup by many groups (only rman scripts varied).
To version 3.5 of nsrnmo I used modified nsrnsmo.bat by move “SET POSTCMD” to other place in the script to use command arguments:

…
REM
REM Execute the backup command
REM
SET args=%*
SET POSTCMD=F:\rman\cfiles.bat %args%
nsrnmostart %args%
…

As of version 4.1 of nsrnmo such construction has still worked, but when Oracle backup fail NetWorker group has incorrect status “successful”.

Is any possibility to run command set as POSTCMD in nsrnmo.bat with all command arguments (information about NetWorker pool, group, expiration time, etc)?

 

[a060463xyz]

To make automatic controlfile backups via rman
start rman :
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON
You have to do this only once.

For Recovery you maust use the

RESTORE CONTROLFILE FROM AUTOBACKUP;

command with rman

Now to your command arguments :

why dont you use the rman script to provide this informations :

send channel t1 'NSR_ENV=(NSR_SERVER=myNWserver, NSR_DATA_VOLUME_POOL=Default, NSR_CLIENT=myclient)';