RMAN Configuration for 2 nodes RAC Database

[habeebksa]

Hi, How to create rman catalog and register database for 2 nodes RAC. Is the procedure same as of single database. I want to take backup using RMAN by creating catalog and registering RAC database on another Sun server consists of oracle 9i database, for my 2 nodes oracle 9i RAC database.

All the datafiles are stored in SAN storage and for archivelogs the drive is shared for the two nodes.


thanks,

[davey23uk]

why dont you read the docs which go over all of this?

[habeebksa]

Hi, I have gone through the Oracle 9i RMAN documentation of oracle press. But sorry to say that I didn't found the method for creating catalog and registering the target RAC database in the manual.

My question is:

Is it the same procedure to create catalog and register database for RAC DB with 2 nodes as of Single Production DB.

since there are two nodes and a shared external storage which contains database files and archive logs, when I register the target database in recovery catalog database which is on different system and issue the RMAN>backup database plus archivelog; does archive logs are backed up from both the nodes along with datafiles.

Thanks,

[hrishy]

Hi

If the archived redologs are on the clustered filesystems (and i strongly advise you to use a clustered file system) and both the nodes can see the filesystem and it is properly configured then yes

BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

This will work perfectly

You should read the RMAN docs and its all documented there

http://download.oracle.com/docs/cd/B...ops.htm#443638



regards
Hrishy

[habeebksa]

Hi, thanks for the answers.

Currently Iam taking RMAN full weekly backups on node 1, I can store only one weekly backup on node 1 due to space shortage. So first I delete the previous weekly backup before taking new weekly backup.

After successfully taking the backup using
RMAN>backup database plus archivelog;

the backup files are written to disk and on tape.

But when I issue
RMAN>crosscheck backup completed before 'sysdate';
RMAN shows the latest backup files as "Expired". It should have shown as "Available" as the files are physically present on disk, i have not deleted the latest backup files.

Note: My catalog database is on another solaris machine.

Question: Why RMAN is not treating the latest backup files as Available.

One more thing: Iam getting a Solaris operating system message on node 1 as,

message overflow on /dev/log minor #6 -- is syslogd (1M) running?

Question: Is this the reason RMAN is not treating the files as Available, but it is reading the directory as it is displaying the backup files as Expired.


Your kind help is appreciated,

thanks,

[hrishy]

Hi

What commnad do you use to delete those backups

The solaris error has nothing to do with rman

regards
Hrishy

[habeebksa]

Hi, I go to rman backup directory and give rm* command, to delete the backup files from operating system.


thanks,