Hello.
I'm using Oracle 9.2.0.1.0 under AIX 5.1 to replicate a database using a 3rd party tool which we develop.
I wrote scripts to put the tablespace in hotbackup mode but the postcmd script with command "alter system switch logfile" just hangs when executed the second time
from sqlplus, it works twice but hangs on the 3rd time
SQL> alter tablespace EXAMPLE begin backup
Tablespace altered
SQL> alter tablespace EXAMPLE end backup
Tablespace altered
SQL> alter database backup controlfile to trace;
Database altered
SQL> alter system switch logfile
System altered
SQL> alter tablespace EXAMPLE begin backup
Tablespace altered
SQL> alter tablespace EXAMPLE end backup
Tablespace altered
SQL> alter database backup controlfile to trace;
Database altered
SQL> alter system switch logfile
System altered
SQL> alter tablespace EXAMPLE begin backup
Tablespace altered
SQL> alter tablespace EXAMPLE end backup
Tablespace altered
SQL> alter database backup controlfile to trace;
Database altered
SQL> alter system switch logfile
HANGS AT THIS TIME UNTIL I KILL THE TASK
I uncommented LOG_ARCHIVE_START and LOG_ARCHIVE_DEST in the init.ora, bounced the instance but it doesn't make any changes
I'm not a DBA and usually get all the help from this group or from Metalink. Am I doing something wrong ??
- Also, Which SQL command shows if the tablespace is in hotbackup mode or not ??
Thanks in advance
Regards
Gaetan
I'm using Oracle 9.2.0.1.0 under AIX 5.1 to replicate a database using a 3rd party tool which we develop.
I wrote scripts to put the tablespace in hotbackup mode but the postcmd script with command "alter system switch logfile" just hangs when executed the second time
from sqlplus, it works twice but hangs on the 3rd time
SQL> alter tablespace EXAMPLE begin backup
Tablespace altered
SQL> alter tablespace EXAMPLE end backup
Tablespace altered
SQL> alter database backup controlfile to trace;
Database altered
SQL> alter system switch logfile
System altered
SQL> alter tablespace EXAMPLE begin backup
Tablespace altered
SQL> alter tablespace EXAMPLE end backup
Tablespace altered
SQL> alter database backup controlfile to trace;
Database altered
SQL> alter system switch logfile
System altered
SQL> alter tablespace EXAMPLE begin backup
Tablespace altered
SQL> alter tablespace EXAMPLE end backup
Tablespace altered
SQL> alter database backup controlfile to trace;
Database altered
SQL> alter system switch logfile
HANGS AT THIS TIME UNTIL I KILL THE TASK
I uncommented LOG_ARCHIVE_START and LOG_ARCHIVE_DEST in the init.ora, bounced the instance but it doesn't make any changes
I'm not a DBA and usually get all the help from this group or from Metalink. Am I doing something wrong ??
- Also, Which SQL command shows if the tablespace is in hotbackup mode or not ??
Thanks in advance
Regards
Gaetan