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.
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.
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.